SAP ABAP Table WB2_SI_LST_DATA (Data From Sales Documents: Invoice List)

Hierarchy

☛

EA-GLTRADE (Software Component) SAP Enterprise Extension Global Trade
⤷

LO-GT-TEW (Application Component) Trading Execution Workbench
⤷

WB2B_TEW (Package) Trading Execution Workbench

Basic Data

Table Category	INTTAB	Structure
Structure	WB2_SI_LST_DATA	Table Relationship Diagram
Short Description	Data From Sales Documents: Invoice List

Delivery and Maintenance

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

Components


	Field	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	DOC_KEY	WB2_DOC_KEY		CHAR	20	0	Document Key
2	ITEM_KEY	WB2_ITEM_KEY		CHAR	16	0	Item Key
3	VBELN	VBELN_RL	VBELN	CHAR	10	0	Invoice list	*
4	POSNR	POSNR_RL	POSNR_RL	NUMC	6	0	Invoice list item	*
5	VBRK	WB2_VBRK		STRU	0	0
6	.INCLUDE				0	0	Billing Document: Header Data
7	MANDT	MANDT	MANDT	CLNT	3	0	Client
8	VBELN	VBELN_VF	VBELN	CHAR	10	0	Billing document
9	FKART	FKART	FKART	CHAR	4	0	Billing Type
10	FKTYP	FKTYP	FKTYP	CHAR	1	0	Billing Category
11	VBTYP	VBTYP	VBTYP	CHAR	1	0	SD document category
12	WAERK	WAERK	WAERS	CUKY	5	0	SD document currency
13	VKORG	VKORG	VKORG	CHAR	4	0	Sales Organization
14	VTWEG	VTWEG	VTWEG	CHAR	2	0	Distribution Channel
15	KALSM	KALSMASD	KALSM	CHAR	6	0	Sales and Distribution: Pricing Procedure in Pricing
16	KNUMV	KNUMV	KNUMV	CHAR	10	0	Number of the document condition
17	VSBED	VSBED	VSBED	CHAR	2	0	Shipping conditions
18	FKDAT	FKDAT	DATUM	DATS	8	0	Billing date for billing index and printout
19	BELNR	BELNR_D	BELNR	CHAR	10	0	Accounting Document Number
20	GJAHR	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
21	POPER	POPER	POPER	NUMC	3	0	Posting period
22	KONDA	KONDA	KONDA	CHAR	2	0	Price Group (Customer)
23	KDGRP	KDGRP	KDGRP	CHAR	2	0	Customer group
24	BZIRK	BZIRK	BZIRK	CHAR	6	0	Sales district
25	PLTYP	PLTYP	PLTYP	CHAR	2	0	Price list type
26	INCO1	INCO1	INCO1	CHAR	3	0	Incoterms (part 1)
27	INCO2	INCO2	INCO2	CHAR	28	0	Incoterms (part 2)
28	EXPKZ	EXPKZ	EXPKZ	CHAR	1	0	Export indicator
29	RFBSK	RFBSK	RFBSK	CHAR	1	0	Status for transfer to accounting
30	MRNKZ	MRNKZ	XFELD	CHAR	1	0	Manual invoice maintenance
31	KURRF	KURRF	KURRF	DEC	9	5	Exchange rate for FI postings
32	CPKUR	CPKUR	CPKUR	CHAR	1	0	ID:Exchange rate setting (no new rate determ.in bill.doc.)
33	VALTG	VALTG	TAGE2	NUMC	2	0	Additional value days
34	VALDT	VALDT	DATUM	DATS	8	0	Fixed value date
35	ZTERM	DZTERM	ZTERM	CHAR	4	0	Terms of payment key
36	ZLSCH	SCHZW_BSEG	ZLSCH	CHAR	1	0	Payment Method
37	KTGRD	KTGRD	KTGRD	CHAR	2	0	Account assignment group for this customer
38	LAND1	LLAND	LAND1	CHAR	3	0	Destination Country
39	REGIO	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)
40	COUNC	COUNC	COUNC	CHAR	3	0	County Code
41	CITYC	CITYC	CITYC	CHAR	4	0	City Code
42	BUKRS	BUKRS	BUKRS	CHAR	4	0	Company Code
43	TAXK1	TAXK1	TAXKD	CHAR	1	0	Tax classification 1 for customer
44	TAXK2	TAXK2	TAXKD	CHAR	1	0	Tax classification 2 for customer
45	TAXK3	TAXK3	TAXKD	CHAR	1	0	Tax classification 3 for customer
46	TAXK4	TAXK4	TAXKD	CHAR	1	0	Tax classification 4 for customer
47	TAXK5	TAXK5	TAXKD	CHAR	1	0	Tax classification 5 for customer
48	TAXK6	TAXK6	TAXKD	CHAR	1	0	Tax classification 6 for customer
49	TAXK7	TAXK7	TAXKD	CHAR	1	0	Tax classification 7 for customer
50	TAXK8	TAXK8	TAXKD	CHAR	1	0	Tax classification 8 for customer
51	TAXK9	TAXK9	TAXKD	CHAR	1	0	Tax classification 9 for customer
52	NETWR	NETWR	WERTV8	CURR	15	2	Net Value in Document Currency
53	ZUKRI	DZUKRI	CHAR40	CHAR	40	0	Combination criteria in the billing document
54	ERNAM	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
55	ERZET	ERZET	UZEIT	TIMS	6	0	Entry time
56	ERDAT	ERDAT	DATUM	DATS	8	0	Date on which the record was created
57	STAFO	STAFO	STAFO	CHAR	6	0	Update group for statistics update
58	KUNRG	KUNRG	KUNNR	CHAR	10	0	Payer
59	KUNAG	KUNAG	KUNNR	CHAR	10	0	Sold-to party
60	MABER	MABER	MABER	CHAR	2	0	Dunning Area
61	STWAE	STWAE	WAERS	CUKY	5	0	Statistics currency
62	EXNUM	EXNUM	EXNUM	CHAR	10	0	Number of foreign trade data in MM and SD documents
63	STCEG	STCEG	STCEG	CHAR	20	0	VAT Registration Number
64	AEDAT	AEDAT	DATUM	DATS	8	0	Last Changed On
65	SFAKN	SFAKN	VBELN	CHAR	10	0	Cancelled billing document number
66	KNUMA	KNUMA	KNUMA	CHAR	10	0	Agreement (various conditions grouped together)
67	FKART_RL	FKART_RL	FKART	CHAR	4	0	Invoice list type
68	FKDAT_RL	FKDAT_RL	DATUM	DATS	8	0	Billing date for the invoice list
69	KURST	KURST	KURST	CHAR	4	0	Exchange Rate Type
70	MSCHL	MSCHL	MSCHL	CHAR	1	0	Dunning key
71	MANSP	MANSP	MANSP	CHAR	1	0	Dunning block
72	SPART	SPART	SPART	CHAR	2	0	Division
73	KKBER	KKBER	KKBER	CHAR	4	0	Credit control area
74	KNKLI	KNKLI	KUNNR	CHAR	10	0	Customer's account number with credit limit reference
75	CMWAE	WAERS_CM	WAERS	CUKY	5	0	Currency key of credit control area
76	CMKUF	CMKUF	KURRF	DEC	9	5	Credit data exchange rate at billing document rate
77	HITYP_PR	HITYP_PR	HITYP	CHAR	1	0	Hierarchy type for pricing
78	BSTNK_VF	BSTKD	BSTKD	CHAR	35	0	Customer purchase order number
79	VBUND	RASSC	RCOMP	CHAR	6	0	Company ID of trading partner
80	FKART_AB	FKART_AB	FKART	CHAR	4	0	Accrual billing type
81	KAPPL	KAPPL	KAPPL	CHAR	2	0	Application
82	LANDTX	LANDTX	LAND1	CHAR	3	0	Tax Departure Country
83	STCEG_H	STCEG_H	STCEG_H	CHAR	1	0	Origin of sales tax ID number
84	STCEG_L	STCEG_L	LAND1	CHAR	3	0	Country of sales tax ID number
85	XBLNR	XBLNR_V1	XBLNR1	CHAR	16	0	Reference Document Number
86	ZUONR	ORDNR_V	ZUONR	CHAR	18	0	Assignment Number
87	MWSBK	MWSBP	WERTV7	CURR	13	2	Tax amount in document currency
88	LOGSYS	LOGSYS	LOGSYS	CHAR	10	0	Logical system
89	FKSTO	FKSTO	XFELD	CHAR	1	0	Billing document is cancelled
90	XEGDR	XEGDR	XFELD	CHAR	1	0	Indicator: Triangular deal within the EU ?
91	RPLNR	RPLNR	FPLNR	CHAR	10	0	Installment Plan Number
92	LCNUM	LCNUM	LCNUM	CHAR	10	0	Financial doc. processing: Internal financial doc. number
93	J_1AFITP	J_1AFITP_D	J_1AFITP	CHAR	2	0	Tax type
94	KURRF_DAT	WWERT_D	DATUM	DATS	8	0	Translation date
95	AKWAE	AKWAE	WAERS	CUKY	5	0	Currency key for letter-of-credit procg in foreign trade
96	AKKUR	AKKUR	KURRF	DEC	9	5	Exchange rate for letter-of-credit procg in foreign trade
97	KIDNO	KIDNO	CHAR30	CHAR	30	0	Payment Reference
98	BVTYP	BVTYP	BVTYP	CHAR	4	0	Partner bank type
99	NUMPG	J_1ANOPG	J_1ANOPG	NUMC	3	0	Number of pages of invoice
100	BUPLA	BUPLA	J_1BBRANCH	CHAR	4	0	Business Place
101	VKONT	CORR_VKONT_KK	CORR_VKONT_KK	CHAR	12	0	Contract Account Number
102	FKK_DOCSTAT	DOCSTAT_KK	DOCSTAT_KK	CHAR	1	0	Additional Status Transfer to Fin. Accounting (Res. RFBSK)
103	NRZAS	CHAR12	CHAR12	CHAR	12	0	Character Field of Length 12
104	SPE_BILLING_IND	/SPE/DE_BILLING_IND	/SPE/DE_BILLING_IND	CHAR	1	0	EWM Billing Indicator
105	VTREF	CORR_VTREF_KK	CORR_VTREF_KK	CHAR	20	0	Reference Specifications from Contract
106	FK_SOURCE_SYS	FK_SOURCE_SYS	LOGSYS	CHAR	10	0	Source System
107	FKTYP_CRM	FKTYP_CRM	FKTYP	CHAR	1	0	Billing Category in CRM
108	STGRD	STGRD	STGRD	CHAR	2	0	Reason for Reversal
109	VBTYP_EXT	TDD_VBTYP_EXT	DOM_VBTYP_EXT	CHAR	4	0	Extension of SD Document Category
110	.INCLU--AP				0	0	VBRK append for Down Payment Chain
111	DPC_REL	/SAPPCE/DPC_REL	CHAR01	CHAR	1	0	Flag: DPC relevant
112	.INCLU--AP				0	0	VBRK_SEPA
113	.INCLUDE				0	0	SEPA SD Struktur
114	MNDID	SEPA_MNDID	ID035	CHAR	35	0	Unique Referene to Mandate per Payment Recipient
115	PAY_TYPE	SEPA_PAY_TYPE	SEPA_PAY_TYPE	CHAR	1	0	SEPA: Payment Type
116	SEPON	SD_SEPA_FLAG	SD_SEPA_FLAG	CHAR	1	0	SEPA-Relevance
117	MNDVG	SD_SEPA_FLAG	SD_SEPA_FLAG	CHAR	1	0	SEPA-Relevance
118	.INCLU--AP				0	0	Append Structure for Special Paymenents
119	SPPAYM	SPPAYM	SPPAYM	CHAR	2	0	Payment Form for Special Payment Method
120	SPPORD	SPPORD	VBELN	CHAR	10	0	Sales Order for Special Payment Method
121	.INCLU-_GT				0	0	Customer Billing Document: Dynamic Header Data
122	FILTERED_OUT_GT	WB2_FILTERED_OUT	WB2_FILTERED_OUT	CHAR	1	0	Filtered Out
123	EXTERNAL_NO_GT	TKONN_EX	TKONN_EX	CHAR	30	0	Trading Contract: External Document Number
124	SCENARIO_GT	WB2_BUSINESS_SCENARIO	WB2_BUSINESS_SCENARIO	CHAR	2	0	Business Scenario
125	VBRL	WB2_VBRL		STRU	0	0
126	.INCLUDE				0	0	Sales Document: Invoice List
127	MANDT	MANDT	MANDT	CLNT	3	0	Client
128	VBELN	VBELN_RL	VBELN	CHAR	10	0	Invoice list
129	POSNR	POSNR_RL	POSNR_RL	NUMC	6	0	Invoice list item
130	VBELN_VF	VBELN_VF	VBELN	CHAR	10	0	Billing document
131	NETWR	NETWR	WERTV8	CURR	15	2	Net Value in Document Currency
132	MWSBP	MWSBP	WERTV7	CURR	13	2	Tax amount in document currency
133	KWERT_RL	KWERT_RL	WERTV7	CURR	13	2	Value of Remuneration List Condition of Indiv. Billing Doc.
134	MWSBP_RL	MWSBP_RL	WERTV7	CURR	13	2	Amount of Tax in Remuneration List Condition
135	KUNAG	KUNAG	KUNNR	CHAR	10	0	Sold-to party
136	UVPRS	UVPRS	XFELD	CHAR	1	0	Incomplete with respect to pricing
137	LOGSYS	LOGSYS	LOGSYS	CHAR	10	0	Logical system
138	.INCLU-_GT				0	0	Invoice List: Dynamic Item Data
139	SCENARIO_GT	WB2_BUSINESS_SCENARIO	WB2_BUSINESS_SCENARIO	CHAR	2	0	Business Scenario
140	FILTERED_OUT_GT	WB2_FILTERED_OUT	WB2_FILTERED_OUT	CHAR	1	0	Filtered Out
141	NOT_REF_QUAN_GT	WB2_NOT_REF_QUAN	MENG15	QUAN	15	3	Open Quantity
142	NOT_REF_QUAN_UNIT_GT	WB2_NOT_REF_QUAN_UNIT	MEINS	UNIT	3	0	Open Quantity Unit
143	EXTERNAL_NO_GT	TKONN_EX	TKONN_EX	CHAR	30	0	Trading Contract: External Document Number
144	VBRK_WAERK_GT	WAERS	WAERS	CUKY	5	0	Currency Key
145	KOMK_WAERK_GT	WAERS	WAERS	CUKY	5	0	Currency Key
146	.INCLUDE				0	0	Dynamic Part of Data for Subsequent Action
147	ASSOC_QUAN_B	WB2_ASSOCIATED_QUAN	MENGV15	QUAN	15	3	Assoc. Mngt: Actually Associated Quantity of an Item
148	UNIT_OF_QUAN_B	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	*
149	ASSOC_QUAN_S	WB2_ASSOCIATED_QUAN	MENGV15	QUAN	15	3	Assoc. Mngt: Actually Associated Quantity of an Item
150	UNIT_OF_QUAN_S	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	*
151	ASSOC_QUAN_P	WB2_ASSOCIATED_QUAN	MENGV15	QUAN	15	3	Assoc. Mngt: Actually Associated Quantity of an Item
152	UNIT_OF_QUAN_P	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	*
153	PORTFOLIO	WB2_PORTFOLIO	KNUMB	CHAR	10	0	Global Trade: (Internal) Portfolio Number