SAP ABAP Table INV_DIALOG_SCREEN (Bill Dialog: Screen Data)
Hierarchy
☛
IS-UT (Software Component) SAP Utilities/Telecommunication
⤷ IS-U-IDE (Application Component) Intercompany Data Exchange
⤷ EE_INVOICE_RECEIPT_ISU (Package) IS-U-Specific Bill Receipt Check
⤷ IS-U-IDE (Application Component) Intercompany Data Exchange
⤷ EE_INVOICE_RECEIPT_ISU (Package) IS-U-Specific Bill Receipt Check
Basic Data
Table Category | INTTAB | Structure |
Structure | INV_DIALOG_SCREEN | Table Relationship Diagram |
Short Description | Bill Dialog: Screen Data |
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 | .INCLUDE | 0 | 0 | Bill Dialog: Screen Data Bill Header | |||||
2 | INVOICE_TYPE | INV_INVOICE_TYPE | INV_INVOICE_TYPE | NUMC | 3 | 0 | Type of Bill / Type of Payment Advice Note | TINV_C_INVTYPE | |
3 | DOC_TYPE | INV_DOC_TYPE | NUMC | 3 | 0 | Document Type | TINV_C_DOCTYPE | ||
4 | DATE_OF_RECEIPT | INV_DATE_OF_RECEIPT | DATS | 8 | 0 | Document Date of Receipt | |||
5 | EXT_SENDER | INV_EXT_SENDER | TEXT40 | CHAR | 40 | 0 | External Description of Bill/PAN Sender | ||
6 | EXT_RECEIVER | INV_EXT_RECEIVER | TEXT40 | CHAR | 40 | 0 | External Description of Bill/PAN Recipient | ||
7 | INVOICE_STATUS | INV_INVOICE_STATUS | INV_INVOICE_STATUS | NUMC | 2 | 0 | Bill/Payment Advice Note Status | ||
8 | AUTH_GRP | AUTHGR | BRGRU | CHAR | 4 | 0 | Authorization group | * | |
9 | BANK_TXT | INV_BANK_TXT | CHAR | 40 | 0 | Bank Data | |||
10 | BANK_TXT_RECV | INV_BANK_TXT_RECV | CHAR | 40 | 0 | Bank Data: Recipient | |||
11 | SENDER | INV_SENDER_SERV_PROV | SERVICE_PROV | CHAR | 10 | 0 | Sender | ESERVPROV | |
12 | RECEIVER | INV_RECEIV_SERV_PROV | SERVICE_PROV | CHAR | 10 | 0 | Recipient | ESERVPROV | |
13 | SENDER_TXT | SERVICE_PROV_TEXT | TEXT40 | CHAR | 40 | 0 | Name of service provider | ||
14 | STCEG | STCEG | STCEG | CHAR | 20 | 0 | VAT Registration Number | ||
15 | MC_NAME1 | INV_BUPA_NAME1 | BU_MCNAME1_GK | CHAR | 35 | 0 | Last Name of Business Partner | ||
16 | MC_NAME2 | INV_BUPA_NAME2 | BU_MCNAME2_GK | CHAR | 35 | 0 | Name 2/First Name of Business Partner | ||
17 | MC_STREET | INV_BUPA_STREET | TEXT25 | CHAR | 25 | 0 | Street of Business Partner | ||
18 | MC_HOUSE_NUM1 | AD_HSNM1 | TEXT10 | CHAR | 10 | 0 | House Number | ||
19 | MC_CITY1 | INV_BUPA_CITY | TEXT25 | CHAR | 25 | 0 | Location of Business Partner | ||
20 | MC_POSTCODE | AD_PSTCD1 | CHAR10 | CHAR | 10 | 0 | City postal code | ||
21 | FRAME_HEAD_TEXT | CHAR | 80 | 0 | |||||
22 | COMP_CODE_RECV | BUKRS | BUKRS | CHAR | 4 | 0 | Company Code | * | |
23 | EXT_IDENT | INV_EXT_IDENT | INV_EXT_IDENT | CHAR | 50 | 0 | External Identification of Document (e.g. Point of Delivery) | ||
24 | INT_IDENT_TYPE | INV_INT_IDENT_TYPE | INV_INT_IDENT_TYPE | NUMC | 2 | 0 | Type of Internal Identifier | ||
25 | INT_IDENT | INV_INT_IDENT | INV_INT_IDENT | CHAR | 50 | 0 | Internal Document Identification | ||
26 | IDENT_STATUS | CHAR | 55 | 0 | |||||
27 | .INCLUDE | 0 | 0 | Bill Dialog: Screen Data Document Header | |||||
28 | DOC_STATUS | INV_DOC_STATUS | INV_DOC_STATUS | NUMC | 2 | 0 | Document Status | ||
29 | INVOICE_DATE | INV_INVOICE_DATE | DATS | 8 | 0 | Bill/Payment Advice Note Date | |||
30 | INVPERIOD_START | INV_PERIOD_START | DATS | 8 | 0 | Start of Validity Period for Bill/PAN | |||
31 | INVPERIOD_END | INV_PERIOD_END | DATS | 8 | 0 | End fo Validity Period for Bill/PAN | |||
32 | EXT_INVOICE_NO | INV_EXT_INVOICE_NO | TEXT40 | CHAR | 40 | 0 | External Bill/Payment Advice Note Number | ||
33 | EXT_INV_NO_ORIG | INV_EXT_INVOICE_NO_ORIG | TEXT40 | CHAR | 40 | 0 | Original External Bill/PAN Number | ||
34 | DATE_OF_PAYMENT | INV_DATE_OF_PAYMENT | DATS | 8 | 0 | Due Date | |||
35 | EXT_PARTNER | BU_BPEXT | CHAR20 | CHAR | 20 | 0 | Business Partner Number in External System | ||
36 | INT_PARTNER | BU_PARTNER | BU_PARTNER | CHAR | 10 | 0 | Business Partner Number | * | |
37 | INV_BULK_REF | INV_BULK_REF | TEXT22 | CHAR | 22 | 0 | Data Exchange Group Reference Number | ||
38 | .INCLUDE | 0 | 0 | Bill Dialog: Data of Tab with Main Data | |||||
39 | CURRENCY | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | TCURC | |
40 | STRPZ | INV_TAX_PERCENT_RATE | PRZ33_KK | DEC | 6 | 0 | Tax Percentage | ||
41 | BILL_BETRW_NET | INV_SUM_BETRW_NET | WRTV7 | CURR | 13 | 2 | Total Net Amount in Transaction Currency with +/- Sign | ||
42 | PAYED_BETRW_NET | INV_PAYED_BETRW_NET | WRTV7 | CURR | 13 | 2 | Total BB Amts - Net Amts in Trans. Currency with +/- Sign | ||
43 | TOPAY_BETRW_NET | INV_TOPAY_BETRW_NET | WRTV7 | CURR | 13 | 2 | Bill Total - Net Amt in Transaction Currency with +/- Sign | ||
44 | TAX_BILL_BETRW | INV_TAXBW | WRTV7 | CURR | 13 | 2 | Tax Amount in Transaction Currency | ||
45 | TAX_PAYED_BETRW | INV_TAXBW | WRTV7 | CURR | 13 | 2 | Tax Amount in Transaction Currency | ||
46 | TAX_TOPAY_BETRW | INV_TAXBW | WRTV7 | CURR | 13 | 2 | Tax Amount in Transaction Currency | ||
47 | BILL_BETRW_GROSS | INV_SUM_BETRW_GROSS | WRTV7 | CURR | 13 | 2 | Total Gross Amount in Transaction Currency with +/- Sign | ||
48 | PAYED_BETRW_GROSS | INV_PAYED_BETRW_GROSS | WRTV7 | CURR | 13 | 2 | Total BB Amts - Gross Amts in Trans. Currency with +/- Sign | ||
49 | TOPAY_BETRW_GROSS | INV_TOPAY_BETRW_GROSS | WRTV7 | CURR | 13 | 2 | Bill Total - Gross Amt in Transaction Currency with +/- Sign | ||
50 | MWSKZ | MWSKZ | MWSKZ | CHAR | 2 | 0 | Tax on sales/purchases code | T007A | |
51 | KALSM | KALSM_D | KALSM | CHAR | 6 | 0 | Procedure (Pricing, Output Control, Acct. Det., Costing,...) | * | |
52 | .INCLUDE | 0 | 0 | Bill Dialog: Screen Data Bank Details | |||||
53 | BANKS | BANKS | LAND1 | CHAR | 3 | 0 | Bank country key | T005 | |
54 | BANKL | BANKK | BANKK | CHAR | 15 | 0 | Bank Keys | ||
55 | BANKN | BANKN | BANKN | CHAR | 18 | 0 | Bank account number | ||
56 | BKONT | BKONT | BKONT | CHAR | 2 | 0 | Bank Control Key | ||
57 | BKREF | BKREF | CHAR20 | CHAR | 20 | 0 | Reference specifications for bank details | ||
58 | KOINH | BU_KOINH | BU_KOINH | CHAR | 60 | 0 | Account Holder Name | ||
59 | BKEXT | BU_BKEXT | CHAR20 | CHAR | 20 | 0 | Bank details ID in external system | ||
60 | IBAN | IBAN | IBAN | CHAR | 34 | 0 | IBAN (International Bank Account Number) | ||
61 | BANKS_RECV | BANKS | LAND1 | CHAR | 3 | 0 | Bank country key | * | |
62 | BANKL_RECV | BANKK | BANKK | CHAR | 15 | 0 | Bank Keys | ||
63 | BANKN_RECV | BANKN | BANKN | CHAR | 18 | 0 | Bank account number | ||
64 | BKONT_RECV | BKONT | BKONT | CHAR | 2 | 0 | Bank Control Key | ||
65 | BKREF_RECV | BKREF | CHAR20 | CHAR | 20 | 0 | Reference specifications for bank details | ||
66 | KOINH_RECV | BU_KOINH | BU_KOINH | CHAR | 60 | 0 | Account Holder Name | ||
67 | BKEXT_RECV | BU_BKEXT | CHAR20 | CHAR | 20 | 0 | Bank details ID in external system | ||
68 | IBAN_RECV | IBAN | IBAN | CHAR | 34 | 0 | IBAN (International Bank Account Number) | ||
69 | .INCLUDE | 0 | 0 | Bill Dialog: Data for Payment Advice Note Data Tabs | |||||
70 | ADV_LINE_TYPE | INV_LINE_TYPE | INV_LINE_TYPE | NUMC | 4 | 0 | Line Type | TINV_C_LINETYPE | |
71 | ADV_BETRW | INV_BETRW_GROSS | WRTV7 | CURR | 13 | 2 | Gross Amount in Transaction Currency with +/- Sign | ||
72 | ADV_BETRW_NET | INV_BETRW_NET | WRTV7 | CURR | 13 | 2 | Net Amount in Transaction Currency with +/- Sign | ||
73 | ADV_BETRW_REQ | INV_REQ_BETRW_GROSS | WRTV7 | CURR | 13 | 2 | Requested Gross Amount in Transaction Currency | ||
74 | ADV_BETRW_SKONTO | INV_BETRW_SKONTO | WRTV7 | CURR | 13 | 2 | Cash Discount Amount in Transaction Currency with +/+ Sign | ||
75 | ADV_CURRENCY | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | TCURC | |
76 | ADV_TAXBW | INV_TAXBW | WRTV7 | CURR | 13 | 2 | Tax Amount in Transaction Currency | ||
77 | ADV_STPRZ | STRPZ_KK_1 | PRZ33_KK | DEC | 6 | 0 | Tax rate | ||
78 | ADV_MWSKZ | MWSKZ | MWSKZ | CHAR | 2 | 0 | Tax on sales/purchases code | T007A | |
79 | ADV_DATE_OF_PAYMENT | INV_DATE_OF_PAYMENT | DATS | 8 | 0 | Due Date | |||
80 | ADV_PAYMENTDATE | INV_PAYMENTDATE | DATS | 8 | 0 | Payment Date | |||
81 | ADV_DATE_FROM | INV_DATE_FROM | DATS | 8 | 0 | Start of Period | |||
82 | ADV_DATE_TO | INV_DATE_TO | DATS | 8 | 0 | End of Period | |||
83 | ADV_RSTGR | RSTGR | RSTGR | CHAR | 3 | 0 | Reason Code for Payments | TINV_C_ADJ_RSN | |
84 | ADV_BETRW_SKONTO_GROSS | INV_SKONTO_BETRW_GROSS | WRTV7 | CURR | 13 | 2 | Bill - Cash Discount Amount in Trans. Crcy with +/- Sign | ||
85 | ADV_MC_NAME1 | INV_BUPA_NAME1 | BU_MCNAME1_GK | CHAR | 35 | 0 | Last Name of Business Partner | ||
86 | ADV_MC_NAME2 | INV_BUPA_NAME2 | BU_MCNAME2_GK | CHAR | 35 | 0 | Name 2/First Name of Business Partner | ||
87 | ADV_MC_STREET | INV_BUPA_STREET | TEXT25 | CHAR | 25 | 0 | Street of Business Partner | ||
88 | ADV_MC_HOUSE_NUM1 | AD_HSNM1 | TEXT10 | CHAR | 10 | 0 | House Number | ||
89 | ADV_MC_CITY1 | INV_BUPA_CITY | TEXT25 | CHAR | 25 | 0 | Location of Business Partner | ||
90 | ADV_MC_POSTCODE | AD_PSTCD1 | CHAR10 | CHAR | 10 | 0 | City postal code | ||
91 | ADV_EXT_INVOICE_NO | INV_EXT_DOC_NO_ADVICE | TEXT40 | CHAR | 40 | 0 | External Document Number | ||
92 | ADV_EXT_IDENT_TYPE | INV_EXT_IDENT_TYPE | INV_EXT_IDENT_TYPE | CHAR | 2 | 0 | External Identification Type (for Example PoD) | ||
93 | ADV_EXT_IDENT | INV_EXT_IDENT | INV_EXT_IDENT | CHAR | 50 | 0 | External Identification of Document (e.g. Point of Delivery) | ||
94 | ADV_INT_IDENT_TYPE | INV_INT_IDENT_TYPE | INV_INT_IDENT_TYPE | NUMC | 2 | 0 | Type of Internal Identifier | ||
95 | ADV_INT_IDENT | INV_INT_IDENT | INV_INT_IDENT | CHAR | 50 | 0 | Internal Document Identification | ||
96 | ADV_OWN_INVOICE_NO | INV_OWN_INVOICE_NO | TEXT40 | CHAR | 40 | 0 | Internal Document Number | ||
97 | ADV_BETRW_CHECK_SUM | INV_BETRW_CHECK_SUM | WRTV7 | CURR | 13 | 2 | Check Sum of Gross Amount in Transaction Currency with +/- | ||
98 | ADV_BETRW_GIVEN_CHECK_SUM | INV_BETRW_GIVEN_CHECK_SUM | WRTV7 | CURR | 13 | 2 | Preassigned Check Sum f. Gross Amt in Trans. Currency w. +/- | ||
99 | ADV_CONTRACT | INV_CONTRACT | INV_CONTRACT | CHAR | 10 | 0 | Contract | ||
100 | ADV_INT_PARTNER | BU_PARTNER | BU_PARTNER | CHAR | 10 | 0 | Business Partner Number | * | |
101 | .INCLUDE | 0 | 0 | Bill Dialog: Changes - Header/Document | |||||
102 | HD_CREATED_BY | ERNAM | USNAM | CHAR | 12 | 0 | Name of Person who Created the Object | ||
103 | HD_CREATED_ON | ERDAT | DATUM | DATS | 8 | 0 | Date on which the record was created | ||
104 | HD_CHANGED_BY | AENAM | USNAM | CHAR | 12 | 0 | Name of Person Who Changed Object | ||
105 | HD_CHANGED_ON | AEDAT | DATUM | DATS | 8 | 0 | Last Changed On | ||
106 | DOC_CREATED_BY | ERNAM | USNAM | CHAR | 12 | 0 | Name of Person who Created the Object | ||
107 | DOC_CREATED_ON | ERDAT | DATUM | DATS | 8 | 0 | Date on which the record was created | ||
108 | DOC_CHANGED_BY | AENAM | USNAM | CHAR | 12 | 0 | Name of Person Who Changed Object | ||
109 | DOC_CHANGED_ON | AEDAT | DATUM | DATS | 8 | 0 | Last Changed On | ||
110 | .INCLUDE | 0 | 0 | Bill Dialog: Screen Data Complaint Data | |||||
111 | ADJ_RSTGR | RSTGR | RSTGR | CHAR | 3 | 0 | Reason Code for Payments | TINV_C_ADJ_RSN | |
112 | ADJ_TEXT | INV_DESCRIPTION | TEXT40 | CHAR | 40 | 0 | General Description | ||
113 | ADJ_FREQU | ADJ_FREQU | INT1 | 3 | 0 | Frequency of Occurance of Reason Code During Bill Processing | |||
114 | .INCLUDE | 0 | 0 | Bill Dialog: Screen Data Reversal Data | |||||
115 | REVERSAL_RSN | INV_CANCEL_RSN | INV_CANCEL_RSN | CHAR | 2 | 0 | Reversal Reason | * | |
116 | REVERSAL_RSN_TXT | INV_DESCRIPTION | TEXT40 | CHAR | 40 | 0 | General Description | ||
117 | .INCLUDE | 0 | 0 | Bill Dialog: Screen Data Template | |||||
118 | TEMPLATE | INV_TEMPLATE_NO | INV_TEMPLATE_NO | NUMC | 18 | 0 | Template Number for Incoming Bill/Pay.Advice Note Processing | ||
119 | INT_INV_NO | INV_INT_INV_NO | INV_INT_INV_NO | NUMC | 18 | 0 | Internal Bill/Payment Advice Number | ||
120 | INT_INV_DOC_NO | INV_INT_INV_DOC_NO | INV_INT_INV_DOC_NO | NUMC | 18 | 0 | Internal Number of Bill Document/Payment Advice Document | ||
121 | OWNER | INV_OWNER | UNAME | CHAR | 12 | 0 | Template Owner | ||
122 | PRIVATE_TMPLT | INV_KENNZX | INV_KENNZX | CHAR | 1 | 0 | General Indicator 'X' or ' ' | ||
123 | CR_DATE | ANDAT | DATUM | DATS | 8 | 0 | Date Record Created on | ||
124 | CR_USER | ANNAM | USNAM | CHAR | 12 | 0 | User Who Created Record | ||
125 | CH_DATE | AEDAT | DATUM | DATS | 8 | 0 | Last Changed On | ||
126 | CH_USER | AENAM | USNAM | CHAR | 12 | 0 | Name of Person Who Changed Object | ||
127 | SPRAS | SYLANGU | SYLANGU | LANG | 1 | 0 | Language Key | ||
128 | DESCRIPTION | INV_TEMPLATE_DESCRIPT | TEXT40 | CHAR | 40 | 0 | Template Description |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | INV_DIALOG_SCREEN | ADJ_RSTGR | TINV_C_ADJ_RSN | RSTGR | KEY | C | CN |
2 | INV_DIALOG_SCREEN | ADV_CURRENCY | TCURC | WAERS | KEY | 1 | CN |
3 | INV_DIALOG_SCREEN | ADV_LINE_TYPE | TINV_C_LINETYPE | LINE_TYPE | KEY | 1 | CN |
4 | INV_DIALOG_SCREEN | ADV_MWSKZ | T007A | MWSKZ | KEY | 1 | CN |
5 | INV_DIALOG_SCREEN | ADV_RSTGR | TINV_C_ADJ_RSN | RSTGR | KEY | C | CN |
6 | INV_DIALOG_SCREEN | BANKS | T005 | LAND1 | REF | 1 | CN |
7 | INV_DIALOG_SCREEN | CURRENCY | TCURC | WAERS | KEY | 1 | CN |
8 | INV_DIALOG_SCREEN | DOC_TYPE | TINV_C_DOCTYPE | DOC_TYPE | KEY | 1 | CN |
9 | INV_DIALOG_SCREEN | INVOICE_TYPE | TINV_C_INVTYPE | INVOICE_TYPE | |||
10 | INV_DIALOG_SCREEN | MWSKZ | T007A | MWSKZ | KEY | 1 | CN |
11 | INV_DIALOG_SCREEN | RECEIVER | ESERVPROV | SERVICEID | KEY | 1 | CN |
12 | INV_DIALOG_SCREEN | SENDER | ESERVPROV | SERVICEID | KEY | 1 | CN |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in | 471 |