SAP ABAP Table BAPI1068T23 (Table Parameters: Item Data (Changeable))

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	BAPI1068T23	Table Relationship Diagram
Short Description	Table Parameters: Item Data (Changeable)

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	*
2	SALES_UNIT	☐	W_MEBME	MEINS	UNIT	3	0	Sales unit	T006
3	SALES_UNIT_ISO	☐	W_MEBME_ISO	ISOCD_UNIT	CHAR	3	0	Sales unit in ISO code	T006I
4	THEME	☐	W_AKTHE	THEMA	CHAR	4	0	Promotion theme	TWAT
5	MIN_ORD_QTY	☐	W_MIAMG	MENGE	QUAN	13	3	Minimum order qty for promotional material
6	PLND_SALES_QTY	☐	W_PABBM	MENGE	QUAN	13	3	Planned Sales Qty. of Promotion Material in Sales Units
7	SALES_PRICE	☐	W_PLVKP_BAPI	BAPICURR	DEC	23	4	Sales price (gross)
8	SALES_CURRENCY	☐	W_WAELA	WAERS	CUKY	5	0	Currency current promotion - planning	TCURC
9	SALES_CRRNCY_ISO	☐	W_WAELA_ISO	ISOCD	CHAR	3	0	Planned sales currency in ISO code
10	SALES_PR_UNIT	☐	VPEIN	DEC5	DEC	5	0	Sales price unit
11	PP_GROSS	☐	W_PLEKP_BAPI	BAPICURR	DEC	23	4	Purchase Price
12	PP_CURRENCY	☐	W_WAEEK	WAERS	CUKY	5	0	Purchase price currency	TCURC
13	PP_CRRNCY_ISO	☐	W_WAEEK_ISO	ISOCD	CHAR	3	0	Purchasing currency in ISO code
14	PP_UNIT	☐	EPEIN	DEC5	DEC	5	0	Price unit
15	ORDERPR_UN	☐	BBPRM	MEINS	UNIT	3	0	Order Price Unit (purchasing)	T006
16	ORDERPR_UN_ISO	☐	BBPRM_ISO	ISOCD_UNIT	CHAR	3	0	ISO Code for Purchase Order Price Unit	T006I
17	ORDER_FROM	☐	W_FADAT	DATUM	DATS	8	0	Earliest Order Date
18	ORDER_TO	☐	W_SADAT	DATUM	DATS	8	0	Latest Order Date
19	DELIVERY_FROM	☐	W_FLDAT	DATUM	DATS	8	0	Earliest delivery date
20	DELIVERY_TO	☐	W_SLDAT	DATUM	DATS	8	0	Latest delivery date
21	PLND_ALLOC_QTY	☐	W_PMNGU	MENG13	QUAN	13	3	Planned allocation quantity for an allocation table item
22	ALLOC_UNIT	☐	AUFME	MEINS	UNIT	3	0	Allocation Unit	T006
23	ALLOC_UNIT_ISO	☐	AUFME_ISO	ISOCD_UNIT	CHAR	3	0	Allocation table unit of measure in ISO code	T006I
24	ALLOC_RULE	☐	VREGE	SBELN	CHAR	10	0	Retail Promotion: Allocation Rule Number	SVKO
25	BLOCK_REASON	☐	W_SPGRU	SPGRU	CHAR	1	0	Reason for promotion block
26	ALLOC_STRATEGY	☐	W_ASTRA	ASTRA	CHAR	4	0	Retail Promotion: Allocation Strategy	*
27	MATERIAL_EXTERNAL	☐	MGV_MATERIAL_EXTERNAL	MATNR_EXT	CHAR	40	0	Long Material Number for MATERIAL Field
28	MATERIAL_GUID	☐	MGV_MATERIAL_GUID	MATNR_EGUID	CHAR	32	0	External GUID for MATERIAL Field
29	MATERIAL_VERSION	☐	MGV_MATERIAL_VERSION	MATNR_VERS	CHAR	10	0	Version Number for MATERIAL Field
30	REB_VALUE	☐	REB_VALUE_BAPI	BAPICURR	DEC	23	4	Value of Absolute Discount
31	REB_PERC	☐	REB_PERC	REB_PERC	DEC	5	2	Percentage Discount
32	OFFER_TYPE	☐	RDM_OFFER_TYPE_PRICE	RDM_OFFER_TYPE_PRICE	CHAR	2	0	Offer Type Price
33	OFFER_TYPE_DISCOUNT	☐	RDM_OFFER_TYPE_DISCOUNT	RDM_OFFER_TYPE_DISCOUNT	CHAR	2	0	Offer Type Discount
34	OFFER_ID	☐	WPM_OFFERID_PRICE	WPM_OFFERID	CHAR	36	0	Offer ID for Price
35	OFFER_ID_DISCOUNT	☐	WPM_OFFERID_DISCOUNT	WPM_OFFERID	CHAR	36	0	Offer ID for Discount
36	OFFER_PRODUCT_GROUP	☐	WPM_OFFER_PRODUCT_GROUP_PRICE	WPM_OFFER_PRODUCT_GROUP	NUMC	3	0	Product Group in Offer (Price)
37	OFFER_PRODUCT_GROUP_DISCOUNT	☐	WPM_OFFER_PRODUCT_GROUP_DSCNT	WPM_OFFER_PRODUCT_GROUP	NUMC	3	0	Product Group in Offer (Discount)
38	ITEM_CREATE_INDICATOR	☐	WPM_PROMO_ITEM	XFELD	CHAR	1	0	Promotion Item Indicator for Transferred Materials
39	OFFER_PRICE_QTY	☐	W_PABBM_OFFER_PRC	MENGE	QUAN	13	3	Planned sales qty in sales units for material in price offer
40	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	BAPI1068T23	ALLOC_RULE	SVKO	SBELN
2	BAPI1068T23	ALLOC_UNIT	T006	MSEHI
3	BAPI1068T23	ALLOC_UNIT_ISO	T006I	ISOCODE
4	BAPI1068T23	ORDERPR_UN	T006	MSEHI
5	BAPI1068T23	ORDERPR_UN_ISO	T006I	ISOCODE
6	BAPI1068T23	PP_CURRENCY	TCURC	WAERS
7	BAPI1068T23	SALES_CURRENCY	TCURC	WAERS
8	BAPI1068T23	SALES_UNIT	T006	MSEHI
9	BAPI1068T23	SALES_UNIT_ISO	T006I	ISOCODE
10	BAPI1068T23	THEME	TWAT	AKTHE

History

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