SAP ABAP Table JSBW_SD_INV_HEAD (IS-M/SD: BW Structure for the Billing Header)
Hierarchy
☛
IS-M (Software Component) SAP MEDIA
⤷ IS-M-IS (Application Component) Information System
⤷ JSBW (Package) IS-M: Link to Business Information Warehouse
⤷ IS-M-IS (Application Component) Information System
⤷ JSBW (Package) IS-M: Link to Business Information Warehouse
Basic Data
Table Category | INTTAB | Structure |
Structure | JSBW_SD_INV_HEAD | Table Relationship Diagram |
Short Description | IS-M/SD: BW Structure for the Billing Header |
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 | ISPVBELN | ISPVBELN | CHAR | 10 | 0 | IS-M/SD: Billing Document | * | |
2 | FKART | JFKART | JFKART | CHAR | 4 | 0 | IS-M: Billing/Settlement Type | * | |
3 | VBTYP | VBTYP | VBTYP | CHAR | 1 | 0 | SD document category | ||
4 | WAERK | WAERK | WAERS | CUKY | 5 | 0 | SD document currency | * | |
5 | VKORG | VKORG | VKORG | CHAR | 4 | 0 | Sales Organization | * | |
6 | VTWEG | VTWEG | VTWEG | CHAR | 2 | 0 | Distribution Channel | * | |
7 | KNUMV | KNUMV | KNUMV | CHAR | 10 | 0 | Number of the document condition | ||
8 | FKDAT | FKDAT | DATUM | DATS | 8 | 0 | Billing date for billing index and printout | ||
9 | BELNR | BELNR_D | BELNR | CHAR | 10 | 0 | Accounting Document Number | ||
10 | GJAHR | GJAHR | GJAHR | NUMC | 4 | 0 | Fiscal Year | ||
11 | POPER | POPER | POPER | NUMC | 3 | 0 | Posting period | ||
12 | KONDA | KONDA | KONDA | CHAR | 2 | 0 | Price Group (Customer) | * | |
13 | KDGRP | KDGRP | KDGRP | CHAR | 2 | 0 | Customer group | * | |
14 | PLTYP | PLTYP | PLTYP | CHAR | 2 | 0 | Price list type | * | |
15 | RFBSK | JFRFBSK | JFRFBSK | CHAR | 1 | 0 | IS-M/SD: Status for transfer to Accounting | ||
16 | KURRF | KURRF | KURRF | DEC | 9 | 5 | Exchange rate for FI postings | ||
17 | ZTERM | DZTERM | ZTERM | CHAR | 4 | 0 | Terms of payment key | ||
18 | ZLSCH | SCHZW_BSEG | ZLSCH | CHAR | 1 | 0 | Payment Method | * | |
19 | KTGRD | KTGRD | KTGRD | CHAR | 2 | 0 | Account assignment group for this customer | * | |
20 | LAND1 | LLAND | LAND1 | CHAR | 3 | 0 | Destination Country | * | |
21 | REGIO | REGIO | REGIO | CHAR | 3 | 0 | Region (State, Province, County) | * | |
22 | COUNC | COUNC | COUNC | CHAR | 3 | 0 | County Code | * | |
23 | CITYC | CITYC | CITYC | CHAR | 4 | 0 | City Code | * | |
24 | BUKRS | BUKRS | BUKRS | CHAR | 4 | 0 | Company Code | * | |
25 | TAXK1 | TAXK1 | TAXKD | CHAR | 1 | 0 | Tax classification 1 for customer | * | |
26 | TAXK2 | TAXK2 | TAXKD | CHAR | 1 | 0 | Tax classification 2 for customer | * | |
27 | TAXK3 | TAXK3 | TAXKD | CHAR | 1 | 0 | Tax classification 3 for customer | * | |
28 | TAXK4 | TAXK4 | TAXKD | CHAR | 1 | 0 | Tax classification 4 for customer | * | |
29 | TAXK5 | TAXK5 | TAXKD | CHAR | 1 | 0 | Tax classification 5 for customer | * | |
30 | TAXK6 | TAXK6 | TAXKD | CHAR | 1 | 0 | Tax classification 6 for customer | * | |
31 | TAXK7 | TAXK7 | TAXKD | CHAR | 1 | 0 | Tax classification 7 for customer | * | |
32 | TAXK8 | TAXK8 | TAXKD | CHAR | 1 | 0 | Tax classification 8 for customer | * | |
33 | TAXK9 | TAXK9 | TAXKD | CHAR | 1 | 0 | Tax classification 9 for customer | * | |
34 | NETWR | NETWR | WERTV8 | CURR | 15 | 2 | Net Value in Document Currency | ||
35 | ZUKRI | DZUKRI | CHAR40 | CHAR | 40 | 0 | Combination criteria in the billing document | ||
36 | ERNAM | ERNAM | USNAM | CHAR | 12 | 0 | Name of Person who Created the Object | ||
37 | ERZET | ERZET | UZEIT | TIMS | 6 | 0 | Entry time | ||
38 | ERDAT | ERDAT | DATUM | DATS | 8 | 0 | Date on which the record was created | ||
39 | STAFO | STAFO | STAFO | CHAR | 6 | 0 | Update group for statistics update | * | |
40 | KUNRG | KUNRG | KUNNR | CHAR | 10 | 0 | Payer | * | |
41 | KUNAG | KUNAG | KUNNR | CHAR | 10 | 0 | Sold-to party | * | |
42 | MABER | MABER | MABER | CHAR | 2 | 0 | Dunning Area | * | |
43 | STWAE | STWAE | WAERS | CUKY | 5 | 0 | Statistics currency | * | |
44 | STCEG | STCEG | STCEG | CHAR | 20 | 0 | VAT Registration Number | ||
45 | AEDAT | AEDAT | DATUM | DATS | 8 | 0 | Last Changed On | ||
46 | KURST | KURST | KURST | CHAR | 4 | 0 | Exchange Rate Type | * | |
47 | SPART | SPART | SPART | CHAR | 2 | 0 | Division | * | |
48 | STCEG_H | STCEG_H | STCEG_H | CHAR | 1 | 0 | Origin of sales tax ID number | ||
49 | STCEG_L | LAND1TX | LAND1 | CHAR | 3 | 0 | Tax Destination Country | * | |
50 | MWSBK | MWSBP | WERTV7 | CURR | 13 | 2 | Tax amount in document currency | ||
51 | SAMMG | ISPSAMMG | ISPSAMMG | CHAR | 10 | 0 | IS-M: Group Number | * | |
52 | .INCLUDE | 0 | 0 | IS-PSD: Billing Document Header Data | |||||
53 | ISPOBJART | LABART | JOBJART | CHAR | 4 | 0 | IS-M: Object type for document flow | ||
54 | ISPBANKS | BANKS | LAND1 | CHAR | 3 | 0 | Bank country key | * | |
55 | ISPBANKL | BANKL | BANKL | CHAR | 15 | 0 | Bank number | ||
56 | ISPBANKN | BANKN | BANKN | CHAR | 18 | 0 | Bank account number | ||
57 | ISPBVTYP | BVTYP | BVTYP | CHAR | 4 | 0 | Partner bank type | ||
58 | ISPXEZER | XEZER | XFELD | CHAR | 1 | 0 | Indicator: Is there collection authorization ? | ||
59 | ISPBKONT | BKONT | BKONT | CHAR | 2 | 0 | Bank Control Key | ||
60 | ISPJAVNR | JAVNR | AVNR | CHAR | 10 | 0 | IS-M: Merge criterion for order | * | |
61 | ISPJAPNR | JAPNR | APNR | NUMC | 6 | 0 | IS-M: Merge criterion for sales order item | * | |
62 | ISPZLSCH | DZLSCH | ZLSCH | CHAR | 1 | 0 | Payment method | * | |
63 | ISPSFAKT | ISPSFAKT | VBELN | CHAR | 10 | 0 | IS-M: Number of Billing Document Reversed | * | |
64 | ISPJSTORN | JSTORN | JVBELN | CHAR | 10 | 0 | IS-M: Reversal Number | * | |
65 | ISPJSNFAK | ISPSNFAK | JVBELN | CHAR | 10 | 0 | IS-M: Number of Reversal in Subsequent Document | * | |
66 | ISPBRTWR | ISPBRTWR | WERTV8 | CURR | 15 | 2 | IS-M: Gross Value in Document Currency | ||
67 | ISPSFKOPF | XSEPFKKOPF | XFELD | CHAR | 1 | 0 | Separate billing document for sales order | ||
68 | ISPJUEBART | JUEBART | JUEBART | CHAR | 1 | 0 | IS-M: Transfer Type | ||
69 | ISPXDRUCK | XRECHDRUCK | XFELD | CHAR | 1 | 0 | IS-M: Print Invoice | ||
70 | ISPANZFPOS | JANZFPOS | JANZFPOS | NUMC | 4 | 0 | IS-M: Number of billing items in billing document | ||
71 | ISPSHKZGK | SHKZG | SHKZG | CHAR | 1 | 0 | Debit/Credit Indicator | ||
72 | ISPBUPER | MONAT | MONAT | NUMC | 2 | 0 | Fiscal period | ||
73 | ISPUMSKZ | UMSKZ | UMSKZ | CHAR | 1 | 0 | Special G/L Indicator | T074U | |
74 | ISPSTOGRD | JSTOGRDF | JSTOGRDF | CHAR | 3 | 0 | IS-M: Billing Document Reversal Reason | TJF27 | |
75 | ISPXJSIND | XJSIND | XFELD | CHAR | 1 | 0 | Repeat Billing After Reversal | ||
76 | ISPUKONT | UKONT_042I | SAKNR | CHAR | 10 | 0 | G/L Account to be Posted to (Bank Subaccount) | * | |
77 | ISPUEBDAT | ISPUEBDAT | ISPUEBDAT | DATS | 8 | 0 | IS-M: Accrual Date | ||
78 | ISPUEBNR | ISPUEBNR | ISPUEBNR | CHAR | 10 | 0 | IS-M: Number of Transfer Run to FI | * | |
79 | ISPXINK | XKINKASSO | XFELD | CHAR | 1 | 0 | IS-M: Payment by field collector | ||
80 | ISPXUINK | XJUINK | CHAR1 | CHAR | 1 | 0 | IS-M: Collection billing doc.transferred to company code | ||
81 | ISPXWBZABO | XWBZABO | XFELD | CHAR | 1 | 0 | IS-M: WBZ subscription | ||
82 | ISPINKVSG | ISPINKVSG | KUNNR | CHAR | 10 | 0 | IS-M: Field Collector is Service Company | * | |
83 | ISPINKGP | ISPINKGP | KUNNR | CHAR | 10 | 0 | IS-M: Field Collector is Employee | * | |
84 | ISPXVDICHT | XFKVDICHT | XFELD | CHAR | 1 | 0 | IS-M: Summarize deliveries according to billing item | ||
85 | ISPJUEBARH | JUEBARTFKH | JUEBART | CHAR | 1 | 0 | IS-M: Transfer type at time of billing | ||
86 | ISPXNOMESS | XNOMESS | XFELD | CHAR | 1 | 0 | IS-M: Indicator - Do Not Perform Output Determination | ||
87 | MNDID | SEPA_MNDID | ID035 | CHAR | 35 | 0 | Unique Referene to Mandate per Payment Recipient | ||
88 | IBAN | IBAN | IBAN | CHAR | 34 | 0 | IBAN (International Bank Account Number) | ||
89 | XRENEWAL | XRENEWAL | XFELD | CHAR | 1 | 0 | IS-M/SD: Order extended by renewal offer | ||
90 | AMORTN | AMORTN | AMORTN | CHAR | 1 | 0 | IS-M/SD: Use of Liability Account in Order | ||
91 | XINVAUTHOR | XINVAUTHOR | XFELD | CHAR | 1 | 0 | IS-M/SD: Billing document authorized | ||
92 | AWREF | AWREF | AWREF | CHAR | 10 | 0 | Reference document number | ||
93 | XTRANSFER | XTRANSFER_INV | XFELD | CHAR | 1 | 0 | IS-M/SD: Transfer billing document | ||
94 | JAVCYCLENR | JAVCYCLENR | CYCLENR | NUMC | 3 | 0 | IS-M: Merge Criterion for Order Billing Cycle | * | |
95 | VKONT | VKONT_KK | VKONT_KK | CHAR | 12 | 0 | Contract Account Number | * | |
96 | XPAYMODE_FIX | XPAYMODE_FIX | XFELD | CHAR | 1 | 0 | IS-M/SD: Payment Arrangement in Order Fixed | ||
97 | BELNR_FKK | OPBEL_KK | OPBEL_KK | CHAR | 12 | 0 | Number of Contract Accts Rec. & Payable Doc. | * | |
98 | NRZAS | NRZAS_KK | NRZAS_KK | CHAR | 12 | 0 | Payment Form Number |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | JSBW_SD_INV_HEAD | ISPSTOGRD | TJF27 | STOGRD | |||
2 | JSBW_SD_INV_HEAD | ISPUMSKZ | T074U | UMSKZ |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in | 471 |