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

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-MD-PCT (Application Component) Product Catalog
     ⤷ WAKT (Package) Application development R/3 Promotions

Basic Data

Table Category	INTTAB	Structure
Structure	BAPI1068T19	Table Relationship Diagram
Short Description	Table Parameters: Item Data (GetDetail-BAPI)

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MATERIAL	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
2	MATL_DESC	☐	MAKTX	TEXT40	CHAR	40	0	Material description
3	SALES_UNIT	☐	W_MEBME	MEINS	UNIT	3	0	Sales unit	T006
4	SALES_UNIT_ISO	☐	W_MEBME_ISO	ISOCD_UNIT	CHAR	3	0	Sales unit in ISO code	T006I
5	MATL_CAT	☐	ATTYP	ATTYP	CHAR	2	0	Material Category
6	CONF_MATL	☐	SATNR	MATNR	CHAR	18	0	Cross-Plant Configurable Material	MARA
7	PR_REF_MAT	☐	PMATN	MATNR	CHAR	18	0	Pricing Reference Material	MARA
8	MATL_GROUP	☐	MATKL	MATKL	CHAR	9	0	Material Group	T023
9	ITEM_NO	☐	W_AKPOS	NUMC6	NUMC	6	0	Promotion Item Number
10	THEME	☐	W_AKTHE	THEMA	CHAR	4	0	Promotion theme	TWAT
11	THEME_DESC	☐	W_AKTHETX	TEXT20	CHAR	20	0	Promotion theme description
12	MIN_ORD_QTY	☐	W_MIAMG	MENGE	QUAN	13	3	Minimum order qty for promotional material
13	PLND_SALES_QTY	☐	W_PABBM	MENGE	QUAN	13	3	Planned Sales Qty. of Promotion Material in Sales Units
14	SALES_PRICE	☐	W_PLVKP_BAPI	BAPICURR	DEC	23	4	Sales price (gross)
15	SALES_CURRENCY	☐	W_WAELA	WAERS	CUKY	5	0	Currency current promotion - planning	TCURC
16	SALES_CRRNCY_ISO	☐	W_WAELA_ISO	ISOCD	CHAR	3	0	Planned sales currency in ISO code
17	SALES_PR_UNIT	☐	VPEIN	DEC5	DEC	5	0	Sales price unit
18	STANDARD_SP	☐	W_NVKP_BAPI	BAPICURR	DEC	23	4	Standard Sales Price
19	PP_GROSS	☐	W_PLEKP_BAPI	BAPICURR	DEC	23	4	Purchase Price
20	PP_CURRENCY	☐	W_WAEEK	WAERS	CUKY	5	0	Purchase price currency	TCURC
21	PP_CRRNCY_ISO	☐	W_WAEEK_ISO	ISOCD	CHAR	3	0	Purchasing currency in ISO code
22	PP_UNIT	☐	EPEIN	DEC5	DEC	5	0	Price unit
23	ORDERPR_UN	☐	BBPRM	MEINS	UNIT	3	0	Order Price Unit (purchasing)	T006
24	ORDERPR_UN_ISO	☐	BBPRM_ISO	ISOCD_UNIT	CHAR	3	0	ISO Code for Purchase Order Price Unit	T006I
25	RETURN_TYPE	☐	W_RGART	RGART	CHAR	1	0	Return type for promotional material
26	RET_TYPE_DESC	☐	W_RUEAR	DDTEXT	CHAR	60	0	Return type description (from domain)
27	ORDER_FROM	☐	W_FADAT	DATUM	DATS	8	0	Earliest Order Date
28	ORDER_TO	☐	W_SADAT	DATUM	DATS	8	0	Latest Order Date
29	DELIVERY_FROM	☐	W_FLDAT	DATUM	DATS	8	0	Earliest delivery date
30	DELIVERY_TO	☐	W_SLDAT	DATUM	DATS	8	0	Latest delivery date
31	ORD_DATE_VENDOR	☐	W_BEDAT	DATUM	DATS	8	0	Order date with vendor
32	PLND_ALLOC_QTY	☐	W_PMNGU	MENG13	QUAN	13	3	Planned allocation quantity for an allocation table item
33	ALLOC_UNIT	☐	AUFME	MEINS	UNIT	3	0	Allocation Unit	T006
34	ALLOC_UNIT_ISO	☐	AUFME_ISO	ISOCD_UNIT	CHAR	3	0	Allocation table unit of measure in ISO code	T006I
35	ALLOC_TBL	☐	ABELN	ABELN	CHAR	10	0	Allocation Table Number	AUKO
36	ALLOC_TBL_ITEM	☐	ABELP	ABELP	NUMC	5	0	Item number of allocation table	AUPO
37	ITEM_CATEGORY	☐	APSTP	APSTP	CHAR	4	0	Item category of allocation table	T621
38	ALLOC_RULE	☐	VREGE	SBELN	CHAR	10	0	Retail Promotion: Allocation Rule Number	SVKO
39	BLOCK_REASON	☐	W_SPGRU	SPGRU	CHAR	1	0	Reason for promotion block
40	BLOCK_REASN_DESC	☐	W_SPGRT	DDTEXT	CHAR	60	0	Item blocking reason text
41	BLOCK_DATE	☐	W_SPDAT	DATUM	DATS	8	0	Date on which promotion material is blocked for promotion
42	TURNOVER_SALES_PRICE	☐	W_PUMVP_BAPI	BAPICURR	DEC	23	4	Material Sales at Sales Price
43	TURNOVER_PURCH_PRICE	☐	W_PUMEP_BAPI	BAPICURR	DEC	23	4	Material Sales at Purchase Price in Sales Currency
44	CREATED_BY	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
45	CREATED_ON	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
46	CHANGED_BY	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
47	CHANGED_ON	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
48	PRICE_POINT_GROUP	☐	W_EPRGR	EPRGR	CHAR	6	0	Price Point Group, Promotion Item	TWPK
49	SALES_PRICE_STATUS	☐	W_VKKPS	VKKPS	CHAR	1	0	Maintenance status of sales price conditions
50	SALES_PRICE_STATUS_DESC	☐	W_TVKST	DDTEXT	CHAR	60	0	Status description for sales price activation
51	PURCH_PRICE_STATUS	☐	W_EKKPS	EKKPS	CHAR	1	0	Maintenance status of purchase price conditions
52	PURCH_PRICE_STATUS_DESC	☐	W_TEKST	DDTEXT	CHAR	60	0	Status description for purchase price activation
53	DC_PRICE_STATUS	☐	W_VZKPS	VZKPS	CHAR	1	0	Maintenance status of DC conditions
54	DC_PRICE_STATUS_DESC	☐	W_TVZKST	DDTEXT	CHAR	60	0	Text for status of DC transfer price activation
55	SUPPLY_SOURCE_STATUS	☐	W_BZQFI	BZQFA	CHAR	1	0	Supply Source Determination Status
56	SUPPLY_SOURCE_STATUS_DESC	☐	BZQFI_TXT	DDTEXT	CHAR	60	0	Name of Status for Supply Source Determination
57	LISTING_STATUS	☐	W_AKBSP	LISTSH	CHAR	1	0	Item status, listing
58	LISTING_STATUS_DESC	☐	W_STLITP	DDTEXT	CHAR	60	0	Name of Listing Status for Promotion Item
59	ALLOC_STRATEGY	☐	W_ASTRA	ASTRA	CHAR	4	0	Retail Promotion: Allocation Strategy	T627
60	CONF_MATL_EXTERNAL	☐	MGV_CONF_MATL_EXTERNAL	MATNR_EXT	CHAR	40	0	Long Material Number for CONF_MATL field
61	CONF_MATL_GUID	☐	MGV_CONF_MATL_GUID	MATNR_EGUID	CHAR	32	0	External GUID for CONF_MATL Field
62	CONF_MATL_VERSION	☐	MGV_CONF_MATL_VERSION	MATNR_VERS	CHAR	10	0	Version Number for Field CONF_MATL
63	MATERIAL_EXTERNAL	☐	MGV_MATERIAL_EXTERNAL	MATNR_EXT	CHAR	40	0	Long Material Number for MATERIAL Field
64	MATERIAL_GUID	☐	MGV_MATERIAL_GUID	MATNR_EGUID	CHAR	32	0	External GUID for MATERIAL Field
65	MATERIAL_VERSION	☐	MGV_MATERIAL_VERSION	MATNR_VERS	CHAR	10	0	Version Number for MATERIAL Field
66	PR_REF_MAT_EXTERNAL	☐	MGV_PR_REF_MAT_EXTERNAL	MATNR_EXT	CHAR	40	0	Long Material Number for PR_REF_MAT Field
67	PR_REF_MAT_GUID	☐	MGV_PR_REF_MAT_GUID	MATNR_EGUID	CHAR	32	0	External GUID for PR_REF_MAT Field
68	PR_REF_MAT_VERSION	☐	MGV_PR_REF_MAT_VERSION	MATNR_VERS	CHAR	10	0	Version Number for PR_REF_MAT Field
69	REB_VALUE	☐	REB_VALUE_BAPI	BAPICURR	DEC	23	4	Value of Absolute Discount
70	REB_PERC	☐	REB_PERC	REB_PERC	DEC	5	2	Percentage Discount
71	OFFER_TYPE	☐	RDM_OFFER_TYPE_PRICE	RDM_OFFER_TYPE_PRICE	CHAR	2	0	Offer Type Price
72	OFFER_TYPE_DESC	☐	RDM_OFFER_TYPE_TEXT	DDTEXT	CHAR	60	0	Offer Type Description
73	OFFER_TYPE_DISCOUNT	☐	RDM_OFFER_TYPE_DISCOUNT	RDM_OFFER_TYPE_DISCOUNT	CHAR	2	0	Offer Type Discount
74	OFFER_TYPE_DISCOUNT_DESC	☐	RDM_OFFER_TYPE_TEXT	DDTEXT	CHAR	60	0	Offer Type Description
75	OFFER_ID	☐	WPM_OFFERID_PRICE	WPM_OFFERID	CHAR	36	0	Offer ID for Price
76	OFFER_ID_DISCOUNT	☐	WPM_OFFERID_DISCOUNT	WPM_OFFERID	CHAR	36	0	Offer ID for Discount
77	OFFER_PRODUCT_GROUP	☐	WPM_OFFER_PRODUCT_GROUP_PRICE	WPM_OFFER_PRODUCT_GROUP	NUMC	3	0	Product Group in Offer (Price)
78	OFFER_PRODUCT_GROUP_DISCOUNT	☐	WPM_OFFER_PRODUCT_GROUP_DSCNT	WPM_OFFER_PRODUCT_GROUP	NUMC	3	0	Product Group in Offer (Discount)
79	ITEM_CREATE_INDICATOR	☐	WPM_PROMO_ITEM	XFELD	CHAR	1	0	Promotion Item Indicator for Transferred Materials
80	OFFER_PRICE_QTY	☐	W_PABBM_OFFER_PRC	MENGE	QUAN	13	3	Planned sales qty in sales units for material in price offer
81	OFFER_DISCOUNT_QTY	☐	W_PABBM_OFFER_DSC	MENGE	QUAN	13	3	Planned sales qty in sales units of material in discnt offer

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	BAPI1068T19	ALLOC_RULE	SVKO	SBELN
2	BAPI1068T19	ALLOC_STRATEGY	T627	ASTRA
3	BAPI1068T19	ALLOC_TBL	AUKO	ABELN
4	BAPI1068T19	ALLOC_TBL_ITEM	AUPO	ABELP
5	BAPI1068T19	ALLOC_UNIT	T006	MSEHI
6	BAPI1068T19	ALLOC_UNIT_ISO	T006I	ISOCODE
7	BAPI1068T19	CONF_MATL	MARA	MATNR
8	BAPI1068T19	ITEM_CATEGORY	T621	APSTP
9	BAPI1068T19	MATERIAL	MARA	MATNR
10	BAPI1068T19	MATL_GROUP	T023	MATKL
11	BAPI1068T19	ORDERPR_UN	T006	MSEHI
12	BAPI1068T19	ORDERPR_UN_ISO	T006I	ISOCODE
13	BAPI1068T19	PP_CURRENCY	TCURC	WAERS
14	BAPI1068T19	PRICE_POINT_GROUP	TWPK	EPRGR
15	BAPI1068T19	PR_REF_MAT	MARA	MATNR
16	BAPI1068T19	SALES_CURRENCY	TCURC	WAERS
17	BAPI1068T19	SALES_UNIT	T006	MSEHI
18	BAPI1068T19	SALES_UNIT_ISO	T006I	ISOCODE
19	BAPI1068T19	THEME	TWAT	AKTHE

History

Last changed by/on	SAP	20130529
SAP Release Created in	46C