WCB_ALL_BILL_DATA SAP (WCB: Data for a Sales Invoice) Structure details
Description: WCB: Data for a Sales Invoice
Related tables to WCB_ALL_BILL_DATA
Access table WCB_ALL_BILL_DATA
Structure field list including key, data, relationships and ABAP select examples
WCB_ALL_BILL_DATA is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "WCB: Data for a Sales Invoice" Information within sap ABAP programs.
This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.
i.e. DATA: wa_WCB_ALL_BILL_DATA TYPE WCB_ALL_BILL_DATA.
The WCB_ALL_BILL_DATA table consists of various fields, each holding specific information or linking keys about WCB: Data for a Sales Invoice data available in SAP. These include VBRK (), MANDT (Client), VBELN (Billing Document), FKART (Billing Type).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class:Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can Be Enhanced (Deep)
SAP WCB_ALL_BILL_DATA structure fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
VBELN | Billing Document | VBELN_VF | CHAR | 10 | Assigned to domain | ALPHA | VBELN | VF | |
VBRK | 0 | ||||||||
MANDT | Client | MANDT | CLNT | 3 | MANDT | ||||
VBELN | Billing Document | VBELN_VF | CHAR | 10 | ALPHA | VBELN | VF | ||
FKART | Billing Type | FKART | CHAR | 4 | FKART | ||||
FKTYP | Billing category | FKTYP | CHAR | 1 | FKTYP | ||||
VBTYP | SD document category | VBTYP | CHAR | 1 | VBTYP | ||||
WAERK | SD Document Currency | WAERK | CUKY | 5 | WAERS | FWS | |||
VKORG | Sales Organization | VKORG | CHAR | 4 | VKORG | VKO | C_VKORG | ||
VTWEG | Distribution Channel | VTWEG | CHAR | 2 | VTWEG | VTW | C_VTWEG | ||
KALSM | Sales and Distribution: Pricing Procedure in Pricing | KALSMASD | CHAR | 6 | KALSM | ||||
KNUMV | Number of the document condition | KNUMV | CHAR | 10 | KNUMV | ||||
VSBED | Shipping Conditions | VSBED | CHAR | 2 | VSBED | ||||
FKDAT | Billing date for billing index and printout | FKDAT | DATS | 8 | DATUM | ||||
BELNR | Accounting Document Number | BELNR_D | CHAR | 10 | ALPHA | BELNR | BLN | ||
GJAHR | Fiscal Year | GJAHR | NUMC | 4 | GJAHR | GJAHR | GJR | ||
POPER | Posting period | POPER | NUMC | 3 | POPER | POPR | |||
KONDA | Price group (customer) | KONDA | CHAR | 2 | KONDA | VKA | |||
KDGRP | Customer group | KDGRP | CHAR | 2 | KDGRP | VKD | |||
BZIRK | Sales district | BZIRK | CHAR | 6 | BZIRK | BZI | |||
PLTYP | Price list type | PLTYP | CHAR | 2 | PLTYP | VPL | |||
INCO1 | Incoterms (Part 1) | INCO1 | CHAR | 3 | INCO1 | ||||
INCO2 | Incoterms (Part 2) | INCO2 | CHAR | 28 | INCO2 | ||||
EXPKZ | Export indicator | EXPKZ | CHAR | 1 | EXPKZ | ||||
RFBSK | Status for transfer to accounting | RFBSK | CHAR | 1 | RFBSK | ||||
MRNKZ | Manual invoice maintenance | MRNKZ | CHAR | 1 | XFELD | ||||
KURRF | Exchange rate for FI postings | KURRF | DEC | 9(5) | KURRF | ||||
CPKUR | ID:Exchange rate setting (no new rate determ.in bill.doc.) | CPKUR | CHAR | 1 | CPKUR | ||||
VALTG | Additional value days | VALTG | NUMC | 2 | TAGE2 | ||||
VALDT | Fixed value date | VALDT | DATS | 8 | DATUM | ||||
ZTERM | Terms of Payment Key | DZTERM | CHAR | 4 | ZTERM | ||||
ZLSCH | Payment Method | SCHZW_BSEG | CHAR | 1 | ZLSCH | ||||
KTGRD | Account assignment group for this customer | KTGRD | CHAR | 2 | KTGRD | ||||
LAND1 | Country of Destination | LLAND | CHAR | 3 | LAND1 | VLL | |||
REGIO | STATE (State, Province, County) | REGIO | CHAR | 3 | REGIO | ||||
COUNC | County Code | COUNC | CHAR | 3 | COUNC | ||||
CITYC | City Code | CITYC | CHAR | 4 | CITYC | ||||
BUKRS | Company Code | BUKRS | CHAR | 4 | BUKRS | BUK | C_T001 | ||
TAXK1 | Tax classification 1 for customer | TAXK1 | CHAR | 1 | TAXKD | ||||
TAXK2 | Tax classification 2 for customer | TAXK2 | CHAR | 1 | TAXKD | ||||
TAXK3 | Tax classification 3 for customer | TAXK3 | CHAR | 1 | TAXKD | ||||
TAXK4 | Tax Classification 4 Customer | TAXK4 | CHAR | 1 | TAXKD | ||||
TAXK5 | Tax classification 5 for customer | TAXK5 | CHAR | 1 | TAXKD | ||||
TAXK6 | Tax classification 6 for customer | TAXK6 | CHAR | 1 | TAXKD | ||||
TAXK7 | Tax classification 7 for customer | TAXK7 | CHAR | 1 | TAXKD | ||||
TAXK8 | Tax classification 8 for customer | TAXK8 | CHAR | 1 | TAXKD | ||||
TAXK9 | Tax classification 9 for customer | TAXK9 | CHAR | 1 | TAXKD | ||||
NETWR | Net Value in Document Currency | NETWR | CURR | 15(2) | WERTV8 | ||||
ZUKRI | Combination criteria in the billing document | DZUKRI | CHAR | 40 | CHAR40 | ||||
ERNAM | Name of Person who Created the Object | ERNAM | CHAR | 12 | USNAM | ||||
ERZET | Entry time | ERZET | TIMS | 6 | UZEIT | ||||
ERDAT | Date on Which Record Was Created | ERDAT | DATS | 8 | DATUM | ||||
STAFO | Update group for statistics update | STAFO | CHAR | 6 | ALPHA | STAFO | MCF | ||
KUNRG | Payer | KUNRG | CHAR | 10 | ALPHA | KUNNR | |||
KUNAG | Sold-to party | KUNAG | CHAR | 10 | ALPHA | KUNNR | VAG | ||
MABER | Dunning Area | MABER | CHAR | 2 | MABER | ||||
STWAE | Statistics currency | STWAE | CUKY | 5 | WAERS | ||||
EXNUM | Number of foreign trade data in MM and SD documents | EXNUM | CHAR | 10 | EXNUM | ||||
STCEG | VAT Registration Number | STCEG | CHAR | 20 | STCEG | ||||
AEDAT | Changed On | AEDAT | DATS | 8 | DATUM | ||||
SFAKN | Cancelled billing document number | SFAKN | CHAR | 10 | ALPHA | VBELN | VF | ||
KNUMA | Agreement (various conditions grouped together) | KNUMA | CHAR | 10 | ALPHA | KNUMA | VMBO | ||
FKART_RL | Invoice list type | FKART_RL | CHAR | 4 | FKART | ||||
FKDAT_RL | Billing date for the invoice list | FKDAT_RL | DATS | 8 | DATUM | ||||
KURST | Exchange Rate Type | KURST | CHAR | 4 | KURST | KUT | |||
MSCHL | Dunning key | MSCHL | CHAR | 1 | MSCHL | ||||
MANSP | Dunning block | MANSP | CHAR | 1 | MANSP | ||||
SPART | Division | SPART | CHAR | 2 | SPART | SPA | C_SPART | ||
KKBER | Credit control area | KKBER | CHAR | 4 | KKBER | KKB | |||
KNKLI | Customer's account number with credit limit reference | KNKLI | CHAR | 10 | ALPHA | KUNNR | |||
CMWAE | Currency key of credit control area | WAERS_CM | CUKY | 5 | WAERS | ||||
CMKUF | Credit data exchange rate at billing document rate | CMKUF | DEC | 9(5) | KURRF | ||||
HITYP_PR | Hierarchy type for pricing | HITYP_PR | CHAR | 1 | HITYP | ||||
BSTNK_VF | Customer purchase order number | BSTKD | CHAR | 35 | BSTKD | ||||
VBUND | Company ID of trading partner | RASSC | CHAR | 6 | ALPHA | RCOMP | PGS | ||
FKART_AB | Accrual billing type | FKART_AB | CHAR | 4 | FKART | ||||
KAPPL | Application | KAPPL | CHAR | 2 | KAPPL | KAP | |||
LANDTX | Tax departure country | LANDTX | CHAR | 3 | LAND1 | LND | |||
STCEG_H | Origin of sales tax ID number | STCEG_H | CHAR | 1 | STCEG_H | ||||
STCEG_L | Country of Sales Tax ID Number | STCEG_L | CHAR | 3 | LAND1 | LND | |||
XBLNR | Reference Document Number | XBLNR_V1 | CHAR | 16 | XBLNR1 | ||||
ZUONR | Assignment number | ORDNR_V | CHAR | 18 | ZUONR | ||||
MWSBK | Tax amount in document currency | MWSBP | CURR | 13(2) | WERTV7 | ||||
LOGSYS | Logical system | LOGSYS | CHAR | 10 | ALPHA | LOGSYS | |||
FKSTO | Billing document is cancelled | FKSTO | CHAR | 1 | XFELD | ||||
XEGDR | Indicator: Triangular deal within the EU ? | XEGDR | CHAR | 1 | XFELD | ||||
RPLNR | Number of payment card plan type | RPLNR | CHAR | 10 | FPLNR | ||||
LCNUM | Financial doc. processing: Internal financial doc. number | LCNUM | CHAR | 10 | ALPHA | LCNUM | AKN | ||
J_1AFITP | Tax type | J_1AFITP_D | CHAR | 2 | J_1AFITP | ||||
KURRF_DAT | Translation Date | WWERT_D | DATS | 8 | DATUM | ||||
AKWAE | Currency key for letter-of-credit procg in foreign trade | AKWAE | CUKY | 5 | WAERS | FWS | |||
AKKUR | Exchange rate for letter-of-credit procg in foreign trade | AKKUR | DEC | 9(5) | KURRF | ||||
KIDNO | Payment Reference | KIDNO | CHAR | 30 | CHAR30 | ||||
BVTYP | Partner Bank Type | BVTYP | CHAR | 4 | BVTYP | ||||
NUMPG | Number of pages of invoice | J_1ANOPG | NUMC | 3 | J_1ANOPG | ||||
BUPLA | Business Place | BUPLA | CHAR | 4 | J_1BBRANCH | ||||
VKONT | Contract Account Number | CORR_VKONT_KK | CHAR | 12 | ALPHA | CORR_VKONT_KK | |||
FKK_DOCSTAT | Additional Status Transfer to Fin. Accounting (Res. RFBSK) | DOCSTAT_KK | CHAR | 1 | DOCSTAT_KK | ||||
NRZAS | Character Field of Length 12 | CHAR12 | CHAR | 12 | CHAR12 | ||||
SPE_BILLING_IND | EWM Billing Indicator | /SPE/DE_BILLING_IND | CHAR | 1 | /SPE/DE_BILLING_IND | ||||
VTREF | Reference Specifications from Contract | CORR_VTREF_KK | CHAR | 20 | ALPHA | CORR_VTREF_KK | |||
FK_SOURCE_SYS | Source System | FK_SOURCE_SYS | CHAR | 10 | ALPHA | LOGSYS | |||
FKTYP_CRM | Billing Category in CRM | FKTYP_CRM | CHAR | 1 | FKTYP | ||||
STGRD | Reason for Reversal | STGRD | CHAR | 2 | STGRD | FSG | |||
VBTYP_EXT | Extension of SD Document Category | TDD_VBTYP_EXT | CHAR | 4 | DOM_VBTYP_EXT | ||||
.INCLU--AP | 0 | ||||||||
DPC_REL | Flag: DPC relevant | /SAPPCE/DPC_REL | CHAR | 1 | CHAR01 | ||||
.INCLU--AP | 0 | ||||||||
AD01BASDOC | Initial document | AD01BASDOC | CHAR | 10 | ALPHA | VBELN | |||
AD01FAREG | Rule for billing | AD01FAREG | CHAR | 1 | AD01FAREG | ||||
.INCLU--AP | 0 | ||||||||
VCHRNMBR | Voucher Number | AD04VCHNR | NUMC | 8 | AD04VCHNR | ||||
.INCLU--AP | 0 | ||||||||
SWENR | Business Entity Number | HB_SWENR | CHAR | 8 | SWENR | SWENR | WEH | ||
SMENR | Number of Sales Unit | HB_SMENR | CHAR | 8 | SMENR | SMENR | MEH | ||
PHASE | Sales Phase | HB_SPHSE | CHAR | 11 | HBS_PHASE | ||||
MTLAUR | Marker for Low Income Housing | HB_MTLAUR | CHAR | 1 | HBS_MTLAUR | ||||
STAGE | Construction Stage | HB_STAGE | INT4 | 10 | INT4 | ||||
HB_CONT_REASON | Contingency data | HB_CONT | CHAR | 2 | CHAR2 | ||||
HB_EXPDATE | Expiration date | HB_EXP | DATS | 8 | DATS | ||||
HB_RESDATE | Resolution date | HB_RES | DATS | 8 | DATS | ||||
.INCLU--AP | 0 | ||||||||
J_3GKBAUL | ETM-Relevant Indicator | J_3GKBAUL | CHAR | 1 | J_3GKBAUL | ||||
J_3GKENIE | Indicator for I(nternal) or E(xternal) Posting | J_3GKENIE | CHAR | 1 | J_3GKENIE | ||||
KUNWE | Ship-to party | KUNWE | CHAR | 10 | ALPHA | KUNNR | |||
.INCLU--AP | 0 | ||||||||
MNDID | Unique Referene to Mandate per Payment Recipient | SEPA_MNDID | CHAR | 35 | ID035 | ||||
PAY_TYPE | SEPA: Transaction Type | SEPA_PAY_TYPE | CHAR | 1 | SEPA_PAY_TYPE | ||||
SEPON | SEPA-Relevance | SD_SEPA_FLAG | CHAR | 1 | SD_SEPA_FLAG | ||||
MNDVG | SEPA-Relevance | SD_SEPA_FLAG | CHAR | 1 | SD_SEPA_FLAG | ||||
.INCLU--AP | 0 | ||||||||
SPPAYM | Payment Form for Special Payment Method | SPPAYM | CHAR | 2 | SPPAYM | ||||
SPPORD | Sales Order for Special Payment Method | SPPORD | CHAR | 10 | ALPHA | VBELN | |||
.INCLU--AP | 0 | ||||||||
T_VBRP | 0 | ||||||||
T_VBPA | 0 | ||||||||
T_KONV | 0 | ||||||||
T_WCOCOF | 0 |
Key field | Non-key field |
How do I retrieve data from SAP structure WCB_ALL_BILL_DATA using ABAP code?
As WCB_ALL_BILL_DATA is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on WCB_ALL_BILL_DATA as there is no data to select.How to access SAP table WCB_ALL_BILL_DATA
Within an ECC or HANA version of SAP you can also view further information about WCB_ALL_BILL_DATA and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects