SAP ABAP Table BAPICMS_VBRK (CMS BAPI str for Billing Header data from R/3)
Hierarchy
☛
SAP_APPL (Software Component) Logistics and Accounting
⤷ SD (Application Component) Sales and Distribution
⤷ CRM_CMS_BILL_CAP_RI (Package) Rel Ind CMS plugin package to capture billing data
⤷ SD (Application Component) Sales and Distribution
⤷ CRM_CMS_BILL_CAP_RI (Package) Rel Ind CMS plugin package to capture billing data
Basic Data
Table Category | INTTAB | Structure |
Structure | BAPICMS_VBRK | Table Relationship Diagram |
Short Description | CMS BAPI str for Billing Header data from R/3 |
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 | OPERATION | MSGFN | MSGFN | CHAR | 3 | 0 | Function | ||
2 | BILL_DOC | VBELN_VF | VBELN | CHAR | 10 | 0 | Billing document | * | |
3 | BILL_TYPE | FKART | FKART | CHAR | 4 | 0 | Billing Type | * | |
4 | BILL_CAT | FKTYP | FKTYP | CHAR | 1 | 0 | Billing Category | ||
5 | SD_DOC_CAT | VBTYP | VBTYP | CHAR | 1 | 0 | SD document category | ||
6 | CURRENCY | WAERK | WAERS | CUKY | 5 | 0 | SD document currency | * | |
7 | CURRENCY_ISO | WAERS_ISO | ISOCD | CHAR | 3 | 0 | ISO code currency | ||
8 | SALESORG | VKORG | VKORG | CHAR | 4 | 0 | Sales Organization | * | |
9 | DISTR_CHAN | VTWEG | VTWEG | CHAR | 2 | 0 | Distribution Channel | * | |
10 | SD_PRICE_PROD | KALSMASD | KALSM | CHAR | 6 | 0 | Sales and Distribution: Pricing Procedure in Pricing | * | |
11 | NO_DOC_COND | KNUMV | KNUMV | CHAR | 10 | 0 | Number of the document condition | ||
12 | SHIP_COND | VSBED | VSBED | CHAR | 2 | 0 | Shipping conditions | * | |
13 | BILL_DATE | FKDAT | DATUM | DATS | 8 | 0 | Billing date for billing index and printout | ||
14 | AC_DOC_NO | BELNR_D | BELNR | CHAR | 10 | 0 | Accounting Document Number | ||
15 | FISC_YEAR | GJAHR | GJAHR | NUMC | 4 | 0 | Fiscal Year | ||
16 | POSTING_PERIOD | POPER | POPER | NUMC | 3 | 0 | Posting period | ||
17 | PRICE_GRP | KONDA | KONDA | CHAR | 2 | 0 | Price Group (Customer) | * | |
18 | CUST_GROUP | KDGRP | KDGRP | CHAR | 2 | 0 | Customer group | * | |
19 | SALES_DIST | BZIRK | BZIRK | CHAR | 6 | 0 | Sales district | * | |
20 | PRICE_LIST | PLTYP | PLTYP | CHAR | 2 | 0 | Price list type | * | |
21 | INCOTERMS1 | INCO1 | INCO1 | CHAR | 3 | 0 | Incoterms (part 1) | * | |
22 | INCOTERMS2 | INCO2 | INCO2 | CHAR | 28 | 0 | Incoterms (part 2) | ||
23 | EXP_IND | EXPKZ | EXPKZ | CHAR | 1 | 0 | Export indicator | ||
24 | STAT_ACC_TRAN | RFBSK | RFBSK | CHAR | 1 | 0 | Status for transfer to accounting | ||
25 | MN_INVOICE | MRNKZ | XFELD | CHAR | 1 | 0 | Manual invoice maintenance | ||
26 | EX_RATE_FI_POS | KURRF | KURRF | DEC | 9 | 5 | Exchange rate for FI postings | ||
27 | EX_RATE_SET | CPKUR | CPKUR | CHAR | 1 | 0 | ID:Exchange rate setting (no new rate determ.in bill.doc.) | ||
28 | ADD_VAL_DY | VALTG | TAGE2 | NUMC | 2 | 0 | Additional value days | ||
29 | FIX_VAL_DY | VALDT | DATUM | DATS | 8 | 0 | Fixed value date | ||
30 | PMNTTRMS | CHAR | 4 | 0 | |||||
31 | PAY_METHOD | SCHZW_BSEG | ZLSCH | CHAR | 1 | 0 | Payment Method | * | |
32 | ACCNT_ASGN | KTGRD | KTGRD | CHAR | 2 | 0 | Account assignment group for this customer | * | |
33 | DEST_CNTRY | LLAND | LAND1 | CHAR | 3 | 0 | Destination Country | * | |
34 | ISO_DEST_CNTRY | INTCA | INTCA | CHAR | 2 | 0 | Country ISO code | ||
35 | REGION | REGIO | REGIO | CHAR | 3 | 0 | Region (State, Province, County) | * | |
36 | COUNTY_CDE | COUNC | COUNC | CHAR | 3 | 0 | County Code | * | |
37 | CITY_CODE | CITYC | CITYC | CHAR | 4 | 0 | City Code | * | |
38 | COMP_CODE | BUKRS | BUKRS | CHAR | 4 | 0 | Company Code | * | |
39 | TAX_CLASS1 | TAXK1 | TAXKD | CHAR | 1 | 0 | Tax classification 1 for customer | * | |
40 | TAX_CLASS2 | TAXK2 | TAXKD | CHAR | 1 | 0 | Tax classification 2 for customer | * | |
41 | TAX_CLASS3 | TAXK3 | TAXKD | CHAR | 1 | 0 | Tax classification 3 for customer | * | |
42 | TAX_CLASS4 | TAXK4 | TAXKD | CHAR | 1 | 0 | Tax classification 4 for customer | * | |
43 | TAX_CLASS5 | TAXK5 | TAXKD | CHAR | 1 | 0 | Tax classification 5 for customer | * | |
44 | TAX_CLASS6 | TAXK6 | TAXKD | CHAR | 1 | 0 | Tax classification 6 for customer | * | |
45 | TAX_CLASS7 | TAXK7 | TAXKD | CHAR | 1 | 0 | Tax classification 7 for customer | * | |
46 | TAX_CLASS8 | TAXK8 | TAXKD | CHAR | 1 | 0 | Tax classification 8 for customer | * | |
47 | TAX_CLASS9 | TAXK9 | TAXKD | CHAR | 1 | 0 | Tax classification 9 for customer | * | |
48 | NET_VALUE | NETWR | WERTV8 | CURR | 15 | 2 | Net Value in Document Currency | ||
49 | COMB_CRITERIA | CHAR | 40 | 0 | |||||
50 | CREATED_BY | ERNAM | USNAM | CHAR | 12 | 0 | Name of Person who Created the Object | ||
51 | REC_TIME | ERZET | UZEIT | TIMS | 6 | 0 | Entry time | ||
52 | CR_ON | ERDAT | DATUM | DATS | 8 | 0 | Date on which the record was created | ||
53 | UPDATE_GRP | STAFO | STAFO | CHAR | 6 | 0 | Update group for statistics update | * | |
54 | PAYER | KUNRG | KUNNR | CHAR | 10 | 0 | Payer | * | |
55 | SOLD_TO | KUNAG | KUNNR | CHAR | 10 | 0 | Sold-to party | * | |
56 | DUNN_AREA | MABER | MABER | CHAR | 2 | 0 | Dunning Area | * | |
57 | STAT_CURR | STWAE | WAERS | CUKY | 5 | 0 | Statistics currency | * | |
58 | ISO_STAT_CURR | WAERS_ISO | ISOCD | CHAR | 3 | 0 | ISO code currency | ||
59 | EXPORT_NO | EXNUM | EXNUM | CHAR | 10 | 0 | Number of foreign trade data in MM and SD documents | * | |
60 | VAT_REG_NO | STCEG | STCEG | CHAR | 20 | 0 | VAT Registration Number | ||
61 | CH_ON | AEDAT | DATUM | DATS | 8 | 0 | Last Changed On | ||
62 | CANC_BILL_DOC_NO | SFAKN | VBELN | CHAR | 10 | 0 | Cancelled billing document number | * | |
63 | AGG_COND_GRP | KNUMA | KNUMA | CHAR | 10 | 0 | Agreement (various conditions grouped together) | * | |
64 | BILL_DATE_INV_LIST | FKART_RL | FKART | CHAR | 4 | 0 | Invoice list type | * | |
65 | EXCHG_RATE_TYPE | FKDAT_RL | DATUM | DATS | 8 | 0 | Billing date for the invoice list | ||
66 | EXCHG_RATE | KURST | KURST | CHAR | 4 | 0 | Exchange Rate Type | * | |
67 | DUNN_KEY | MSCHL | MSCHL | CHAR | 1 | 0 | Dunning key | * | |
68 | DUNN_BLOCK | MANSP | MANSP | CHAR | 1 | 0 | Dunning block | * | |
69 | DIVISION | SPART | SPART | CHAR | 2 | 0 | Division | * | |
70 | C_CTR_AREA | KKBER | KKBER | CHAR | 4 | 0 | Credit control area | * | |
71 | CRED_ACCNT | KNKLI | KUNNR | CHAR | 10 | 0 | Customer's account number with credit limit reference | * | |
72 | CURR_KEY_CC_AREA | WAERS_CM | WAERS | CUKY | 5 | 0 | Currency key of credit control area | * | |
73 | ISO_CC_AREA_CURR | WAERS_ISO | ISOCD | CHAR | 3 | 0 | ISO code currency | ||
74 | CR_EXC_RATE_BILL_DOC_RATE | CMKUF | KURRF | DEC | 9 | 5 | Credit data exchange rate at billing document rate | ||
75 | HIER_TYP_PRIC | HITYP_PR | HITYP | CHAR | 1 | 0 | Hierarchy type for pricing | * | |
76 | PURCH_NO_C | BSTKD | BSTKD | CHAR | 35 | 0 | Customer purchase order number | ||
77 | TRADE_ID | RASSC | RCOMP | CHAR | 6 | 0 | Company ID of trading partner | * | |
78 | ACC_BILL_TYPE | FKART_AB | FKART | CHAR | 4 | 0 | Accrual billing type | * | |
79 | APPL_COND | KAPPL | KAPPL | CHAR | 2 | 0 | Application | * | |
80 | TAX_DEPART_CTY | LANDTX | LAND1 | CHAR | 3 | 0 | Tax Departure Country | * | |
81 | ISO_TAX_DEPA | INTCA | INTCA | CHAR | 2 | 0 | Country ISO code | ||
82 | ORG_SALES_TAX_ID | REGIO | REGIO | CHAR | 3 | 0 | Region (State, Province, County) | * | |
83 | SALES_TAX_CNTRY | STCEG_L | LAND1 | CHAR | 3 | 0 | Country of sales tax ID number | * | |
84 | ISO_SALES_TAX_CNTRY | INTCA | INTCA | CHAR | 2 | 0 | Country ISO code | ||
85 | REF_DOC_L | XBLNR_V | XBLNR | CHAR | 16 | 0 | Reference Document Number | ||
86 | ASS_NUMBER | ORDNR_V | ZUONR | CHAR | 18 | 0 | Assignment Number | ||
87 | TAX_AMT_DOC_CURR | MWSBP | WERTV7 | CURR | 13 | 2 | Tax amount in document currency | ||
88 | LOG_SYSTEM | LOGSYS | LOGSYS | CHAR | 10 | 0 | Logical system | * | |
89 | FLAG_BILL_DOC_CANC | FKSTO | XFELD | CHAR | 1 | 0 | Billing document is cancelled | ||
90 | EU_TRIANG_DEAL | XEGDR | XFELD | CHAR | 1 | 0 | Indicator: Triangular deal within the EU ? | ||
91 | NUM_PAY_CARD_PLAN | RPLNR | FPLNR | CHAR | 10 | 0 | Installment Plan Number | * | |
92 | INT_FIN_DOC_NO | LCNUM | LCNUM | CHAR | 10 | 0 | Financial doc. processing: Internal financial doc. number | * | |
93 | TAX_TYPE | J_1AFITP_D | J_1AFITP | CHAR | 2 | 0 | Tax type | * | |
94 | TRANS_DATE | WWERT_D | DATUM | DATS | 8 | 0 | Translation date | ||
95 | CURR_KEY_LET_CR_FT | AKWAE | WAERS | CUKY | 5 | 0 | Currency key for letter-of-credit procg in foreign trade | * | |
96 | ISO_LET_CR_FT_CURR | WAERS_ISO | ISOCD | CHAR | 3 | 0 | ISO code currency | ||
97 | EXCH_KEY_LET_CR_FT | AKKUR | KURRF | DEC | 9 | 5 | Exchange rate for letter-of-credit procg in foreign trade | ||
98 | PAYMENT_REF | KIDNO | CHAR30 | CHAR | 30 | 0 | Payment Reference | ||
99 | PARTNER_BK | BVTYP | BVTYP | CHAR | 4 | 0 | Partner bank type | ||
100 | NUM_PG_INVOICE | J_1ANOPG | J_1ANOPG | NUMC | 3 | 0 | Number of pages of invoice | ||
101 | BUSS_PLACE | CHAR | 4 | 0 | |||||
102 | VKONT | CHAR | 12 | 0 | |||||
103 | DOC_STAT_ACC_TRAN | CHAR | 1 | 0 | |||||
104 | NRZAS | CHAR | 12 | 0 |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in |