SAP ABAP Table INV_DIALOG_SCREEN_TAB_ADVICE (Bill Dialog: Data for Payment Advice Note Data Tabs)
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_TAB_ADVICE | Table Relationship Diagram |
Short Description | Bill Dialog: Data for Payment Advice Note Data Tabs |
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 | ADV_LINE_TYPE | INV_LINE_TYPE | INV_LINE_TYPE | NUMC | 4 | 0 | Line Type | TINV_C_LINETYPE | |
2 | ADV_BETRW | INV_BETRW_GROSS | WRTV7 | CURR | 13 | 2 | Gross Amount in Transaction Currency with +/- Sign | ||
3 | ADV_BETRW_NET | INV_BETRW_NET | WRTV7 | CURR | 13 | 2 | Net Amount in Transaction Currency with +/- Sign | ||
4 | ADV_BETRW_REQ | INV_REQ_BETRW_GROSS | WRTV7 | CURR | 13 | 2 | Requested Gross Amount in Transaction Currency | ||
5 | ADV_BETRW_SKONTO | INV_BETRW_SKONTO | WRTV7 | CURR | 13 | 2 | Cash Discount Amount in Transaction Currency with +/+ Sign | ||
6 | ADV_CURRENCY | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | TCURC | |
7 | ADV_TAXBW | INV_TAXBW | WRTV7 | CURR | 13 | 2 | Tax Amount in Transaction Currency | ||
8 | ADV_STPRZ | STRPZ_KK_1 | PRZ33_KK | DEC | 6 | 0 | Tax rate | ||
9 | ADV_MWSKZ | MWSKZ | MWSKZ | CHAR | 2 | 0 | Tax on sales/purchases code | * | |
10 | ADV_DATE_OF_PAYMENT | INV_DATE_OF_PAYMENT | DATS | 8 | 0 | Due Date | |||
11 | ADV_PAYMENTDATE | INV_PAYMENTDATE | DATS | 8 | 0 | Payment Date | |||
12 | ADV_DATE_FROM | INV_DATE_FROM | DATS | 8 | 0 | Start of Period | |||
13 | ADV_DATE_TO | INV_DATE_TO | DATS | 8 | 0 | End of Period | |||
14 | ADV_RSTGR | RSTGR | RSTGR | CHAR | 3 | 0 | Reason Code for Payments | TINV_C_ADJ_RSN | |
15 | ADV_BETRW_SKONTO_GROSS | INV_SKONTO_BETRW_GROSS | WRTV7 | CURR | 13 | 2 | Bill - Cash Discount Amount in Trans. Crcy with +/- Sign | ||
16 | ADV_MC_NAME1 | INV_BUPA_NAME1 | BU_MCNAME1_GK | CHAR | 35 | 0 | Last Name of Business Partner | ||
17 | ADV_MC_NAME2 | INV_BUPA_NAME2 | BU_MCNAME2_GK | CHAR | 35 | 0 | Name 2/First Name of Business Partner | ||
18 | ADV_MC_STREET | INV_BUPA_STREET | TEXT25 | CHAR | 25 | 0 | Street of Business Partner | ||
19 | ADV_MC_HOUSE_NUM1 | AD_HSNM1 | TEXT10 | CHAR | 10 | 0 | House Number | ||
20 | ADV_MC_CITY1 | INV_BUPA_CITY | TEXT25 | CHAR | 25 | 0 | Location of Business Partner | ||
21 | ADV_MC_POSTCODE | AD_PSTCD1 | CHAR10 | CHAR | 10 | 0 | City postal code | ||
22 | ADV_EXT_INVOICE_NO | INV_EXT_DOC_NO_ADVICE | TEXT40 | CHAR | 40 | 0 | External Document Number | ||
23 | ADV_EXT_IDENT_TYPE | INV_EXT_IDENT_TYPE | INV_EXT_IDENT_TYPE | CHAR | 2 | 0 | External Identification Type (for Example PoD) | ||
24 | ADV_EXT_IDENT | INV_EXT_IDENT | INV_EXT_IDENT | CHAR | 50 | 0 | External Identification of Document (e.g. Point of Delivery) | ||
25 | ADV_INT_IDENT_TYPE | INV_INT_IDENT_TYPE | INV_INT_IDENT_TYPE | NUMC | 2 | 0 | Type of Internal Identifier | ||
26 | ADV_INT_IDENT | INV_INT_IDENT | INV_INT_IDENT | CHAR | 50 | 0 | Internal Document Identification | ||
27 | ADV_OWN_INVOICE_NO | INV_OWN_INVOICE_NO | TEXT40 | CHAR | 40 | 0 | Internal Document Number | ||
28 | ADV_BETRW_CHECK_SUM | INV_BETRW_CHECK_SUM | WRTV7 | CURR | 13 | 2 | Check Sum of Gross Amount in Transaction Currency with +/- | ||
29 | ADV_BETRW_GIVEN_CHECK_SUM | INV_BETRW_GIVEN_CHECK_SUM | WRTV7 | CURR | 13 | 2 | Preassigned Check Sum f. Gross Amt in Trans. Currency w. +/- | ||
30 | ADV_CONTRACT | INV_CONTRACT | INV_CONTRACT | CHAR | 10 | 0 | Contract | ||
31 | ADV_INT_PARTNER | BU_PARTNER | BU_PARTNER | CHAR | 10 | 0 | Business Partner Number | * |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | INV_DIALOG_SCREEN_TAB_ADVICE | ADV_CURRENCY | TCURC | WAERS | KEY | 1 | CN |
2 | INV_DIALOG_SCREEN_TAB_ADVICE | ADV_LINE_TYPE | TINV_C_LINETYPE | LINE_TYPE | KEY | 1 | CN |
3 | INV_DIALOG_SCREEN_TAB_ADVICE | ADV_RSTGR | TINV_C_ADJ_RSN | RSTGR | KEY | C | CN |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in | 471 |