SAP ABAP Table BAPISDITEM (Communication Fields: Sales and Distribution Document Item)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-BF (Application Component) Basic Functions
     ⤷ VACR (Package) B2R: Development Class for BAPI structures

Basic Data

Table Category	INTTAB	Structure
Structure	BAPISDITEM	Table Relationship Diagram
Short Description	Communication Fields: Sales and Distribution Document Item

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	ITM_NUMBER	☐	POSNR_VA	POSNR	NUMC	6	0	Sales Document Item	VBUP
2	HG_LV_ITEM	☐	UEPOS	POSNR	NUMC	6	0	Higher-level item in bill of material structures	VBUP
3	PO_ITM_NO	☐	POSEX	POSEX	CHAR	6	0	Item Number of the Underlying Purchase Order
4	MATERIAL	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
5	ALTERN_TO_ITM	☐	GRPOS	GRPOS	NUMC	6	0	Item for which this item is an alternative
6	CUST_MAT35	☐	KDMAT	IDNEX	CHAR	35	0	Material belonging to the customer
7	BATCH	☐	CHARG_D	CHARG	CHAR	10	0	Batch Number	MCH1
8	DLV_GROUP	☐	GRKOR	GRKOR	NUMC	3	0	Delivery group (items are delivered together)
9	PART_DLV	☐	KZTLF	KZTLF	CHAR	1	0	Partial delivery at item level
10	REASON_REJ	☐	ABGRU	ABGRU	CHAR	2	0	Reason for rejection of quotations and sales orders
11	BILL_BLOCK	☐	FAKSP	FAKSP	CHAR	2	0	Lock	TVFS
12	BILL_DATE	☐	FKDAT	DATUM	DATS	8	0	Billing date for billing index and printout
13	PLANT	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
14	STORE_LOC	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	T001L
15	TARGET_QTY	☐	DZMENG	MENG13	QUAN	13	3	Target quantity in sales units
16	TARGET_QU	☐	DZIEME	MEINS	UNIT	3	0	Target quantity UoM	T006
17	T_UNIT_ISO	☐	ISO_ZIEME	ISOCD_UNIT	CHAR	3	0	Target quantity unit of measure in ISO code	T006I
18	ITEM_CATEG	☐	PSTYV	PSTYV	CHAR	4	0	Sales document item category	TVPT
19	SHORT_TEXT	☐	ARKTX	TEXT40	CHAR	40	0	Short text for sales order item
20	PRC_GROUP1	☐	MVGR1	MVGR1	CHAR	3	0	Material group 1	TVM1
21	PRC_GROUP2	☐	MVGR2	MVGR2	CHAR	3	0	Material group 2	TVM2
22	PRC_GROUP3	☐	MVGR3	MVGR3	CHAR	3	0	Material group 3	TVM3
23	PRC_GROUP4	☐	MVGR4	MVGR4	CHAR	3	0	Material group 4	TVM4
24	PRC_GROUP5	☐	MVGR5	MVGR5	CHAR	3	0	Material group 5	TVM5
25	PROD_HIERA	☐	PRODH_D	PRODH	CHAR	18	0	Product Hierarchy	T179
26	MATL_GROUP	☐	MATKL	MATKL	CHAR	9	0	Material Group	T023
27	PURCH_NO_C	☐	BSTKD	BSTKD	CHAR	35	0	Customer purchase order number
28	PURCH_DATE	☐	BSTDK	DATUM	DATS	8	0	Customer purchase order date
29	PO_METHOD	☐	BSARK	BSARK	CHAR	4	0	Customer Order Type	T176
30	REF_1	☐	IHREZ	TEXT12	CHAR	12	0	Your Reference
31	PURCH_NO_S	☐	BSTKD_E	BSTKD	CHAR	35	0	Ship-to Party's Purchase Order Number
32	PO_DAT_S	☐	BSTDK_E	DATUM	DATS	8	0	Ship-to party's PO date
33	PO_METH_S	☐	BSARK_E	BSARK	CHAR	4	0	Ship-to party purchase order type	T176
34	REF_1_S	☐	IHREZ_E	TEXT12	CHAR	12	0	Ship-to party character
35	PO_ITM_NO_S	☐	POSEX_E	POSEX	CHAR	6	0	Item Number of the Underlying Purchase Order
36	PRICE_GRP	☐	KONDA	KONDA	CHAR	2	0	Price Group (Customer)	T188
37	CUST_GROUP	☐	KDGRP	KDGRP	CHAR	2	0	Customer group	T151
38	SALES_DIST	☐	BZIRK	BZIRK	CHAR	6	0	Sales district	T171
39	PRICE_LIST	☐	PLTYP	PLTYP	CHAR	2	0	Price list type	T189
40	INCOTERMS1	☐	INCO1	INCO1	CHAR	3	0	Incoterms (part 1)	TINC
41	INCOTERMS2	☐	INCO2	INCO2	CHAR	28	0	Incoterms (part 2)
42	ORD_COMP_IN	☐	KZAZU_D	XFELD	CHAR	1	0	Order combination indicator
43	BILL_SCHED	☐	PERFK	WFCID	CHAR	2	0	Invoice dates (calendar identification)	TFACD
44	INVO_SCHED	☐	PERRL	WFCID	CHAR	2	0	Invoice list schedule (calendar identification)	TFACD
45	MN_INVOICE	☐	MRNKZ	XFELD	CHAR	1	0	Manual invoice maintenance
46	EXCH_RATE_FI	☐	KURRF	KURRF	DEC	9	5	Exchange rate for FI postings
47	ADD_VAL_DY	☐	VALTG	TAGE2	NUMC	2	0	Additional value days
48	FIX_VAL_DY	☐	VALDT	DATUM	DATS	8	0	Fixed value date
49	PMNTTRMS	☐	DZTERM	ZTERM	CHAR	4	0	Terms of payment key
50	PYMT_METH	☐	DZLSCH	ZLSCH	CHAR	1	0	Payment method	T042Z
51	ACCNT_ASGN	☐	KTGRD	KTGRD	CHAR	2	0	Account assignment group for this customer	TVKT
52	EXCHG_RATE	☐	KURSK	KURRF	DEC	9	5	Exchange Rate for Pricing and Statistics
53	PRICE_DATE	☐	PRSDT	DATUM	DATS	8	0	Date for pricing and exchange rate
54	SERV_DATE	☐	FBUDA	DATUM	DATS	8	0	Date When Services Rendered
55	DUNN_KEY	☐	MSCHL	MSCHL	CHAR	1	0	Dunning key	T040
56	DUNN_BLOCK	☐	MANSP	MANSP	CHAR	1	0	Dunning block	T040S
57	PROMOTION	☐	WAKTION	WAKTION	CHAR	10	0	Promotion	WAKH
58	PYMT_GAR_PROC	☐	ABSSCHE_CM	ABSSCHE_CM	CHAR	6	0	Payment Guarantee Procedure
59	DOC_NUM_FI	☐	LCNUM	LCNUM	CHAR	10	0	Financial doc. processing: Internal financial doc. number	*
60	DEPARTMENT_NO	☐	ABTNR	ABTNR	CHAR	4	0	Department number	TSAB
61	REC_POINT	☐	EMPST	TEXT25	CHAR	25	0	Receiving point
62	CUST_COND_GRP1	☐	KDKG1	KDKGR	CHAR	2	0	Customer condition group 1	TVKGG
63	CUST_COND_GRP2	☐	KDKG2	KDKGR	CHAR	2	0	Customer condition group 2	TVKGG
64	CUST_COND_GRP3	☐	KDKG3	KDKGR	CHAR	2	0	Customer condition group 3	TVKGG
65	CUST_COND_GRP4	☐	KDKG4	KDKGR	CHAR	2	0	Customer condition group 4	TVKGG
66	CUST_COND_GRP5	☐	KDKG5	KDKGR	CHAR	2	0	Customer condition group 5	TVKGG
67	DLV_TIME	☐	DELCO	DELCO	CHAR	3	0	Agreed delivery time
68	SALES_UNIT	☐	VRKME	MEINS	UNIT	3	0	Sales unit	T006
69	SALES_UNIT_ISO	☐	ISOCD_UNIT	ISOCD_UNIT	CHAR	3	0	ISO code for unit of measurement	T006I
70	TARG_QTY_NUM	☐	UMZIZ	UMBSZ	DEC	5	0	Factor for converting sales units to base units (target qty)
71	TARG_QTY_DENOM	☐	UMZIN	UMBSN	DEC	5	0	Factor for converting sales units to base units (target qty)
72	ROUND_DLV_QTY	☐	ABLFZ	ABLFZ	QUAN	13	3	Rounding quantity for delivery
73	MAX_DEVIAT_AMNT	☐	ABSFZ	MENG13	QUAN	13	3	Allowed deviation in quantity (absolute)
74	MAX_DEV_PERC	☐	KBVER	PACK2	DEC	3	0	Allowed deviation in quantity (in percent)
75	MAX_DEV_DAYS	☐	KEVER	PACK2	DEC	3	0	Days by which the quantity can be shifted
76	USAGE_IND	☐	VKAUS	VKAUS	CHAR	3	0	Unused - Reserve Length 3
77	FIXED_QUAN	☐	FMENG	XFELD	CHAR	1	0	Quantity is fixed
78	UNLIMITED_DLV	☐	UEBTK	XFELD	CHAR	1	0	Indicator: Unlimited Overdelivery Allowed
79	OVER_DLV_TOL	☐	UEBTO	PRZ21	DEC	3	1	Overdelivery Tolerance Limit
80	UNDER_DLV_TOL	☐	UNTTO	PRZ21	DEC	3	1	Underdelivery Tolerance Limit
81	DIVISION	☐	SPART	SPART	CHAR	2	0	Division	TSPA
82	SALES_QTY_NUM	☐	UMVKZ	UMBSZ	DEC	5	0	Numerator (factor) for conversion of sales quantity into SKU
83	SALES_QTY_DENOM	☐	UMVKN	UMBSN	DEC	5	0	Denominator (divisor) for conversion of sales qty. into SKU
84	GROSS_WEIGHT	☐	BRGEW_AP	MENG15	QUAN	15	3	Gross weight of item
85	NET_WEIGHT	☐	NTGEW_AP	MENG15	QUAN	15	3	Net weight of item
86	UNIT_OF_WEIGHT	☐	GEWEI	MEINS	UNIT	3	0	Weight Unit	T006
87	UNIT_OF_WT_ISO	☐	GEWEI_ISO	ISOCD_UNIT	CHAR	3	0	Unit of weight in ISO code	T006I
88	VOLUME	☐	VOLUM_AP	MENG15	QUAN	15	3	Volume of the item
89	VOLUMEUNIT	☐	VOLEH	MEINS	UNIT	3	0	Volume unit	T006
90	VOLUMEUNIT_ISO	☐	VOLEH_ISO	ISOCD_UNIT	CHAR	3	0	Volume unit in ISO code	T006I
91	DLV_PRIO	☐	LPRIO	LPRIO	NUMC	2	0	Delivery priority	TPRIO
92	SHIP_POINT	☐	VSTEL	VSTEL	CHAR	4	0	Shipping Point/Receiving Point	TVST
93	ROUTE	☐	ROUTE	ROUTE	CHAR	6	0	Route	TVRO
94	CREATED_BY	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
95	TAX_CLASS1	☐	TAXMT	TAXKD	CHAR	1	0	Tax classification material	TSKD
96	TAX_CLASS2	☐	TAXMT	TAXKD	CHAR	1	0	Tax classification material	TSKD
97	TAX_CLASS3	☐	TAXMT	TAXKD	CHAR	1	0	Tax classification material	TSKD
98	TAX_CLASS4	☐	TAXMT	TAXKD	CHAR	1	0	Tax classification material	TSKD
99	TAX_CLASS5	☐	TAXMT	TAXKD	CHAR	1	0	Tax classification material	TSKD
100	TAX_CLASS6	☐	TAXMT	TAXKD	CHAR	1	0	Tax classification material	TSKD
101	TAX_CLASS7	☐	TAXMT	TAXKD	CHAR	1	0	Tax classification material	TSKD
102	TAX_CLASS8	☐	TAXMT	TAXKD	CHAR	1	0	Tax classification material	TSKD
103	TAX_CLASS9	☐	TAXMT	TAXKD	CHAR	1	0	Tax classification material	TSKD
104	MAT_PR_GRP	☐	KONDM	KONDM	CHAR	2	0	Material Pricing Group	T178
105	VAL_TYPE	☐	BWTAR_D	BWTAR	CHAR	10	0	Valuation type	T149D
106	FIX_DATE_QTY	☐	FIXMG	XFELD	CHAR	1	0	Delivery date and quantity fixed
107	BOMEXPL_NO	☐	SERNR	SERNR	CHAR	8	0	BOM explosion number	SNUM
108	RES_ANAL_KEY	☐	ABGR_SCHL	ABGR_SCHL	CHAR	6	0	Results Analysis Key	TKKAA
109	REQMTS_TYPE	☐	BEDAE	BEDAE	CHAR	4	0	Requirements type	T459A
110	NO_GR_POSTED	☐	NACHL	XFELD	CHAR	1	0	Customer has not posted goods receipt
111	BUS_TRANST	☐	EXART	EXART	CHAR	2	0	Business Transaction Type for Foreign Trade	T605
112	OVERHEAD_KEY	☐	AUFZSCHL	CHAR6	CHAR	6	0	Overhead key
113	CSTG_SHEET	☐	AUFKALSM	KALSM	CHAR	6	0	Costing Sheet	T683
114	MATFRGTGRP	☐	MFRGR	MFRGR	CHAR	8	0	Material freight group	TMFG
115	PLANDLVSCHEDINS	☐	PLAVO	PLAVO	CHAR	4	0	Planning Release Regulation	TVZP
116	SEQUENCE_NO	☐	KANNR	CHAR35	CHAR	35	0	KANBAN/sequence number
117	BILLING_FORM	☐	FAKTF	FAKTF	CHAR	2	0	Billing Form
118	DLI_PROFILE	☐	AD01PROFNR	AD01PROFNR	CHAR	8	0	Dynamic Item Processor Profile	AD01C_PROF
119	REVENUE_TYPE	☐	RR_RELTYP	RR_RELTYP	CHAR	1	0	Revenue recognition category
120	BEGIN_DEMARC_PERIOD	☐	RR_ACDATV	RR_ACDATV	CHAR	1	0	Proposed start date for accrual period
121	PR_REF_MAT	☐	PMATN	MATNR	CHAR	18	0	Pricing Reference Material	MARA
122	REFOBJTYPE	☐	SWO_OBJTYP	OJ_NAME	CHAR	10	0	Object Type	*
123	REFOBJKEY	☐	SWO_TYPEID	SWO_TYPEID	CHAR	70	0	Object key
124	REFLOGSYS	☐	LOGSYS	LOGSYS	CHAR	10	0	Logical system	*
125	ORDER_PROB	☐	AWAHR	AWAHR	NUMC	3	0	Order probability of the item
126	MAX_PL_DLV	☐	ANTLF	ANTLF	DEC	1	0	Maximum number of partial deliveries allowed per item
127	CFOP_CODE	☐	J_1BCFOP_OLD	J_1BCFOP_OLD	CHAR	5	0	CFOP code and extension (old 5 char version)	*
128	TAXLAWICMS	☐	J_1BTAXLW1	J_1BTAXLW1	CHAR	3	0	Tax law: ICMS	*
129	TAXLAWIPI	☐	J_1BTAXLW2	J_1BTAXLW2	CHAR	3	0	Tax law: IPI	*
130	SD_TAXCODE	☐	J_1BTXSDC_	J_1BTXSDC	CHAR	2	0	SD tax code	*
131	ASSORT_MOD	☐	W_SORTK	WSORTK	CHAR	18	0	Assortment Module	*
132	COMP_QUANT	☐	KMPMG	MENGV13	QUAN	13	3	Component Quantity
133	TARGET_VAL	☐	BAPICURR_D	BAPICURR	DEC	23	4	Currency amount in BAPI interfaces
134	PROFIT_CTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center	*
135	ORDERID	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	*
136	WBS_ELEM	☐	PS_POSID	PS_POSID	CHAR	24	0	Work Breakdown Structure Element (WBS Element)
137	DEPREC_PER	☐	AKPRZ	PRZ32	DEC	5	2	Depreciation percentage for financial document processing
138	REF_DOC	☐	VGBEL	VBELN	CHAR	10	0	Document number of the reference document	*
139	REF_DOC_IT	☐	VGPOS	POSNR	NUMC	6	0	Item number of the reference item	*
140	REF_DOC_CA	☐	VBTYP_V	VBTYP	CHAR	1	0	Document category of preceding SD document
141	MATERIAL_EXTERNAL	☐	MGV_MATERIAL_EXTERNAL	MATNR_EXT	CHAR	40	0	Long Material Number for MATERIAL Field
142	MATERIAL_GUID	☐	MGV_MATERIAL_GUID	MATNR_EGUID	CHAR	32	0	External GUID for MATERIAL Field
143	MATERIAL_VERSION	☐	MGV_MATERIAL_VERSION	MATNR_VERS	CHAR	10	0	Version Number for MATERIAL Field
144	PR_REF_MAT_EXTERNAL	☐	MGV_PR_REF_MAT_EXTERNAL	MATNR_EXT	CHAR	40	0	Long Material Number for PR_REF_MAT Field
145	PR_REF_MAT_GUID	☐	MGV_PR_REF_MAT_GUID	MATNR_EGUID	CHAR	32	0	External GUID for PR_REF_MAT Field
146	PR_REF_MAT_VERSION	☐	MGV_PR_REF_MAT_VERSION	MATNR_VERS	CHAR	10	0	Version Number for PR_REF_MAT Field
147	CFOP_LONG	☐	J_1BCFOP_LONG	J_1BCFOP_LONG	CHAR	10	0	CFOP code and extension	*
148	FKK_CONACCT	☐	CORR_VKONT_KK	CORR_VKONT_KK	CHAR	12	0	Contract Account Number
149	SEPA_MANDATE_ID	☐	SEPA_MNDID	ID035	CHAR	35	0	Unique Referene to Mandate per Payment Recipient

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	BAPISDITEM	ACCNT_ASGN	TVKT	KTGRD
2	BAPISDITEM	BATCH	MCH1	CHARG
3	BAPISDITEM	BILL_BLOCK	TVFS	FAKSP
4	BAPISDITEM	BILL_SCHED	TFACD	IDENT
5	BAPISDITEM	BOMEXPL_NO	SNUM	SERNR
6	BAPISDITEM	BUS_TRANST	T605	EXART
7	BAPISDITEM	CSTG_SHEET	T683	KALSM
8	BAPISDITEM	CUST_COND_GRP1	TVKGG	KDKGR
9	BAPISDITEM	CUST_COND_GRP2	TVKGG	KDKGR
10	BAPISDITEM	CUST_COND_GRP3	TVKGG	KDKGR
11	BAPISDITEM	CUST_COND_GRP4	TVKGG	KDKGR
12	BAPISDITEM	CUST_COND_GRP5	TVKGG	KDKGR
13	BAPISDITEM	CUST_GROUP	T151	KDGRP
14	BAPISDITEM	DEPARTMENT_NO	TSAB	ABTNR
15	BAPISDITEM	DIVISION	TSPA	SPART
16	BAPISDITEM	DLI_PROFILE	AD01C_PROF	PROFNR
17	BAPISDITEM	DLV_PRIO	TPRIO	LPRIO
18	BAPISDITEM	DUNN_BLOCK	T040S	MANSP
19	BAPISDITEM	DUNN_KEY	T040	MSCHL
20	BAPISDITEM	HG_LV_ITEM	VBUP	POSNR
21	BAPISDITEM	INCOTERMS1	TINC	INCO1
22	BAPISDITEM	INVO_SCHED	TFACD	IDENT
23	BAPISDITEM	ITEM_CATEG	TVPT	PSTYV
24	BAPISDITEM	ITM_NUMBER	VBUP	POSNR
25	BAPISDITEM	MATERIAL	MARA	MATNR
26	BAPISDITEM	MATFRGTGRP	TMFG	MFRGR
27	BAPISDITEM	MATL_GROUP	T023	MATKL
28	BAPISDITEM	MAT_PR_GRP	T178	KONDM
29	BAPISDITEM	PLANDLVSCHEDINS	TVZP	PLAVO
30	BAPISDITEM	PLANT	T001W	WERKS
31	BAPISDITEM	PO_METHOD	T176	BSARK
32	BAPISDITEM	PO_METH_S	T176	BSARK
33	BAPISDITEM	PRC_GROUP1	TVM1	MVGR1
34	BAPISDITEM	PRC_GROUP2	TVM2	MVGR2
35	BAPISDITEM	PRC_GROUP3	TVM3	MVGR3
36	BAPISDITEM	PRC_GROUP4	TVM4	MVGR4
37	BAPISDITEM	PRC_GROUP5	TVM5	MVGR5
38	BAPISDITEM	PRICE_GRP	T188	KONDA
39	BAPISDITEM	PRICE_LIST	T189	PLTYP
40	BAPISDITEM	PROD_HIERA	T179	PRODH
41	BAPISDITEM	PROMOTION	WAKH	AKTNR
42	BAPISDITEM	PR_REF_MAT	MARA	MATNR
43	BAPISDITEM	PYMT_METH	T042Z	ZLSCH
44	BAPISDITEM	REQMTS_TYPE	T459A	BEDAE
45	BAPISDITEM	RES_ANAL_KEY	TKKAA	ABGSL
46	BAPISDITEM	ROUTE	TVRO	ROUTE
47	BAPISDITEM	SALES_DIST	T171	BZIRK
48	BAPISDITEM	SALES_UNIT	T006	MSEHI
49	BAPISDITEM	SALES_UNIT_ISO	T006I	ISOCODE
50	BAPISDITEM	SHIP_POINT	TVST	VSTEL
51	BAPISDITEM	STORE_LOC	T001L	LGORT
52	BAPISDITEM	TARGET_QU	T006	MSEHI
53	BAPISDITEM	TAX_CLASS1	TSKD	TAXKD
54	BAPISDITEM	TAX_CLASS2	TSKD	TAXKD
55	BAPISDITEM	TAX_CLASS3	TSKD	TAXKD
56	BAPISDITEM	TAX_CLASS4	TSKD	TAXKD
57	BAPISDITEM	TAX_CLASS5	TSKD	TAXKD
58	BAPISDITEM	TAX_CLASS6	TSKD	TAXKD
59	BAPISDITEM	TAX_CLASS7	TSKD	TAXKD
60	BAPISDITEM	TAX_CLASS8	TSKD	TAXKD
61	BAPISDITEM	TAX_CLASS9	TSKD	TAXKD
62	BAPISDITEM	T_UNIT_ISO	T006I	ISOCODE
63	BAPISDITEM	UNIT_OF_WEIGHT	T006	MSEHI
64	BAPISDITEM	UNIT_OF_WT_ISO	T006I	ISOCODE
65	BAPISDITEM	VAL_TYPE	T149D	BWTAR
66	BAPISDITEM	VOLUMEUNIT	T006	MSEHI
67	BAPISDITEM	VOLUMEUNIT_ISO	T006I	ISOCODE

History

Last changed by/on	SAP	20130529
SAP Release Created in