1. Home
  2. Resources
  3. SAP Tables
  4. WCB_ALL_BILL_DATA - WCB: Data for a Sales Invoice

SAP Table WCB_ALL_BILL_DATA

WCB: Data for a Sales Invoice

WCB_ALL_BILL_DATA (WCB: Data for a Sales Invoice) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link WCB_ALL_BILL_DATA to other SAP tables.

WCB_ALL_BILL_DATA table fields

Field Data element Checktable Datatype Length Decimals
VBELN Billing Document VBELN_VF CHAR 10 0
VBRK VBRK STRU 0 0
MANDT Client MANDT CLNT 3 0
VBELN Billing Document VBELN_VF CHAR 10 0
FKART Billing Type FKART CHAR 4 0
FKTYP Billing category FKTYP CHAR 1 0
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
U Billing request
W POS billing document
X Billing using general interface
S CRM Billing Document
N Provisional or Differential Billing Document
O Final Billing Document
VBTYP SD document category VBTYP CHAR 1 0
A Inquiry
B Quotation
C Order
D Item proposal
E Scheduling agreement
F Scheduling agreement with external service agent
G Contract
H Returns
I Order w/o charge
J Delivery
K Credit memo request
L Debit memo request
M Invoice
N Invoice cancellation
O Credit memo
P Debit memo
Q WMS transfer order
R Goods movement
S Credit memo cancellation
T Returns delivery for order
U Pro forma invoice
V Purchase Order
W Independent reqts plan
X Handling unit
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
a Shipment costs
b CRM Opportunity
c Unverified delivery
d Trading Contract
e Allocation table
f Additional Billing Documents
g Rough Goods Receipt (only IS-Retail)
h Cancel Goods Issue
i Goods receipt
j JIT call
n Reserved
o Reserved
p Goods Movement (Documentation)
q Reserved
r TD Transport (only IS-Oil)
s Load Confirmation, Reposting (Only IS-Oil)
t Gain / Loss (Only IS-Oil)
u Reentry into Storage (Only IS-Oil)
v Data Collation (only IS-Oil)
w Reservation (Only IS-Oil)
x Load Confirmation, Goods Receipt (Only IS-Oil)
$ (AFS)
+ Accounting Document (Temporary)
- Accounting Document (Temporary)
# Revenue Recognition (Temporary)
~ Revenue Cancellation (Temporary)
� Revenue Recognition/New View (Temporary)
NULL Revenue Cancellation/New View (Temporary)
: Service Order
. Service Notification
& Warehouse Document
* Pick Order
, Shipment Document
^ Reserved
| Reserved
k Agency Document
WAERK SD Document Currency WAERK CUKY 5 0
VKORG Sales Organization VKORG CHAR 4 0
VTWEG Distribution Channel VTWEG CHAR 2 0
KALSM Sales and Distribution: Pricing Procedure in Pricing KALSMASD CHAR 6 0
KNUMV Number of the document condition KNUMV CHAR 10 0
VSBED Shipping Conditions VSBED CHAR 2 0
FKDAT Billing date for billing index and printout FKDAT DATS 8 0
BELNR Accounting Document Number BELNR_D CHAR 10 0
GJAHR Fiscal Year GJAHR NUMC 4 0
POPER Posting period POPER NUMC 3 0
KONDA Price group (customer) KONDA CHAR 2 0
KDGRP Customer group KDGRP CHAR 2 0
BZIRK Sales district BZIRK CHAR 6 0
PLTYP Price list type PLTYP CHAR 2 0
INCO1 Incoterms (Part 1) INCO1 CHAR 3 0
INCO2 Incoterms (Part 2) INCO2 CHAR 28 0
EXPKZ Export indicator EXPKZ CHAR 1 0
RFBSK Status for transfer to accounting RFBSK CHAR 1 0
NULL Error in Accounting Interface
A Billing document blocked for forwarding to FI
B Posting document not created (account determ.error)
C Posting document has been created
D Billing document is not relevant for accounting
E Billing Document Canceled
F Posting document not created (pricing error)
G Posting document not created (export data missing)
H Posted via invoice list
I Posted via invoice list (account determination error)
K Accounting document not created (no authorization)
L Billing doc. blocked for transfer to manager (only IS-OIL)
M Analyst Approval refused (only IS-OIL)
N No posting document due to fund management (only IS-PS)
MRNKZ Manual invoice maintenance MRNKZ CHAR 1 0
X Yes
NULL No
KURRF Exchange rate for FI postings KURRF DEC 9 5
CPKUR ID:Exchange rate setting (no new rate determ.in bill.doc.) CPKUR CHAR 1 0
NULL No exchange rate setting
X Exchange rate setting
VALTG Additional value days VALTG NUMC 2 0
VALDT Fixed value date VALDT DATS 8 0
ZTERM Terms of Payment Key DZTERM CHAR 4 0
ZLSCH Payment Method SCHZW_BSEG CHAR 1 0
KTGRD Account assignment group for this customer KTGRD CHAR 2 0
LAND1 Country of Destination LLAND CHAR 3 0
REGIO Region (State, Province, County) REGIO CHAR 3 0
COUNC County Code COUNC CHAR 3 0
CITYC City Code CITYC CHAR 4 0
BUKRS Company Code BUKRS CHAR 4 0
TAXK1 Tax classification 1 for customer TAXK1 CHAR 1 0
TAXK2 Tax classification 2 for customer TAXK2 CHAR 1 0
TAXK3 Tax classification 3 for customer TAXK3 CHAR 1 0
TAXK4 Tax Classification 4 Customer TAXK4 CHAR 1 0
TAXK5 Tax classification 5 for customer TAXK5 CHAR 1 0
TAXK6 Tax classification 6 for customer TAXK6 CHAR 1 0
TAXK7 Tax classification 7 for customer TAXK7 CHAR 1 0
TAXK8 Tax classification 8 for customer TAXK8 CHAR 1 0
TAXK9 Tax classification 9 for customer TAXK9 CHAR 1 0
NETWR Net Value in Document Currency NETWR CURR 15 2
ZUKRI Combination criteria in the billing document DZUKRI CHAR 40 0
ERNAM Name of Person who Created the Object ERNAM CHAR 12 0
ERZET Entry time ERZET TIMS 6 0
ERDAT Date on Which Record Was Created ERDAT DATS 8 0
STAFO Update group for statistics update STAFO CHAR 6 0
KUNRG Payer KUNRG CHAR 10 0
KUNAG Sold-to party KUNAG CHAR 10 0
MABER Dunning Area MABER CHAR 2 0
STWAE Statistics currency STWAE CUKY 5 0
EXNUM Number of foreign trade data in MM and SD documents EXNUM CHAR 10 0
STCEG VAT Registration Number STCEG CHAR 20 0
AEDAT Changed On AEDAT DATS 8 0
SFAKN Cancelled billing document number SFAKN CHAR 10 0
KNUMA Agreement (various conditions grouped together) KNUMA CHAR 10 0
FKART_RL Invoice list type FKART_RL CHAR 4 0
FKDAT_RL Billing date for the invoice list FKDAT_RL DATS 8 0
KURST Exchange Rate Type KURST CHAR 4 0
MSCHL Dunning key MSCHL CHAR 1 0
MANSP Dunning block MANSP CHAR 1 0
SPART Division SPART CHAR 2 0
KKBER Credit control area KKBER CHAR 4 0
KNKLI Customer's account number with credit limit reference KNKLI CHAR 10 0
CMWAE Currency key of credit control area WAERS_CM CUKY 5 0
CMKUF Credit data exchange rate at billing document rate CMKUF DEC 9 5
HITYP_PR Hierarchy type for pricing HITYP_PR CHAR 1 0
BSTNK_VF Customer purchase order number BSTKD CHAR 35 0
VBUND Company ID of trading partner RASSC CHAR 6 0
FKART_AB Accrual billing type FKART_AB CHAR 4 0
KAPPL Application KAPPL CHAR 2 0
LANDTX Tax departure country LANDTX CHAR 3 0
STCEG_H Origin of sales tax ID number STCEG_H CHAR 1 0
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 of Sales Tax ID Number STCEG_L CHAR 3 0
XBLNR Reference Document Number XBLNR_V1 CHAR 16 0
ZUONR Assignment number ORDNR_V CHAR 18 0
MWSBK Tax amount in document currency MWSBP CURR 13 2
LOGSYS Logical system LOGSYS CHAR 10 0
FKSTO Billing document is cancelled FKSTO CHAR 1 0
X Yes
NULL No
XEGDR Indicator: Triangular deal within the EU ? XEGDR CHAR 1 0
X Yes
NULL No
RPLNR Number of payment card plan type RPLNR CHAR 10 0
LCNUM Financial doc. processing: Internal financial doc. number LCNUM CHAR 10 0
J_1AFITP Tax type J_1AFITP_D CHAR 2 0
KURRF_DAT Translation Date WWERT_D DATS 8 0
AKWAE Currency key for letter-of-credit procg in foreign trade AKWAE CUKY 5 0
AKKUR Exchange rate for letter-of-credit procg in foreign trade AKKUR DEC 9 5
KIDNO Payment Reference KIDNO CHAR 30 0
BVTYP Partner Bank Type BVTYP CHAR 4 0
NUMPG Number of pages of invoice J_1ANOPG NUMC 3 0
BUPLA Business Place BUPLA CHAR 4 0
VKONT Contract Account Number CORR_VKONT_KK CHAR 12 0
FKK_DOCSTAT Additional Status Transfer to Fin. Accounting (Res. RFBSK) DOCSTAT_KK CHAR 1 0
A Accounting Document Generated in FI
B Accounting Document 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
1 FI-CA-Inv.: Invoicing Order Created
2 FI-CA-Inv.: Invoicing Document Created
3 FI-CA-Inv.: Invoicing Order Cancelled
G Billing Block IDoc Processing
NRZAS Character Field of Length 12 CHAR12 CHAR 12 0
SPE_BILLING_IND EWM Billing Indicator /SPE/DE_BILLING_IND CHAR 1 0
NULL No Invoice Before Goods Issue
A Direct Billing (Immediately Billing and Printing)
B Wait for Billing Request
VTREF Reference Specifications from Contract CORR_VTREF_KK CHAR 20 0
FK_SOURCE_SYS Source System FK_SOURCE_SYS CHAR 10 0
FKTYP_CRM Billing Category in CRM FKTYP_CRM CHAR 1 0
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
U Billing request
W POS billing document
X Billing using general interface
S CRM Billing Document
N Provisional or Differential Billing Document
O Final Billing Document
STGRD Reason for Reversal STGRD CHAR 2 0
VBTYP_EXT Extension of SD Document Category TDD_VBTYP_EXT CHAR 4 0
f001 Period-End Invoice
f002 Period-End Credit Memo
f003 Period-End Invoice (Intercompany Billing)
f004 Period-End Credit Memo (Intercompany Billing)
DPC_REL Flag: DPC relevant /SAPPCE/DPC_REL CHAR 1 0
OICHEADOFF Head office account number (in branch accounts) KNRZE CHAR 10 0
OIC_INPD Invoice pricing date rule OIC_INPD CHAR 1 0
NULL Ref Sales Order (VBKD-PRSDT VBKD-OIC_TIME)
1 Invoice Creation (SY-UZEIT SY-DATUM at Inv Creatn)
2 Delivery (LIKP-LFDAT LIKP-LFUHR)
3 Actual Goods Issue (LIKP-WADAT_IST LIKP-OIWATIM)
4 Loading (LIKP-LDDAT LIKP-OILDTIM)
5 Planned Goods Issue (LIKP-WADAT LIKP-WAUHR)
OINETCYC Netting cycle (FI blocking indicator) OIA_NETCYC CHAR 1 0
OIEXGNUM Exchange agreement number OIA_EXGNUM CHAR 10 0
OIEXGTYP Exchange type OIA_EXGTYP CHAR 4 0
OIFEEPD Fee pricing date OIA_FEEPD CHAR 1 0
NULL Ref Sales Order (VBKD-PRSDT VBKD-OIC_TIME)
1 Invoice Creation (SY-UZEIT SY-DATUM at Inv Creatn)
2 Delivery (LIKP-LFDAT LIKP-LFUHR)
3 Actual Goods Issue (LIKP-WADAT_IST LIKP-OIWATIM)
4 Loading (LIKP-LDDAT LIKP-OILDTIM)
5 Planned Goods Issue (LIKP-WADAT LIKP-WAUHR)
OIRIINVDOC SSR invoicing - invoicing document type OIRI_INVDOC CHAR 3 0
OIRIPBLNR Business location identifier (IS-Oil MRN) OIF_PBLNR CHAR 10 0
OIRICOMMCAL Calendar for monthly commission recalculation OIRI_COMMCAL CHAR 2 0
OIRIDCLAIM Daily claim document OIRI_DCLAIM CHAR 1 0
NULL Not a daily claim document
A Non fleet (Cash/Credit card daily claim document
B Fleet card daily claim document
OIRIPCTOT Payment card total OIRI_PCTOT CURR 15 2
OIRICHIND Clearing house document indicator OIRI_CHIND CHAR 1 0
OIRMATHANDGRP Material handling group (IS-Oil SSR) OIRA_MATHANDGRP CHAR 2 0
OIR_CHOBJ SSR PC: Clearing house OIRE_CHOBJ CHAR 6 0
OICSDPORGINV Original billing document OIC_VBELN_ORG CHAR 10 0
OICSDPVERNO Version number sequence OIC_SDP_DVERNO CHAR 2 0
OIU_DN_NO CHAR 20 0
OIU_WL_NO CHAR 15 0
OIU_WC_NO CHAR 5 0
OIU_MP_NO CHAR 20 0
OIU_MAJPD_CD CHAR 1 0
OIU_VNAME CHAR 6 0
OIU_DOI_NO CHAR 5 0
OIU_VBELN CHAR 10 0
OIU_PPA_RSN_CD CHAR 2 0
OIU_PRCS_DT DATS 8 0
OIU_FREQ_CD CHAR 1 0
MNDID Unique Referene to Mandate per Payment Recipient SEPA_MNDID CHAR 35 0
PAY_TYPE SEPA: Transaction Type SEPA_PAY_TYPE CHAR 1 0
1 One-Time Mandate
N Recurring Use Mandate
SEPON SEPA-Relevance SD_SEPA_FLAG CHAR 1 0
NULL No SEPA Relevance
0 SEPA Relevance - No Mandate Assigned
1 SEPA Relevance - Mandate Assigned
MNDVG SEPA-Relevance SD_SEPA_FLAG CHAR 1 0
NULL No SEPA Relevance
0 SEPA Relevance - No Mandate Assigned
1 SEPA Relevance - Mandate Assigned
SPPAYM Payment Form for Special Payment Method SPPAYM CHAR 2 0
01 Payment Service Provider
SPPORD Sales Order for Special Payment Method SPPORD CHAR 10 0
T_VBRP TAB_VBRP TTYP 0 0
T_VBPA TAB_VBPA TTYP 0 0
T_KONV TAB_KONV TTYP 0 0
T_WCOCOF TAB_WCOCOF TTYP 0 0