SAP ABAP Table WCB_ALL_BILL_DATA (WCB: Data for a Sales Invoice)
Hierarchy
☛
EA-GLTRADE (Software Component) SAP Enterprise Extension Global Trade
⤷ LO-GT-CHB (Application Component) Chargeback
⤷ WCB_AG_APPL (Package) Agency Document Creation Application Logic
⤷ LO-GT-CHB (Application Component) Chargeback
⤷ WCB_AG_APPL (Package) Agency Document Creation Application Logic
Basic Data
Table Category | INTTAB | Structure |
Structure | WCB_ALL_BILL_DATA | Table Relationship Diagram |
Short Description | WCB: Data for a Sales Invoice |
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 | VBELN | VBELN_VF | VBELN | CHAR | 10 | 0 | Billing document | * | |
2 | VBRK | VBRK | STRU | 0 | 0 | ||||
3 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | ||
4 | VBELN | VBELN_VF | VBELN | CHAR | 10 | 0 | Billing document | ||
5 | FKART | FKART | FKART | CHAR | 4 | 0 | Billing Type | ||
6 | FKTYP | FKTYP | FKTYP | CHAR | 1 | 0 | Billing Category | ||
7 | VBTYP | VBTYP | VBTYP | CHAR | 1 | 0 | SD document category | ||
8 | WAERK | WAERK | WAERS | CUKY | 5 | 0 | SD document currency | ||
9 | VKORG | VKORG | VKORG | CHAR | 4 | 0 | Sales Organization | ||
10 | VTWEG | VTWEG | VTWEG | CHAR | 2 | 0 | Distribution Channel | ||
11 | KALSM | KALSMASD | KALSM | CHAR | 6 | 0 | Sales and Distribution: Pricing Procedure in Pricing | ||
12 | KNUMV | KNUMV | KNUMV | CHAR | 10 | 0 | Number of the document condition | ||
13 | VSBED | VSBED | VSBED | CHAR | 2 | 0 | Shipping conditions | ||
14 | FKDAT | FKDAT | DATUM | DATS | 8 | 0 | Billing date for billing index and printout | ||
15 | BELNR | BELNR_D | BELNR | CHAR | 10 | 0 | Accounting Document Number | ||
16 | GJAHR | GJAHR | GJAHR | NUMC | 4 | 0 | Fiscal Year | ||
17 | POPER | POPER | POPER | NUMC | 3 | 0 | Posting period | ||
18 | KONDA | KONDA | KONDA | CHAR | 2 | 0 | Price Group (Customer) | ||
19 | KDGRP | KDGRP | KDGRP | CHAR | 2 | 0 | Customer group | ||
20 | BZIRK | BZIRK | BZIRK | CHAR | 6 | 0 | Sales district | ||
21 | PLTYP | PLTYP | PLTYP | CHAR | 2 | 0 | Price list type | ||
22 | INCO1 | INCO1 | INCO1 | CHAR | 3 | 0 | Incoterms (part 1) | ||
23 | INCO2 | INCO2 | INCO2 | CHAR | 28 | 0 | Incoterms (part 2) | ||
24 | EXPKZ | EXPKZ | EXPKZ | CHAR | 1 | 0 | Export indicator | ||
25 | RFBSK | RFBSK | RFBSK | CHAR | 1 | 0 | Status for transfer to accounting | ||
26 | MRNKZ | MRNKZ | XFELD | CHAR | 1 | 0 | Manual invoice maintenance | ||
27 | KURRF | KURRF | KURRF | DEC | 9 | 5 | Exchange rate for FI postings | ||
28 | CPKUR | CPKUR | CPKUR | CHAR | 1 | 0 | ID:Exchange rate setting (no new rate determ.in bill.doc.) | ||
29 | VALTG | VALTG | TAGE2 | NUMC | 2 | 0 | Additional value days | ||
30 | VALDT | VALDT | DATUM | DATS | 8 | 0 | Fixed value date | ||
31 | ZTERM | DZTERM | ZTERM | CHAR | 4 | 0 | Terms of payment key | ||
32 | ZLSCH | SCHZW_BSEG | ZLSCH | CHAR | 1 | 0 | Payment Method | ||
33 | KTGRD | KTGRD | KTGRD | CHAR | 2 | 0 | Account assignment group for this customer | ||
34 | LAND1 | LLAND | LAND1 | CHAR | 3 | 0 | Destination Country | ||
35 | REGIO | REGIO | REGIO | CHAR | 3 | 0 | Region (State, Province, County) | ||
36 | COUNC | COUNC | COUNC | CHAR | 3 | 0 | County Code | ||
37 | CITYC | CITYC | CITYC | CHAR | 4 | 0 | City Code | ||
38 | BUKRS | BUKRS | BUKRS | CHAR | 4 | 0 | Company Code | ||
39 | TAXK1 | TAXK1 | TAXKD | CHAR | 1 | 0 | Tax classification 1 for customer | ||
40 | TAXK2 | TAXK2 | TAXKD | CHAR | 1 | 0 | Tax classification 2 for customer | ||
41 | TAXK3 | TAXK3 | TAXKD | CHAR | 1 | 0 | Tax classification 3 for customer | ||
42 | TAXK4 | TAXK4 | TAXKD | CHAR | 1 | 0 | Tax classification 4 for customer | ||
43 | TAXK5 | TAXK5 | TAXKD | CHAR | 1 | 0 | Tax classification 5 for customer | ||
44 | TAXK6 | TAXK6 | TAXKD | CHAR | 1 | 0 | Tax classification 6 for customer | ||
45 | TAXK7 | TAXK7 | TAXKD | CHAR | 1 | 0 | Tax classification 7 for customer | ||
46 | TAXK8 | TAXK8 | TAXKD | CHAR | 1 | 0 | Tax classification 8 for customer | ||
47 | TAXK9 | TAXK9 | TAXKD | CHAR | 1 | 0 | Tax classification 9 for customer | ||
48 | NETWR | NETWR | WERTV8 | CURR | 15 | 2 | Net Value in Document Currency | ||
49 | ZUKRI | DZUKRI | CHAR40 | CHAR | 40 | 0 | Combination criteria in the billing document | ||
50 | ERNAM | ERNAM | USNAM | CHAR | 12 | 0 | Name of Person who Created the Object | ||
51 | ERZET | ERZET | UZEIT | TIMS | 6 | 0 | Entry time | ||
52 | ERDAT | ERDAT | DATUM | DATS | 8 | 0 | Date on which the record was created | ||
53 | STAFO | STAFO | STAFO | CHAR | 6 | 0 | Update group for statistics update | ||
54 | KUNRG | KUNRG | KUNNR | CHAR | 10 | 0 | Payer | ||
55 | KUNAG | KUNAG | KUNNR | CHAR | 10 | 0 | Sold-to party | ||
56 | MABER | MABER | MABER | CHAR | 2 | 0 | Dunning Area | ||
57 | STWAE | STWAE | WAERS | CUKY | 5 | 0 | Statistics currency | ||
58 | EXNUM | EXNUM | EXNUM | CHAR | 10 | 0 | Number of foreign trade data in MM and SD documents | ||
59 | STCEG | STCEG | STCEG | CHAR | 20 | 0 | VAT Registration Number | ||
60 | AEDAT | AEDAT | DATUM | DATS | 8 | 0 | Last Changed On | ||
61 | SFAKN | SFAKN | VBELN | CHAR | 10 | 0 | Cancelled billing document number | ||
62 | KNUMA | KNUMA | KNUMA | CHAR | 10 | 0 | Agreement (various conditions grouped together) | ||
63 | FKART_RL | FKART_RL | FKART | CHAR | 4 | 0 | Invoice list type | ||
64 | FKDAT_RL | FKDAT_RL | DATUM | DATS | 8 | 0 | Billing date for the invoice list | ||
65 | KURST | KURST | KURST | CHAR | 4 | 0 | Exchange Rate Type | ||
66 | MSCHL | MSCHL | MSCHL | CHAR | 1 | 0 | Dunning key | ||
67 | MANSP | MANSP | MANSP | CHAR | 1 | 0 | Dunning block | ||
68 | SPART | SPART | SPART | CHAR | 2 | 0 | Division | ||
69 | KKBER | KKBER | KKBER | CHAR | 4 | 0 | Credit control area | ||
70 | KNKLI | KNKLI | KUNNR | CHAR | 10 | 0 | Customer's account number with credit limit reference | ||
71 | CMWAE | WAERS_CM | WAERS | CUKY | 5 | 0 | Currency key of credit control area | ||
72 | CMKUF | CMKUF | KURRF | DEC | 9 | 5 | Credit data exchange rate at billing document rate | ||
73 | HITYP_PR | HITYP_PR | HITYP | CHAR | 1 | 0 | Hierarchy type for pricing | ||
74 | BSTNK_VF | BSTKD | BSTKD | CHAR | 35 | 0 | Customer purchase order number | ||
75 | VBUND | RASSC | RCOMP | CHAR | 6 | 0 | Company ID of trading partner | ||
76 | FKART_AB | FKART_AB | FKART | CHAR | 4 | 0 | Accrual billing type | ||
77 | KAPPL | KAPPL | KAPPL | CHAR | 2 | 0 | Application | ||
78 | LANDTX | LANDTX | LAND1 | CHAR | 3 | 0 | Tax Departure Country | ||
79 | STCEG_H | STCEG_H | STCEG_H | CHAR | 1 | 0 | Origin of sales tax ID number | ||
80 | STCEG_L | STCEG_L | LAND1 | CHAR | 3 | 0 | Country of sales tax ID number | ||
81 | XBLNR | XBLNR_V1 | XBLNR1 | CHAR | 16 | 0 | Reference Document Number | ||
82 | ZUONR | ORDNR_V | ZUONR | CHAR | 18 | 0 | Assignment Number | ||
83 | MWSBK | MWSBP | WERTV7 | CURR | 13 | 2 | Tax amount in document currency | ||
84 | LOGSYS | LOGSYS | LOGSYS | CHAR | 10 | 0 | Logical system | ||
85 | FKSTO | FKSTO | XFELD | CHAR | 1 | 0 | Billing document is cancelled | ||
86 | XEGDR | XEGDR | XFELD | CHAR | 1 | 0 | Indicator: Triangular deal within the EU ? | ||
87 | RPLNR | RPLNR | FPLNR | CHAR | 10 | 0 | Installment Plan Number | ||
88 | LCNUM | LCNUM | LCNUM | CHAR | 10 | 0 | Financial doc. processing: Internal financial doc. number | ||
89 | J_1AFITP | J_1AFITP_D | J_1AFITP | CHAR | 2 | 0 | Tax type | ||
90 | KURRF_DAT | WWERT_D | DATUM | DATS | 8 | 0 | Translation date | ||
91 | AKWAE | AKWAE | WAERS | CUKY | 5 | 0 | Currency key for letter-of-credit procg in foreign trade | ||
92 | AKKUR | AKKUR | KURRF | DEC | 9 | 5 | Exchange rate for letter-of-credit procg in foreign trade | ||
93 | KIDNO | KIDNO | CHAR30 | CHAR | 30 | 0 | Payment Reference | ||
94 | BVTYP | BVTYP | BVTYP | CHAR | 4 | 0 | Partner bank type | ||
95 | NUMPG | J_1ANOPG | J_1ANOPG | NUMC | 3 | 0 | Number of pages of invoice | ||
96 | BUPLA | BUPLA | J_1BBRANCH | CHAR | 4 | 0 | Business Place | ||
97 | VKONT | CORR_VKONT_KK | CORR_VKONT_KK | CHAR | 12 | 0 | Contract Account Number | ||
98 | FKK_DOCSTAT | DOCSTAT_KK | DOCSTAT_KK | CHAR | 1 | 0 | Additional Status Transfer to Fin. Accounting (Res. RFBSK) | ||
99 | NRZAS | CHAR12 | CHAR12 | CHAR | 12 | 0 | Character Field of Length 12 | ||
100 | SPE_BILLING_IND | /SPE/DE_BILLING_IND | /SPE/DE_BILLING_IND | CHAR | 1 | 0 | EWM Billing Indicator | ||
101 | VTREF | CORR_VTREF_KK | CORR_VTREF_KK | CHAR | 20 | 0 | Reference Specifications from Contract | ||
102 | FK_SOURCE_SYS | FK_SOURCE_SYS | LOGSYS | CHAR | 10 | 0 | Source System | ||
103 | FKTYP_CRM | FKTYP_CRM | FKTYP | CHAR | 1 | 0 | Billing Category in CRM | ||
104 | STGRD | STGRD | STGRD | CHAR | 2 | 0 | Reason for Reversal | ||
105 | VBTYP_EXT | TDD_VBTYP_EXT | DOM_VBTYP_EXT | CHAR | 4 | 0 | Extension of SD Document Category | ||
106 | .INCLU--AP | 0 | 0 | VBRK append for Down Payment Chain | |||||
107 | DPC_REL | /SAPPCE/DPC_REL | CHAR01 | CHAR | 1 | 0 | Flag: DPC relevant | ||
108 | .INCLU--AP | 0 | 0 | VBRK_SEPA | |||||
109 | .INCLUDE | 0 | 0 | SEPA SD Struktur | |||||
110 | MNDID | SEPA_MNDID | ID035 | CHAR | 35 | 0 | Unique Referene to Mandate per Payment Recipient | ||
111 | PAY_TYPE | SEPA_PAY_TYPE | SEPA_PAY_TYPE | CHAR | 1 | 0 | SEPA: Payment Type | ||
112 | SEPON | SD_SEPA_FLAG | SD_SEPA_FLAG | CHAR | 1 | 0 | SEPA-Relevance | ||
113 | MNDVG | SD_SEPA_FLAG | SD_SEPA_FLAG | CHAR | 1 | 0 | SEPA-Relevance | ||
114 | .INCLU--AP | 0 | 0 | Append Structure for Special Paymenents | |||||
115 | SPPAYM | SPPAYM | SPPAYM | CHAR | 2 | 0 | Payment Form for Special Payment Method | ||
116 | SPPORD | SPPORD | VBELN | CHAR | 10 | 0 | Sales Order for Special Payment Method | ||
117 | T_VBRP | TAB_VBRP | TTYP | 0 | 0 | ||||
118 | T_VBPA | TAB_VBPA | TTYP | 0 | 0 | ||||
119 | T_KONV | TAB_KONV | TTYP | 0 | 0 | ||||
120 | T_WCOCOF | TAB_WCOCOF | TTYP | 0 | 0 |
History
Last changed by/on | SAP | 20131127 |
SAP Release Created in | 600 |