SAP table WB2_SI_LST_DATA (Data From Sales Documents: Invoice List)

Field Description Data Type Length Decimals Checktable Data Element
DOC_KEY Document Key CHAR 42 0 WB2_DOC_KEY
ITEM_KEY Item Key CHAR 16 0 WB2_ITEM_KEY
VBELN Invoice List CHAR 10 0 VBELN_RL
POSNR Invoice list item NUMC 6 0 POSNR_RL
VBRK STRU 0 0 WB2_VBRK
MANDT Client CLNT 3 0 MANDT
VBELN Billing Document CHAR 10 0 VBELN_VF
FKART Billing Type CHAR 4 0 FKART
FKTYP Billing Category CHAR 1 0 FKTYP
A Order-related billing document
B Order-related billing document for rebate settlement
C Order-related billing document for partial rebate settlement
D Periodic billing document
E Periodic billing with active invoice accrual
F Accrual
I Delivery-related billing document for inter-company billing
K Order-related billing document for rebate correction
L Delivery-related billing document
P Down payment request
R Invoice list
S CRM Billing Document
U Billing request
W POS billing document
X Billing using general interface
VBTYP SD Document Category CHAR 4 0 VBTYPL
# Revenue Recognition (Temporary)
$ (AFS)
& Warehouse Document
* Pick Order
+ Journal Entry (Temporary)
, Shipment Document
- Journal Entry (Temporary)
. Service Notification
0 Master Contract
1 Sales Activities (CAS)
2 External Transaction
3 Invoice List
4 Credit Memo List
5 Intercompany Invoice
6 Intercompany Credit Memo
7 Delivery/Shipping Notification
8 Shipment
: Service Order
A Inquiry
a Shipment Costs
b CRM Opportunity
B Quotation
BOS Service Entry Sheet
C Order
c Unverified Delivery
CEM ETM Shipping Document
CMMA Customer Management Master Agreement
CSCO Customer Management Service Confirmation
CSCT Customer Management Service Contract
CSVO Customer Management Service Order
D Item Proposal
d Trading Contract
e Allocation Table
E Scheduling Agreement
EBDR Billing Document Request
F Scheduling Agreement with External Service Agent
f001 Period-End Invoice
f002 Period-End Credit Memo
f003 Period-End Invoice (Intercompany Billing)
f004 Period-End Credit Memo (Intercompany Billing)
G Contract
g Rough Goods Receipt (only IS-Retail)
GBRQ Grants Management Billing Request
h Cancel Goods Issue
H Returns
i Goods Receipt
I Order Without Charge
J Delivery
j JIT Call
K Credit Memo Request
k Settlement Management Document
L Debit Memo Request
M Invoice
N Invoice Cancellation
n Reserved
O Credit Memo
o Reserved
P Debit Memo
p Goods Movement (Documentation)
PBD Preliminary Billing Document
PBDR Billing Document Request for Prof. Serv.
PBRQ Project Billing Request
q Reserved
Q WMS Transfer Order
R Goods Movement
r TD Transport (Only IS-Oil)
S Credit Memo Cancellation
s Load Confirmation, Reposting (Only IS-Oil)
SBRQ Subscription Billing Request
SOLO Solution Order
t Gain / Loss (Only IS-Oil)
T Returns Delivery for Order
TMFO Freight Order
TMFU Freight Unit
U Pro Forma Invoice
u Reentry into Storage (Only IS-Oil)
v Data Collation (Only IS-Oil)
V Purchase Order
W Independent Reqts Plan
w Reservation (Only IS-Oil)
X Handling Unit
x Load Confirmation, Goods Receipt (Only IS-Oil)
Y Rebate Agreement
^ Reserved
| Reserved
~ Revenue Cancellation (Temporary)
ยง Revenue Recognition/New View (Temporary)
WAERK SD Document Currency CUKY 5 0 WAERK
VKORG Sales Organization CHAR 4 0 VKORG
VTWEG Distribution Channel CHAR 2 0 VTWEG
KALSM Pricing Procedure in Pricing CHAR 6 0 KALSMASD
KNUMV Number of the Document Condition CHAR 10 0 KNUMV
VSBED Shipping Conditions CHAR 2 0 VSBED
FKDAT Billing Date DATS 8 0 FKDAT
BELNR Document Number of an Accounting Document CHAR 10 0 BELNR_D
GJAHR Fiscal Year NUMC 4 0 GJAHR
POPER Posting period NUMC 3 0 POPER
KONDA Customer Price Group CHAR 2 0 KONDA
KDGRP Customer Group CHAR 2 0 KDGRP
BZIRK Sales District CHAR 6 0 BZIRK
PLTYP Price List Type CHAR 2 0 PLTYP
INCO1 Incoterms (Part 1) CHAR 3 0 INCO1
INCO2 Incoterms (Part 2) CHAR 28 0 INCO2
RFBSK Status for Transfer to Accounting CHAR 1 0 RFBSK
Error in Accounting Interface
A Billing document blocked for forwarding to FI
B Journal entry not created (account determination error)
C Journal entry has been created
D Billing document is not relevant for accounting
E Billing document canceled
F Journal entry not created (pricing error)
G Journal entry not created (export data missing)
H Posted via invoice list
I Posted via invoice list (account determination error)
K Journal entry not created (no authorization)
L Billing doc. blocked for transfer to manager (only IS-OIL)
M Analyst Approval refused (only IS-OIL)
N No Journal entry due to fund management (only IS-PS)
MRNKZ Manual Invoice Maintenance CHAR 1 0 MRNKZ
KURRF Exchange Rate for Postings to Financial Accounting DEC 9 5 KURRF
CPKUR Exchange Rate Setting CHAR 1 0 CPKUR
VALTG Additional Value Days NUMC 2 0 VALTG
VALDT Fixed Value Date DATS 8 0 VALDT
ZTERM Terms of payment key CHAR 4 0 DZTERM
ZLSCH Payment Method CHAR 1 0 SCHZW_BSEG
KTGRD Account Assignment Group for this Customer CHAR 2 0 KTGRD
LAND1 Destination Country/Region CHAR 3 0 LLAND
REGIO Region (State, Province, County) CHAR 3 0 REGIO
COUNC County Code CHAR 3 0 COUNC
CITYC City Code CHAR 4 0 CITYC
BUKRS Company Code CHAR 4 0 BUKRS
TAXK1 Tax Classification 1 for Customer CHAR 1 0 TAXK1
TAXK2 Tax Classification 2 for Customer CHAR 1 0 TAXK2
TAXK3 Tax Classification 3 for Customer CHAR 1 0 TAXK3
TAXK4 Tax Classification 4 for Customer CHAR 1 0 TAXK4
TAXK5 Tax Classification 5 for Customer CHAR 1 0 TAXK5
TAXK6 Tax Classification 6 for Customer CHAR 1 0 TAXK6
TAXK7 Tax Classification 7 for Customer CHAR 1 0 TAXK7
TAXK8 Tax Classification 8 for Customer CHAR 1 0 TAXK8
TAXK9 Tax Classification 9 for Customer CHAR 1 0 TAXK9
NETWR Net Value in Document Currency CURR 15 2 NETWR
ZUKRI Combination criteria in the billing document CHAR 40 0 DZUKRI
ERNAM Name of Person Responsible for Creating the Object CHAR 12 0 ERNAM
ERZET Entry time TIMS 6 0 ERZET
ERDAT Date on which the record was created DATS 8 0 ERDAT
STAFO Update Group for statistics update CHAR 6 0 STAFO
KUNRG Payer CHAR 10 0 KUNRG
KUNAG Sold-to Party CHAR 10 0 KUNAG
MABER Dunning Area CHAR 2 0 MABER
STWAE Statistics Currency CUKY 5 0 STWAE
STCEG VAT Registration Number CHAR 20 0 STCEG
AEDAT Last Changed On DATS 8 0 AEDAT
SFAKN Number of canceled billing document CHAR 10 0 SFAKN
KNUMA Agreement (various conditions grouped together) CHAR 10 0 KNUMA
FKART_RL Invoice List Type CHAR 4 0 FKART_RL
FKDAT_RL Billing date for the invoice list DATS 8 0 FKDAT_RL
KURST Exchange Rate Type CHAR 4 0 KURST
MSCHL Dunning Key CHAR 1 0 MSCHL
MANSP Dunning Block CHAR 1 0 MANSP
SPART Division CHAR 2 0 SPART
KKBER Credit control area CHAR 4 0 KKBER
KNKLI Customer's Account Number with Credit Limit Reference CHAR 10 0 KNKLI
CMWAE Currency key of credit control area CUKY 5 0 WAERS_CM
CMKUF Credit data exchange rate at billing document rate DEC 9 5 CMKUF
HITYP_PR Hierarchy type for pricing CHAR 1 0 HITYP_PR
BSTNK_VF Customer Reference CHAR 35 0 BSTKD
VBUND Company ID of Trading Partner CHAR 6 0 RASSC
FKART_AB Accrual Billing Type CHAR 4 0 FKART_AB
KAPPL Application CHAR 2 0 KAPPL
LANDTX Tax Departure Country/Region CHAR 3 0 LANDTX
STCEG_H Origin of Sales Tax ID Number CHAR 1 0 STCEG_H
A Ship-to Party
B Payer
C Sold-to Party
D Payer (KNAS segment)
E Manually entered or changed
F Entered manually in order
G Own VAT reg. no. in dest. country
H Payer for tax receiving country from order
I Sold-to party for tax receiving country from order
J Sold-to Party (segment KNAS)
STCEG_L Country/Region of Sales Tax ID Number CHAR 3 0 STCEG_L
XBLNR Reference Document Number CHAR 16 0 XBLNR_V1
ZUONR Assignment Number CHAR 18 0 ORDNR_V
MWSBK Tax Amount in Document Currency CURR 13 2 MWSBP
LOGSYS Logical system CHAR 10 0 LOGSYS
FKSTO Billing document is canceled CHAR 1 0 FKSTO
XEGDR Indicator: Triangular Deal Within the EU CHAR 1 0 XEGDR
RPLNR Number of payment card plan type CHAR 10 0 RPLNR
J_1AFITP Tax type CHAR 2 0 J_1AFITP_D
KURRF_DAT Translation date DATS 8 0 WWERT_D
KIDNO Payment Reference CHAR 30 0 KIDNO
BVTYP Partner bank type CHAR 4 0 BVTYP
NUMPG Number of pages of invoice NUMC 3 0 J_1ANOPG
BUPLA Business Place CHAR 4 0 BUPLA
VKONT Contract Account Number CHAR 12 0 CORR_VKONT_KK
FKK_DOCSTAT Additional Status Transfer to Fin. Accounting (Res. RFBSK) CHAR 1 0 DOCSTAT_KK
1 FI-CA-Inv.: Invoicing Order Created
2 FI-CA-Inv.: Invoicing Document Created
3 FI-CA-Inv.: Invoicing Order Cancelled
A Journal Entry Generated in FI
B Journal Entry Generated in FI-CA
C Billing Doc. Transferred to IS-U, Billing Request Generated
D Billing Doc. Transferred to IS-U, IS-U Billing Doc Generated
E Billing Doc. Transferred to IS-U, Billing Request Cancelled
F Transferral to Financial Accounting Not Neccessary
G Billing Block IDoc Processing
NRZAS Character Field of Length 12 CHAR 12 0 CHAR12
SPE_BILLING_IND EWM Billing Indicator CHAR 1 0 /SPE/DE_BILLING_IND
No Invoice Before Goods Issue
A Direct Billing (Immediately Billing and Printing)
B Wait for Billing Request
VTREF Reference Specifications from Contract CHAR 20 0 CORR_VTREF_KK
FK_SOURCE_SYS Source System CHAR 10 0 FK_SOURCE_SYS
FKTYP_CRM Billing category in SAP S/4HANA for customer management CHAR 1 0 FKTYP_CRM
STGRD Reason for Reversal or Inverse Posting CHAR 2 0 STGRD
CHANGED_ON UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) DEC 21 7 TIMESTAMPL
EXPKZ Export indicator CHAR 1 0 EXPKZ
EXNUM Number of foreign trade data in MM and SD documents CHAR 10 0 EXNUM
AKWAE Currency key for letter-of-credit procg in foreign trade CUKY 5 0 AKWAE
AKKUR Exchange rate for letter-of-credit procg in foreign trade DEC 9 5 AKKUR
LCNUM Financial doc. processing: Internal financial doc. number CHAR 10 0 LCNUM
_DATAAGING Data Filter Value for Data Aging DATS 8 0 DATA_TEMPERATURE
BUCHK Posting Status of Billing Document CHAR 1 0 BUCHK
GBSTK Overall Processing Status (Header/All Items) CHAR 1 0 GBSTK
RELIK Invoice list status of billing document CHAR 1 0 RELIK
UVALS Incompletion Status (All Items) CHAR 1 0 UVALL_SU
UVPRS Pricing Incompletion Status (All Items) CHAR 1 0 UVPRS_UK
CLRST Clearing Status of Billing Document CHAR 1 0 CLRST
Not Relevant
A To Be Cleared
B Partially Cleared
C Fully Cleared
FKSAK Order-Related Billing Status (All Items) CHAR 1 0 FKSAK
FKARA Proposed billing type for an order-related billing document CHAR 4 0 FKARA
VF_STATUS SD Billing Status CHAR 1 0 VF_STATUS
Not Relevant
A Completed
B To Be Posted
C Canceled
D Incomplete
VF_TODO Billing Issue Type CHAR 1 0 VF_TODO
A Accounting Interface
B Account Determination
C Pricing
D Accounting Access
BDR_STATUS Billing Document Request Status CHAR 1 0 BDR_STATUS
Not Relevant
A To Be Invoiced
B Partially Invoiced
C Invoiced
D Rejected
E Incomplete
BDR_REF Source document on which a billing document request is based CHAR 10 0 BDR_REF
BDR_REF_LOGSYS Logical system containing source document of BDR CHAR 10 0 BDR_REF_LOGSYS
BDR_REF_VBTYP SD document category of BDR source document CHAR 4 0 BDR_REF_VBTYP
PBD_STATUS Preliminary Billing Document Status CHAR 1 0 PBD_STATUS
Not Relevant
A In Progress
B Finalized
C Completed
D Rejected
ABSTK Rejection Status (All Items) CHAR 1 0 ABSTK
DRAFT IsDraft Indicator CHAR 1 0 VF_DRAFT_INDICATOR
ACTIVEDOCUMENT Sales and Distribution Document Number CHAR 10 0 VBELN
GRWCU Currency of statistical values for foreign trade CUKY 5 0 GRWCU
BLART Document Type CHAR 2 0 BLART
INTRA_REL Relevant for Intrastat Reporting CHAR 1 0 INTRA_REL
INTRA_EXCL Exclude from Intrastat Reporting CHAR 1 0 INTRA_EXCL
ACCRREL Is relevant for accrual CHAR 1 0 ISACCRUALRELEVANT
PSPSD Payment Split Predecessor Sales Document CHAR 10 0 PSPSD
APM_APPROVAL_STATUS Document Approval Status CHAR 1 0 SD_APM_APPROVAL_STATUS
Not Relevant
A In Approval
B Released
C Rejected
D To Be Reworked
APM_APPROVAL_REASON Approval Request Reason ID CHAR 4 0 SD_APM_APPROVAL_REASON
SRCEDOC_EXT_COMM_SYST_TYPE External Communication System Type of Source Document CHAR 2 0 SRCE_DOC_EXT_COMM_SYST_TYPE
ICO_LIFNR Supplier Number of Plant CHAR 10 0 LIFNR_WK
J_1TPBUPL Branch Code CHAR 5 0 BCODE
INCOV Incoterms Version CHAR 4 0 INCOV
INCO2_L Incoterms Location 1 CHAR 70 0 INCO2_L
INCO3_L Incoterms Location 2 CHAR 70 0 INCO3_L
SDM_VERSION SDM: Version field for VBRK CHAR 2 0 SDBIL_SDM_VERSION_VBRK
01 Analytics fields in VBRP #1
02 Set RFBSK in VBRK for incomplete data #2
DUMMY_BILLINGDOC_INCL_EEW_PS Dummy function in length 1 CHAR 1 0 DUMMY
GLO_LOG_REF1_HD Business Process Indicator for Poland CHAR 25 0 GLO_LOG_REF1_HD
ZAPCGKH Annexing package key NUMC 4 0 /ILE/TAPCGK
APCGK_EXTENDH Extended key for annexing package NUMC 10 0 /ILE/TAPCGK_EXT
ZABDATH Annexing base date DATS 8 0 /ILE/TABDAT
DPC_REL Flag: DPC relevant CHAR 1 0 /SAPPCE/DPC_REL
AD01BASDOC Initial document CHAR 10 0 AD01BASDOC
AD01FAREG Rule for Billing CHAR 1 0 AD01FAREG
A Billing of costs & fees
B Billing of costs only
C Billing of fees only
VCHRNMBR Voucher Number NUMC 8 0 AD04VCHNR
J_3GKBAUL ETM-Relevant Indicator CHAR 1 0 J_3GKBAUL
SAP standard
1 Relevant to CEM with CEM posting rules
2 Relevant to CEM with SAP standard posting rules
3 Program-internal: CEM-relevant co. code to co. code (EDI)
J_3GKENIE Indicator for I(nternal) or E(xternal) Posting CHAR 1 0 J_3GKENIE
E External posting
I Internal posting
KUNWE Ship-to Party CHAR 10 0 KUNWE
MNDID Unique Reference to Mandate for each Payee CHAR 35 0 SEPA_MNDID
PAY_TYPE SEPA: Payment Type CHAR 1 0 SEPA_PAY_TYPE
1 One-Time Mandate
N Recurring Use Mandate
SEPON SEPA-Relevance CHAR 1 0 SD_SEPA_FLAG
No SEPA Relevance
0 SEPA Relevance - No Mandate Assigned
1 SEPA Relevance - Mandate Assigned
MNDVG SEPA-Relevance CHAR 1 0 SD_SEPA_FLAG
No SEPA Relevance
0 SEPA Relevance - No Mandate Assigned
1 SEPA Relevance - Mandate Assigned
SPPAYM Payment Form for Special Payment Method CHAR 2 0 SPPAYM
01 Payment Service Provider
SPPORD Sales Order for Special Payment Method CHAR 10 0 SPPORD
FILTERED_OUT_GT Filtered Out CHAR 1 0 WB2_FILTERED_OUT
EXTERNAL_NO_GT External Identifier in Trading Contract CHAR 30 0 TKONN_EX
SCENARIO_GT Business Scenario CHAR 2 0 WB2_BUSINESS_SCENARIO
VBRL STRU 0 0 WB2_VBRL
MANDT Client CLNT 3 0 MANDT
VBELN Invoice List CHAR 10 0 VBELN_RL
POSNR Invoice list item NUMC 6 0 POSNR_RL
VBELN_VF Billing Document CHAR 10 0 VBELN_VF
NETWR Net Value in Document Currency CURR 15 2 NETWR
MWSBP Tax Amount in Document Currency CURR 13 2 MWSBP
KWERT_RL Factoring (Delcredere) Discount CURR 13 2 KWERT_RL
MWSBP_RL Factoring (Delcredere) Discount Tax CURR 13 2 MWSBP_RL
KUNAG Sold-to Party CHAR 10 0 KUNAG
UVPRS Incomplete with respect to pricing CHAR 1 0 UVPRS
LOGSYS Logical system CHAR 10 0 LOGSYS
_DATAAGING Data Filter Value for Data Aging DATS 8 0 DATA_TEMPERATURE
SCENARIO_GT Business Scenario CHAR 2 0 WB2_BUSINESS_SCENARIO
FILTERED_OUT_GT Filtered Out CHAR 1 0 WB2_FILTERED_OUT
NOT_REF_QUAN_GT Open Quantity QUAN 15 3 WB2_NOT_REF_QUAN
NOT_REF_QUAN_UNIT_GT Open Quantity Unit UNIT 3 0 WB2_NOT_REF_QUAN_UNIT
EXTERNAL_NO_GT External Identifier in Trading Contract CHAR 30 0 TKONN_EX
VBRK_WAERK_GT Currency Key CUKY 5 0 WAERS
KOMK_WAERK_GT Currency Key CUKY 5 0 WAERS
ASSOC_QUAN_B Actually Associated Quantity of an Item QUAN 15 3 WB2_ASSOCIATED_QUAN
UNIT_OF_QUAN_B Base Unit of Measure UNIT 3 0 * MEINS
ASSOC_QUAN_S Actually Associated Quantity of an Item QUAN 15 3 WB2_ASSOCIATED_QUAN
UNIT_OF_QUAN_S Base Unit of Measure UNIT 3 0 * MEINS
ASSOC_QUAN_P Actually Associated Quantity of an Item QUAN 15 3 WB2_ASSOCIATED_QUAN
UNIT_OF_QUAN_P Base Unit of Measure UNIT 3 0 * MEINS
PORTFOLIO Portfolio Number(Internal) CHAR 10 0 WB2_PORTFOLIO