SAP ABAP Table BAPI1068T2 (Table parameters: Item data)

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	BAPI1068T2	Table Relationship Diagram
Short Description	Table parameters: Item data

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	PLANT_CUSTOMER	☐	FILNR	KUNNR	CHAR	10	0	Customer no. of plant	KNA1
2	NAME	☐	AD_NAME1	TEXT40	CHAR	40	0	Name 1
3	MATERIAL	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
4	MATL_DESC	☐	MAKTX	TEXT40	CHAR	40	0	Material description
5	CONF_MATL	☐	SATNR	MATNR	CHAR	18	0	Cross-Plant Configurable Material	MARA
6	MATL_GROUP	☐	MATKL	MATKL	CHAR	9	0	Material Group	T023
7	ITEM_NO	☐	W_AKPOS	NUMC6	NUMC	6	0	Promotion Item Number
8	THEME	☐	W_AKTHE	THEMA	CHAR	4	0	Promotion theme	TWAT
9	THEME_DESC	☐	W_AKTHETX	TEXT20	CHAR	20	0	Promotion theme description
10	MIN_ORD_QTY	☐	W_MIAMG	MENGE	QUAN	13	3	Minimum order qty for promotional material
11	PLND_SALES_QTY	☐	W_PABBM	MENGE	QUAN	13	3	Planned Sales Qty. of Promotion Material in Sales Units
12	PLND_ALLOC_QTY	☐	W_PMNGU	MENG13	QUAN	13	3	Planned allocation quantity for an allocation table item
13	REQUESTED_QTY	☐	WMNGE	MENG13	QUAN	13	3	Quantity requested by store
14	CONFIRMED_QTY	☐	IMNGU	MENG13	QUAN	13	3	Confirmed qty of plant
15	ALLOC_UNIT_ISO	☐	AUFME_ISO	ISOCD_UNIT	CHAR	3	0	Allocation table unit of measure in ISO code	T006I
16	ALLOC_UNIT	☐	AUFME	MEINS	UNIT	3	0	Allocation Unit	T006
17	SALES_UNIT	☐	W_MEBME	MEINS	UNIT	3	0	Sales unit	T006
18	SALES_UNIT_ISO	☐	W_MEBME_ISO	ISOCD_UNIT	CHAR	3	0	Sales unit in ISO code	T006I
19	SALES_PRICE	☐	W_PLVKP_BAPI	BAPICURR	DEC	23	4	Sales price (gross)
20	SALES_PRICE_NET	☐	W_VKPNN_BAPI	BAPICURR	DEC	23	4	Sales Price (Net)
21	SALES_CURRENCY	☐	W_WAELA	WAERS	CUKY	5	0	Currency current promotion - planning	TCURC
22	SALES_CRRNCY_ISO	☐	W_WAELA_ISO	ISOCD	CHAR	3	0	Planned sales currency in ISO code
23	SALES_PR_UNIT	☐	VPEIN	DEC5	DEC	5	0	Sales price unit
24	STANDARD_SP	☐	W_NVKP_BAPI	BAPICURR	DEC	23	4	Standard Sales Price
25	PP_GROSS	☐	W_PLEKP_BAPI	BAPICURR	DEC	23	4	Purchase Price
26	PP_NET	☐	W_PLEKN_BAPI	BAPICURR	DEC	23	4	Purchase price (net/net)
27	PP_CURRENCY	☐	W_WAEEK	WAERS	CUKY	5	0	Purchase price currency	TCURC
28	PP_CRRNCY_ISO	☐	W_WAEEK_ISO	ISOCD	CHAR	3	0	Purchasing currency in ISO code
29	PP_UNIT	☐	EPEIN	DEC5	DEC	5	0	Price unit
30	ORDERPR_UN	☐	BBPRM	MEINS	UNIT	3	0	Order Price Unit (purchasing)	T006
31	ORDERPR_UN_ISO	☐	BBPRM_ISO	ISOCD_UNIT	CHAR	3	0	ISO Code for Purchase Order Price Unit	T006I
32	RETURN_TYPE	☐	W_RGART	RGART	CHAR	1	0	Return type for promotional material
33	RET_TYPE_DESC	☐	W_RUEAR	DDTEXT	CHAR	60	0	Return type description (from domain)
34	ORDER_FROM	☐	W_FADAT	DATUM	DATS	8	0	Earliest Order Date
35	ORDER_TO	☐	W_SADAT	DATUM	DATS	8	0	Latest Order Date
36	DELIVERY_FROM	☐	W_FLDAT	DATUM	DATS	8	0	Earliest delivery date
37	DELIVERY_TO	☐	W_SLDAT	DATUM	DATS	8	0	Latest delivery date
38	ORD_DATE_VENDOR	☐	W_BEDAT	DATUM	DATS	8	0	Order date with vendor
39	ALLOC_TBL	☐	ABELN	ABELN	CHAR	10	0	Allocation Table Number	AUKO
40	ALLOC_TBL_ITEM	☐	ABELP	ABELP	NUMC	5	0	Item number of allocation table	AUPO
41	BLOCK_REASON	☐	W_SPGRU	SPGRU	CHAR	1	0	Reason for promotion block
42	BLOCK_REASN_DESC	☐	W_SPGRT	DDTEXT	CHAR	60	0	Item blocking reason text
43	BLOCK_DATE	☐	W_SPDAT	DATUM	DATS	8	0	Date on which promotion material is blocked for promotion
44	PRICE_POINT	☐	F_VKPKZ	FLAG	CHAR	1	0	Indicates whether price point tables should override price
45	LANGU	☐	SPRAS	SPRAS	LANG	1	0	Language Key	T002
46	LANGUP_ISO	☐	LAISO	LAISO	CHAR	2	0	2-Character SAP Language Code
47	REPLY_ALLOWED	☐	WAKTION_RMKZ	WAKTION_RMKZ	CHAR	1	0	Retail promotion: Indicates that reply is necessary
48	CONF_MATL_EXTERNAL	☐	MGV_CONF_MATL_EXTERNAL	MATNR_EXT	CHAR	40	0	Long Material Number for CONF_MATL field
49	CONF_MATL_GUID	☐	MGV_CONF_MATL_GUID	MATNR_EGUID	CHAR	32	0	External GUID for CONF_MATL Field
50	CONF_MATL_VERSION	☐	MGV_CONF_MATL_VERSION	MATNR_VERS	CHAR	10	0	Version Number for Field CONF_MATL
51	MATERIAL_EXTERNAL	☐	MGV_MATERIAL_EXTERNAL	MATNR_EXT	CHAR	40	0	Long Material Number for MATERIAL Field
52	MATERIAL_GUID	☐	MGV_MATERIAL_GUID	MATNR_EGUID	CHAR	32	0	External GUID for MATERIAL Field
53	MATERIAL_VERSION	☐	MGV_MATERIAL_VERSION	MATNR_VERS	CHAR	10	0	Version Number for MATERIAL Field
54	ANNOUNC_CAT	☐	W_BEKTY	AAVIT	CHAR	4	0	Promotion announcement category	T626
55	ANNOUNC_CAT_DESC	☐	W_BETYT	CHAR60	CHAR	60	0	Description of Promotion Announcement Category
56	REPLY_STAT_PLANT	☐	W_RUSTB	XFELD	CHAR	1	0	Status of reply to announcement - plant

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	BAPI1068T2	ALLOC_TBL	AUKO	ABELN
2	BAPI1068T2	ALLOC_TBL_ITEM	AUPO	ABELP
3	BAPI1068T2	ALLOC_UNIT	T006	MSEHI
4	BAPI1068T2	ALLOC_UNIT_ISO	T006I	ISOCODE
5	BAPI1068T2	ANNOUNC_CAT	T626	AAVIT
6	BAPI1068T2	CONF_MATL	MARA	MATNR
7	BAPI1068T2	LANGU	T002	SPRAS
8	BAPI1068T2	MATERIAL	MARA	MATNR
9	BAPI1068T2	MATL_GROUP	T023	MATKL
10	BAPI1068T2	ORDERPR_UN	T006	MSEHI
11	BAPI1068T2	ORDERPR_UN_ISO	T006I	ISOCODE
12	BAPI1068T2	PLANT_CUSTOMER	KNA1	KUNNR
13	BAPI1068T2	PP_CURRENCY	TCURC	WAERS
14	BAPI1068T2	SALES_CURRENCY	TCURC	WAERS
15	BAPI1068T2	SALES_UNIT	T006	MSEHI
16	BAPI1068T2	SALES_UNIT_ISO	T006I	ISOCODE
17	BAPI1068T2	THEME	TWAT	AKTHE

History

Last changed by/on	SAP	20140121
SAP Release Created in