1. Home
  2. Resources
  3. SAP Tables
  4. BAPI1068T19 - Table Parameters: Item Data (GetDetail-BAPI)

SAP Table BAPI1068T19

Table Parameters: Item Data (GetDetail-BAPI)

BAPI1068T19 (Table Parameters: Item Data (GetDetail-BAPI)) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link BAPI1068T19 to other SAP tables.

BAPI1068T19 table fields

Field Data element Checktable Datatype Length Decimals
MATERIAL Material Number MATNR MARA CHAR 18 0
MATL_DESC Material Description (Short Text) MAKTX CHAR 40 0
SALES_UNIT Sales unit W_MEBME T006 UNIT 3 0
SALES_UNIT_ISO Sales unit in ISO code W_MEBME_ISO T006I CHAR 3 0
MATL_CAT Material Category ATTYP CHAR 2 0
NULL Single material (industry)
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 SATNR MARA CHAR 18 0
PR_REF_MAT Pricing Reference Material PMATN MARA CHAR 18 0
MATL_GROUP Material Group MATKL T023 CHAR 9 0
ITEM_NO Promotion Item Number W_AKPOS NUMC 6 0
THEME Promotion theme W_AKTHE TWAT CHAR 4 0
THEME_DESC Promotion theme description W_AKTHETX CHAR 20 0
MIN_ORD_QTY Minimum order qty for promotional material W_MIAMG QUAN 13 3
PLND_SALES_QTY Planned Sales Qty. of Promotion Material in Sales Units W_PABBM QUAN 13 3
SALES_PRICE Sales price (gross) W_PLVKP_BAPI DEC 23 4
SALES_CURRENCY Currency current promotion - planning W_WAELA TCURC CUKY 5 0
SALES_CRRNCY_ISO Planned sales currency in ISO code W_WAELA_ISO CHAR 3 0
SALES_PR_UNIT Sales price unit VPEIN DEC 5 0
STANDARD_SP Standard Sales Price W_NVKP_BAPI DEC 23 4
PP_GROSS Purchase Price W_PLEKP_BAPI DEC 23 4
PP_CURRENCY Purchase price currency W_WAEEK TCURC CUKY 5 0
PP_CRRNCY_ISO Purchasing currency in ISO code W_WAEEK_ISO CHAR 3 0
PP_UNIT Price Unit EPEIN DEC 5 0
ORDERPR_UN Order Price Unit (Purchasing) BBPRM T006 UNIT 3 0
ORDERPR_UN_ISO ISO code for purchase order price unit BBPRM_ISO T006I CHAR 3 0
RETURN_TYPE Return type for promotional material W_RGART CHAR 1 0
1 No return
2 Return to DC
3 Return to vendor
RET_TYPE_DESC Return type description (from domain) W_RUEAR CHAR 60 0
ORDER_FROM Earliest Order Date W_FADAT DATS 8 0
ORDER_TO Latest Order Date W_SADAT DATS 8 0
DELIVERY_FROM Earliest delivery date W_FLDAT DATS 8 0
DELIVERY_TO Latest delivery date W_SLDAT DATS 8 0
ORD_DATE_VENDOR Order date with vendor W_BEDAT DATS 8 0
PLND_ALLOC_QTY Planned allocation quantity for an allocation table item W_PMNGU QUAN 13 3
ALLOC_UNIT Allocation Unit AUFME T006 UNIT 3 0
ALLOC_UNIT_ISO Allocation table unit of measure in ISO code AUFME_ISO T006I CHAR 3 0
ALLOC_TBL Allocation Table Number ABELN AUKO CHAR 10 0
ALLOC_TBL_ITEM Item number of allocation table ABELP AUPO NUMC 5 0
ITEM_CATEGORY Item category of allocation table APSTP T621 CHAR 4 0
ALLOC_RULE Retail Promotion: Allocation Rule Number VREGE SVKO CHAR 10 0
BLOCK_REASON Reason for promotion block W_SPGRU CHAR 1 0
A Delivery difficulties
B Procurement unclear
C Material damaged
D Other
F Plant deleted
BLOCK_REASN_DESC Item blocking reason text W_SPGRT CHAR 60 0
BLOCK_DATE Date on which promotion material is blocked for promotion W_SPDAT DATS 8 0
TURNOVER_SALES_PRICE Material Sales at Sales Price W_PUMVP_BAPI DEC 23 4
TURNOVER_PURCH_PRICE Material Sales at Purchase Price in Sales Currency W_PUMEP_BAPI DEC 23 4
CREATED_BY Name of Person who Created the Object ERNAM CHAR 12 0
CREATED_ON Date on Which Record Was Created ERDAT DATS 8 0
CHANGED_BY Name of Person Who Changed Object AENAM CHAR 12 0
CHANGED_ON Changed On AEDAT DATS 8 0
PRICE_POINT_GROUP Price Point Group, Promotion Item W_EPRGR TWPK CHAR 6 0
SALES_PRICE_STATUS Maintenance status of sales price conditions W_VKKPS CHAR 1 0
NULL Not active
A Sales price activated, conditions not created
B Sales price activated, conditions created
C Sales price changed at item level, not activated
D Error during activation
E Sales price changed at plant level, not activated
F Sales price deactivated, condition deleted
SALES_PRICE_STATUS_DESC Status description for sales price activation W_TVKST CHAR 60 0
PURCH_PRICE_STATUS Maintenance status of purchase price conditions W_EKKPS CHAR 1 0
NULL Not active
A Purchase price activated, conditions not created
B Purchase price activated, conditions created
C Purchase price changed at item level, not activated
D Error during activation
E Purchase price changed at plant level, not activated
F Purchase price deactivated, condition deleted
PURCH_PRICE_STATUS_DESC Status description for purchase price activation W_TEKST CHAR 60 0
DC_PRICE_STATUS Maintenance status of DC conditions W_VZKPS CHAR 1 0
NULL Not active
A DC price active, condition not created
B DC price active, condition created
D Error during activation
F DC price deactivated, condition deleted
DC_PRICE_STATUS_DESC Text for status of DC transfer price activation W_TVZKST CHAR 60 0
SUPPLY_SOURCE_STATUS Supply Source Determination Status W_BZQFI CHAR 1 0
NULL Supply source determin. not yet carried out
A Supply source determin. not carried out for all plants
B Supply source determ. carried out for all plants
C Supply source determin. partial (old)
D Supply source determin. faulty for at least one plant (old)
SUPPLY_SOURCE_STATUS_DESC Name of Status for Supply Source Determination BZQFI_TXT CHAR 60 0
LISTING_STATUS Item status, listing W_AKBSP CHAR 1 0
NULL Listing not carried out
B Listing carried out
LISTING_STATUS_DESC Name of Listing Status for Promotion Item W_STLITP CHAR 60 0
ALLOC_STRATEGY Retail Promotion: Allocation Strategy W_ASTRA T627 CHAR 4 0
CONF_MATL_EXTERNAL Long Material Number for CONF_MATL field MGV_CONF_MATL_EXTERNAL CHAR 40 0
CONF_MATL_GUID External GUID for CONF_MATL Field MGV_CONF_MATL_GUID CHAR 32 0
CONF_MATL_VERSION Version Number for Field CONF_MATL MGV_CONF_MATL_VERSION CHAR 10 0
MATERIAL_EXTERNAL Long Material Number for MATERIAL Field MGV_MATERIAL_EXTERNAL CHAR 40 0
MATERIAL_GUID External GUID for MATERIAL Field MGV_MATERIAL_GUID CHAR 32 0
MATERIAL_VERSION Version Number for MATERIAL Field MGV_MATERIAL_VERSION CHAR 10 0
PR_REF_MAT_EXTERNAL Long Material Number for PR_REF_MAT Field MGV_PR_REF_MAT_EXTERNAL CHAR 40 0
PR_REF_MAT_GUID External GUID for PR_REF_MAT Field MGV_PR_REF_MAT_GUID CHAR 32 0
PR_REF_MAT_VERSION Version Number for PR_REF_MAT Field MGV_PR_REF_MAT_VERSION CHAR 10 0
REB_VALUE Value of Absolute Discount REB_VALUE_BAPI DEC 23 4
REB_PERC Percentage Discount REB_PERC DEC 5 2
OFFER_TYPE Offer Type Price RDM_OFFER_TYPE_PRICE CHAR 2 0
01 Standard Sales Price
02 Promotion Sales Price
OFFER_TYPE_DESC Offer Type Description RDM_OFFER_TYPE_TEXT CHAR 60 0
OFFER_TYPE_DISCOUNT Offer Type Discount RDM_OFFER_TYPE_DISCOUNT CHAR 2 0
03 Absolute Discount
04 Percentage Discount
OFFER_TYPE_DISCOUNT_DESC Offer Type Description RDM_OFFER_TYPE_TEXT CHAR 60 0
OFFER_ID Offer ID for Price WPM_OFFERID_PRICE CHAR 36 0
OFFER_ID_DISCOUNT Offer ID for Discount WPM_OFFERID_DISCOUNT CHAR 36 0
OFFER_PRODUCT_GROUP Product Group in Offer (Price) WPM_OFFER_PRODUCT_GROUP_PRICE NUMC 3 0
OFFER_PRODUCT_GROUP_DISCOUNT Product Group in Offer (Discount) WPM_OFFER_PRODUCT_GROUP_DSCNT NUMC 3 0
ITEM_CREATE_INDICATOR Promotion Item Indicator for Transferred Materials WPM_PROMO_ITEM CHAR 1 0
X Yes
NULL No
OFFER_PRICE_QTY Planned sales qty in sales units for material in price offer W_PABBM_OFFER_PRC QUAN 13 3
OFFER_DISCOUNT_QTY Planned sales qty in sales units of material in discnt offer W_PABBM_OFFER_DSC QUAN 13 3

BAPI1068T19 foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
BAPI1068T19 ALLOC_RULE SYST MANDT SVKO Allocation Rule / IS-R Allocation MANDT
BAPI1068T19 ALLOC_RULE BAPI1068T19 ALLOC_RULE SVKO Allocation Rule / IS-R Allocation SBELN
BAPI1068T19 ALLOC_STRATEGY SYST MANDT T627 Allocation Strategy: Allocation Table MANDT
BAPI1068T19 ALLOC_STRATEGY BAPI1068T19 ALLOC_STRATEGY T627 Allocation Strategy: Allocation Table ASTRA
BAPI1068T19 ALLOC_TBL SYST MANDT AUKO Allocation Table Document Header MANDT
BAPI1068T19 ALLOC_TBL BAPI1068T19 ALLOC_TBL AUKO Allocation Table Document Header ABELN
BAPI1068T19 ALLOC_TBL_ITEM BAPI1068T19 ALLOC_TBL_ITEM AUPO Allocation Table Document Item ABELP
BAPI1068T19 ALLOC_TBL_ITEM SYST MANDT AUPO Allocation Table Document Item MANDT
BAPI1068T19 ALLOC_TBL_ITEM BAPI1068T19 ALLOC_TBL AUPO Allocation Table Document Item ABELN
BAPI1068T19 ALLOC_UNIT SYST MANDT T006 Units of Measurement MANDT
BAPI1068T19 ALLOC_UNIT BAPI1068T19 ALLOC_UNIT T006 Units of Measurement MSEHI
BAPI1068T19 ALLOC_UNIT_ISO BAPI1068T19 ALLOC_UNIT_ISO T006I ISO codes for units of measurement ISOCODE
BAPI1068T19 ALLOC_UNIT_ISO SYST MANDT T006I ISO codes for units of measurement CLIENT
BAPI1068T19 CONF_MATL SYST MANDT MARA General Material Data MANDT
BAPI1068T19 CONF_MATL BAPI1068T19 CONF_MATL MARA General Material Data MATNR
BAPI1068T19 ITEM_CATEGORY SYST MANDT T621 Item Categories for Allocation Tables MANDT
BAPI1068T19 ITEM_CATEGORY BAPI1068T19 ITEM_CATEGORY T621 Item Categories for Allocation Tables APSTP
BAPI1068T19 MATERIAL SYST MANDT MARA General Material Data MANDT
BAPI1068T19 MATERIAL BAPI1068T19 MATERIAL MARA General Material Data MATNR
BAPI1068T19 MATL_GROUP BAPI1068T19 MATL_GROUP T023 Material Groups MATKL
BAPI1068T19 MATL_GROUP SYST MANDT T023 Material Groups MANDT
BAPI1068T19 ORDERPR_UN SYST MANDT T006 Units of Measurement MANDT
BAPI1068T19 ORDERPR_UN BAPI1068T19 ORDERPR_UN T006 Units of Measurement MSEHI
BAPI1068T19 ORDERPR_UN_ISO SYST MANDT T006I ISO codes for units of measurement CLIENT
BAPI1068T19 ORDERPR_UN_ISO BAPI1068T19 ORDERPR_UN_ISO T006I ISO codes for units of measurement ISOCODE
BAPI1068T19 PP_CURRENCY SYST MANDT TCURC Currency Codes MANDT
BAPI1068T19 PP_CURRENCY BAPI1068T19 PP_CURRENCY TCURC Currency Codes WAERS
BAPI1068T19 PRICE_POINT_GROUP SYST MANDT TWPK Sales price calculation: price point groups MANDT
BAPI1068T19 PRICE_POINT_GROUP BAPI1068T19 PRICE_POINT_GROUP TWPK Sales price calculation: price point groups EPRGR
BAPI1068T19 PR_REF_MAT BAPI1068T19 PR_REF_MAT MARA General Material Data MATNR
BAPI1068T19 PR_REF_MAT SYST MANDT MARA General Material Data MANDT
BAPI1068T19 SALES_CURRENCY SYST MANDT TCURC Currency Codes MANDT
BAPI1068T19 SALES_CURRENCY BAPI1068T19 SALES_CURRENCY TCURC Currency Codes WAERS
BAPI1068T19 SALES_UNIT SYST MANDT T006 Units of Measurement MANDT
BAPI1068T19 SALES_UNIT BAPI1068T19 SALES_UNIT T006 Units of Measurement MSEHI
BAPI1068T19 SALES_UNIT_ISO SYST MANDT T006I ISO codes for units of measurement CLIENT
BAPI1068T19 SALES_UNIT_ISO BAPI1068T19 SALES_UNIT_ISO T006I ISO codes for units of measurement ISOCODE
BAPI1068T19 THEME BAPI1068T19 THEME TWAT Promotion themes, IS-R AKTHE
BAPI1068T19 THEME SYST MANDT TWAT Promotion themes, IS-R MANDT