SAP table BAPI1068T19 (Table Parameters: Item Data (GetDetail-BAPI))

Field Description Data Type Length Decimals Checktable Data Element
MATERIAL Material Number (18 Characters) CHAR 18 0 MATNR18
MATL_DESC Material Description CHAR 40 0 MAKTX
SALES_UNIT Sales unit UNIT 3 0 * W_MEBME
SALES_UNIT_ISO Sales unit in ISO code CHAR 3 0 * W_MEBME_ISO
MATL_CAT Material Category CHAR 2 0 ATTYP
Product
00 Single material
01 Generic material
02 Variant
10 Sales set
11 Prepack
12 Display
20 Material group material
21 Hierarchy material
22 Group material
30 Material group reference material
CONF_MATL Cross-Plant Configurable Material (18 ch compatibility mode) CHAR 18 0 SATNR18
PR_REF_MAT Pricing Reference Material CHAR 18 0 PMATN18
MATL_GROUP Material Group CHAR 9 0 T023 MATKL
ITEM_NO Promotion Item Number NUMC 6 0 W_AKPOS
THEME Promotion theme CHAR 4 0 TWAT W_AKTHE
THEME_DESC Promotion theme description CHAR 20 0 W_AKTHETX
MIN_ORD_QTY Minimum order qty for promotional material QUAN 13 3 W_MIAMG
PLND_SALES_QTY Planned Sales Qty. of Promotion Material in Sales Units QUAN 13 3 W_PABBM
SALES_PRICE Sales price (gross) DEC 23 4 W_PLVKP_BAPI
SALES_CURRENCY Currency Current Promotion - Planning CUKY 5 0 TCURC W_WAELA
SALES_CRRNCY_ISO Planned sales currency in ISO code CHAR 3 0 W_WAELA_ISO
SALES_PR_UNIT Sales price unit DEC 5 0 VPEIN
STANDARD_SP Standard Sales Price DEC 23 4 W_NVKP_BAPI
PP_GROSS Purchase Price DEC 23 4 W_PLEKP_BAPI
PP_CURRENCY Purchase price currency CUKY 5 0 TCURC W_WAEEK
PP_CRRNCY_ISO Purchasing currency in ISO code CHAR 3 0 W_WAEEK_ISO
PP_UNIT Price unit DEC 5 0 EPEIN
ORDERPR_UN Order Price Unit (Purchasing) UNIT 3 0 T006 BBPRM
ORDERPR_UN_ISO ISO code for purchase order price unit CHAR 3 0 T006I BBPRM_ISO
RETURN_TYPE Return type for promotional material CHAR 1 0 W_RGART
RET_TYPE_DESC Return type description (from domain) CHAR 60 0 W_RUEAR
ORDER_FROM Earliest Order Date DATS 8 0 W_FADAT
ORDER_TO Latest Order Date DATS 8 0 W_SADAT
DELIVERY_FROM Earliest delivery date DATS 8 0 W_FLDAT
DELIVERY_TO Latest delivery date DATS 8 0 W_SLDAT
ORD_DATE_VENDOR Order Date with Supplier DATS 8 0 W_BEDAT
PLND_ALLOC_QTY Planned allocation quantity for an allocation table item QUAN 13 3 W_PMNGU
ALLOC_UNIT Allocation Unit UNIT 3 0 T006 AUFME
ALLOC_UNIT_ISO Allocation table unit of measure in ISO code CHAR 3 0 T006I AUFME_ISO
ALLOC_TBL Allocation Table CHAR 10 0 AUKO ABELN
ALLOC_TBL_ITEM Allocation Table Item NUMC 5 0 AUPO ABELP
ITEM_CATEGORY Item category of allocation table CHAR 4 0 T621 APSTP
ALLOC_RULE Retail Promotion: Allocation Rule Number CHAR 10 0 SVKO VREGE
BLOCK_REASON Reason for promotion block CHAR 1 0 W_SPGRU
BLOCK_REASN_DESC Item blocking reason text CHAR 60 0 W_SPGRT
BLOCK_DATE Date on which promotion material is blocked for promotion DATS 8 0 W_SPDAT
TURNOVER_SALES_PRICE Material Sales at Sales Price DEC 23 4 W_PUMVP_BAPI
TURNOVER_PURCH_PRICE Material Sales at Purchase Price in Sales Currency DEC 23 4 W_PUMEP_BAPI
CREATED_BY Name of Person Responsible for Creating the Object CHAR 12 0 ERNAM
CREATED_ON Date on which the record was created DATS 8 0 ERDAT
CHANGED_BY Name of Person Who Changed Object CHAR 12 0 AENAM
CHANGED_ON Last Changed On DATS 8 0 AEDAT
PRICE_POINT_GROUP Price Point Group, Promotion Item CHAR 6 0 TWPK W_EPRGR
SALES_PRICE_STATUS Maintenance status of sales price conditions CHAR 1 0 W_VKKPS
SALES_PRICE_STATUS_DESC Status description for sales price activation CHAR 60 0 W_TVKST
PURCH_PRICE_STATUS Maintenance status of purchase price conditions CHAR 1 0 W_EKKPS
PURCH_PRICE_STATUS_DESC Status description for purchase price activation CHAR 60 0 W_TEKST
DC_PRICE_STATUS Maintenance status of DC conditions CHAR 1 0 W_VZKPS
DC_PRICE_STATUS_DESC Text for status of DC transfer price activation CHAR 60 0 W_TVZKST
SUPPLY_SOURCE_STATUS Supply Source Determination Status CHAR 1 0 W_BZQFI
SUPPLY_SOURCE_STATUS_DESC Name of Status for Supply Source Determination CHAR 60 0 BZQFI_TXT
LISTING_STATUS Item status, listing CHAR 1 0 W_AKBSP
LISTING_STATUS_DESC Name of Listing Status for Promotion Item CHAR 60 0 W_STLITP
ALLOC_STRATEGY Retail Promotion: Allocation Strategy CHAR 4 0 T627 W_ASTRA
CONF_MATL_EXTERNAL Long Material Number for CONF_MATL field CHAR 40 0 MGV_CONF_MATL_EXTERNAL
CONF_MATL_GUID External GUID for CONF_MATL Field CHAR 32 0 MGV_CONF_MATL_GUID
CONF_MATL_VERSION Version Number for Field CONF_MATL CHAR 10 0 MGV_CONF_MATL_VERSION
MATERIAL_EXTERNAL Long Material Number for MATERIAL Field CHAR 40 0 MGV_MATERIAL_EXTERNAL
MATERIAL_GUID External GUID for MATERIAL Field CHAR 32 0 MGV_MATERIAL_GUID
MATERIAL_VERSION Version Number for MATERIAL Field CHAR 10 0 MGV_MATERIAL_VERSION
PR_REF_MAT_EXTERNAL Long Material Number for PR_REF_MAT Field CHAR 40 0 MGV_PR_REF_MAT_EXTERNAL
PR_REF_MAT_GUID External GUID for PR_REF_MAT Field CHAR 32 0 MGV_PR_REF_MAT_GUID
PR_REF_MAT_VERSION Version Number for PR_REF_MAT Field CHAR 10 0 MGV_PR_REF_MAT_VERSION
REB_VALUE Value of Absolute Discount DEC 23 4 REB_VALUE_BAPI
REB_PERC Percentage Discount DEC 5 2 REB_PERC
OFFER_TYPE Offer Type Price CHAR 2 0 RDM_OFFER_TYPE_PRICE
01 Standard Sales Price
02 Promotion Sales Price
OFFER_TYPE_DESC Offer Type Description CHAR 60 0 RDM_OFFER_TYPE_TEXT
OFFER_TYPE_DISCOUNT Offer Type Discount CHAR 2 0 RDM_OFFER_TYPE_DISCOUNT
03 Absolute Discount
04 Percentage Discount
OFFER_TYPE_DISCOUNT_DESC Offer Type Description CHAR 60 0 RDM_OFFER_TYPE_TEXT
OFFER_ID Offer ID for Price CHAR 36 0 WPM_OFFERID_PRICE
OFFER_ID_DISCOUNT Offer ID for Discount CHAR 36 0 WPM_OFFERID_DISCOUNT
OFFER_PRODUCT_GROUP Product Group in Offer (Price) NUMC 3 0 WPM_OFFER_PRODUCT_GROUP_PRICE
OFFER_PRODUCT_GROUP_DISCOUNT Product Group in Offer (Discount) NUMC 3 0 WPM_OFFER_PRODUCT_GROUP_DSCNT
ITEM_CREATE_INDICATOR Promotion Item Indicator for Transferred Materials CHAR 1 0 WPM_PROMO_ITEM
OFFER_PRICE_QTY Planned sales qty in sales units for material in price offer QUAN 13 3 W_PABBM_OFFER_PRC
OFFER_DISCOUNT_QTY Planned sales qty in sales units of material in discnt offer QUAN 13 3 W_PABBM_OFFER_DSC
MATERIAL_LONG Material No. CHAR 40 0 MATNR40
CONF_MATL_LONG Cross-Plant Configurable Material (40 ch tech. necessary) CHAR 40 0 SATNR40
PR_REF_MAT_LONG Pricing Reference Material CHAR 40 0 PMATN40

BAPI1068T19 foreign key relationships

Table Field Check Table Check Field
0 BAPI1068T19 ALLOC_RULE SVKO Allocation Rule / IS-R Allocation MANDT
0 BAPI1068T19 ALLOC_RULE SVKO Allocation Rule / IS-R Allocation SBELN
1 BAPI1068T19 ALLOC_TBL AUKO Allocation Table Document Header ABELN
0 BAPI1068T19 ALLOC_TBL_ITEM AUPO Allocation Table Document Item ABELN
0 BAPI1068T19 ALLOC_TBL_ITEM AUPO Allocation Table Document Item ABELP
1 BAPI1068T19 ALLOC_UNIT T006 Units of Measurement MANDT
0 BAPI1068T19 ALLOC_UNIT_ISO T006I ISO codes for units of measurement CLIENT
1 BAPI1068T19 MATL_GROUP T023 Material Groups MATKL
0 BAPI1068T19 ORDERPR_UN T006 Units of Measurement MANDT
0 BAPI1068T19 ORDERPR_UN T006 Units of Measurement MSEHI
1 BAPI1068T19 ORDERPR_UN_ISO T006I ISO codes for units of measurement CLIENT
0 BAPI1068T19 PP_CURRENCY TCURC Currency Codes WAERS
1 BAPI1068T19 PRICE_POINT_GROUP TWPK Sales price calculation: price point groups MANDT
0 BAPI1068T19 SALES_CURRENCY TCURC Currency Codes MANDT
0 BAPI1068T19 SALES_CURRENCY TCURC Currency Codes WAERS
1 BAPI1068T19 THEME TWAT Promotion themes, IS-R MANDT
1 BAPI1068T19 THEME TWAT Promotion themes, IS-R AKTHE