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