SAP ABAP Table BAPILFITEMO (Communication Structure: Vend. Billing Doc. Item Data)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ LO-AB (Application Component) Agency Business (Global Trade)
     ⤷ WZRE (Package) Agency Business

Basic Data

Table Category	INTTAB	Structure
Structure	BAPILFITEMO	Table Relationship Diagram
Short Description	Communication Structure: Vend. Billing Doc. 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	DOCUMENT_NUMBER	☑	WBELN_LF	WBELN	CHAR	10	0	Agency Business: Document Number	*
2	ITEM	☑	WPOSNR_LF	WPOSNR	NUMC	6	0	Agency business: Document item	WBRP
3	MATERIAL	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
4	MATL_GROUP	☐	MATKL	MATKL	CHAR	9	0	Material Group	T023
5	VEND_PART	☐	LTSNR	LTSNR	CHAR	6	0	Vendor Subrange	WYT1
6	TAX_CODE	☐	MWSKZ_LF	MWSKZ	CHAR	2	0	Agency business: Tax code (input tax)	T007A
7	NET_AMOUNT	☐	WNETWB	BAPICURR	DEC	23	4	Agency business: Net amount of item
8	GROSS	☐	WBRTWI	BAPICURR	DEC	23	4	Agency business: Gross amount of an item in settlement doc.
9	TAX	☐	MWSBPB	BAPICURR	DEC	23	4	Agency business: Tax amount
10	CASH_DISC	☐	SKTOF	XFELD	CHAR	1	0	Cash discount indicator
11	REF_DOC_HEAD	☐	WBELNV	CHAR10	CHAR	10	0	Agency business: Document number of the reference document
12	REF_DOC_ITEM	☐	WPOSNRV	NUMC6	NUMC	6	0	Item number of the reference document item
13	PDOC_CAT	☐	WFTYPV	WFTYPV	CHAR	2	0	Agency Business: Document Category of Preceding Document
14	SHORT_TEXT	☐	TXZ01	TEXT40	CHAR	40	0	Short Text
15	TAXJURCODE	☐	TXJCD	TXJCD	CHAR	15	0	Tax Jurisdiction	TTXJ
16	PLANT	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
17	BUS_AREA	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
18	COSTCENTER	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	CSKS
19	PROFIT_CTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center	CEPC
20	NET_PRICE	☐	WNETPI	BAPICURR	DEC	23	4	Agency business: Net price of an item in the payment documnt
21	QUANTITY	☐	WFIMG	MENGE13	QUAN	13	3	Vendor billing document: actual quantity billed
22	PRICE_UNIT	☐	WEINH	DEC5	DEC	5	0	Price Unit of Vendor Billing Document Item
23	BILL_UNIT	☐	WFKME	MEINS	UNIT	3	0	Vendor billing document: unit of measure	*
24	ISOCODE_UNIT	☐	ISOCD_UNIT	ISOCD_UNIT	CHAR	3	0	ISO code for unit of measurement	*
25	MATERIAL_EXTERNAL	☐	MGV_MATERIAL_EXTERNAL	MATNR_EXT	CHAR	40	0	Long Material Number for MATERIAL Field
26	MATERIAL_GUID	☐	MGV_MATERIAL_GUID	MATNR_EGUID	CHAR	32	0	External GUID for MATERIAL Field
27	MATERIAL_VERSION	☐	MGV_MATERIAL_VERSION	MATNR_VERS	CHAR	10	0	Version Number for MATERIAL Field
28	ITEMCAT	☐	WSHKZG	WSHKZG	CHAR	1	0	Agency Business: Item Category
29	QTY_NUM	☐	UMWFZ	UMBSZ	DEC	5	0	Numerator converting qty in vendor bill.doc. to base unit
30	QTY_DENOM	☐	UMWFN	UMBSN	DEC	5	0	Factor for converting qty in vendor bill. doc. to base unit
31	PROMOTION	☐	WAKTION	WAKTION	CHAR	10	0	Promotion	*
32	PRE_VENDOR	☐	KOLIF	LIFNR	CHAR	10	0	Prior Vendor	*
33	BILL_REASON	☐	WFGRU	WFGRU	CHAR	3	0	Agency business: Reason for activity	*
34	SETT_ITEM	☐	EBONY	XFELD	CHAR	1	0	Item Relevant to Subsequent (Period-End Rebate) Settlement
35	PRICE_DATE	☐	PRSDT	DATUM	DATS	8	0	Date for pricing and exchange rate
36	NET_WEIGHT	☐	NTGEW_15	MENG15	QUAN	15	3	Net weight
37	GROSS_WT	☐	BRGEW_15	MENG15	QUAN	15	3	Gross weight
38	UNIT_OF_WT	☐	GEWEI	MEINS	UNIT	3	0	Weight Unit	*
39	UNIT_OF_WT_ISO	☐	GEWEI_ISO	ISOCD_UNIT	CHAR	3	0	Unit of weight in ISO code	*
40	VOLUME	☐	VOLUM_15	MENG15	QUAN	15	3	Volume
41	VOLUMEUNIT	☐	VOLEH	MEINS	UNIT	3	0	Volume unit	*
42	VOLUMEUNIT_ISO	☐	VOLEH_ISO	ISOCD_UNIT	CHAR	3	0	Volume unit in ISO code	*
43	VAL_TYPE	☐	BWTAR_D	BWTAR	CHAR	10	0	Valuation type	*
44	VAL_CAT	☐	BWTTY_D	BWTTY	CHAR	1	0	Valuation Category	*
45	BON_GRP1	☐	EBONU	EBONU	CHAR	2	0	Settlement Group 1 (Purchasing)
46	BON_GRP2	☐	EBON2	EBONU	CHAR	2	0	Settlement Group 2 (Rebate Settlement, Purchasing)
47	BON_GRP3	☐	EBON3	EBONU	CHAR	2	0	Settlement Group 3 (Rebate Settlement, Purchasing)
48	POINTS	☐	ANZPU	MENG13	QUAN	13	3	Number of Points
49	POINT_UNIT	☐	PUNEI	MEINS	UNIT	3	0	Points unit	*
50	POINTS_UN_ISO	☐	PUNEI_ISO	ISOCD_UNIT	CHAR	3	0	ISO Code for Points Unit	*
51	ORIG_DOC_HEAD	☐	WBELN_V	CHAR10	CHAR	10	0	Triggering document of the agency document
52	ORIG_DOC_ITEM	☐	POSNR_V	NUMC6	NUMC	6	0	Triggering item in the agency document
53	ORIG_DOC_CAT	☐	WFTYP_V	WFTYP_V	CHAR	2	0	Agency Business: Document Category of Triggering Document
54	CONTRACT	☐	WCONTRACT	WCONTRACT	CHAR	10	0	Referencing Contract Number
55	CONTRACT_TYPE	☐	WCONTRACT_TYPE	WCONTRACT_TYPE	CHAR	1	0	Contract Type for Contract Number
56	COND_GROUP	☐	EKKOG	CHAR4	CHAR	4	0	Condition Group with Vendor
57	VEND_MAT_TYPE	☐	WLF_IDNLF_TYPE	WLF_IDNLF_TYPE	CHAR	4	0	AB: Article Number Type - Vendor	*
58	VEND_MAT	☐	IDNLF	IDNEX	CHAR	35	0	Material Number Used by Vendor
59	CONTRACT_ITEM	☐	WCONTRACT_ITEM	NUMC6	NUMC	6	0	Referencing Contract Item Number
60	BILL_PRICE_UNIT	☐	WFPRME	MEINS	UNIT	3	0	Billing price unit	*
61	BILL_UNIT_NUM	☐	WPUMZ	UMBSZ	DEC	5	0	Vendor billing doc.: numerator for converting BPUn to PBUn
62	BILL_UNIT_DEN	☐	WPUMN	UMBSZ	DEC	5	0	Vendor billing doc.: denominator for converting BPUn to PBUn
63	BILL_PRICE_UNIT_ISO	☐	ISOCD_UNIT	ISOCD_UNIT	CHAR	3	0	ISO code for unit of measurement	*
64	INCOTERMS1	☐	INCO1	INCO1	CHAR	3	0	Incoterms (part 1)	*
65	INCOTERMS2	☐	INCO2	INCO2	CHAR	28	0	Incoterms (part 2)

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	BAPILFITEMO	BUS_AREA	TGSB	GSBER	KEY	1	CN
2	BAPILFITEMO	COSTCENTER	CSKS	KOSTL
3	BAPILFITEMO	ITEM	WBRP	POSNR
4	BAPILFITEMO	MATERIAL	MARA	MATNR
5	BAPILFITEMO	MATL_GROUP	T023	MATKL
6	BAPILFITEMO	PLANT	T001W	WERKS	KEY	1	CN
7	BAPILFITEMO	PROFIT_CTR	CEPC	PRCTR
8	BAPILFITEMO	TAXJURCODE	TTXJ	TXJCD
9	BAPILFITEMO	TAX_CODE	T007A	MWSKZ
10	BAPILFITEMO	VEND_PART	WYT1	LTSNR

History

Last changed by/on	SAP	20130529
SAP Release Created in