SAP ABAP Table TINV_INV_LINE_A (Payment Advice Line)
Hierarchy
☛
IS-UT (Software Component) SAP Utilities/Telecommunication
⤷ IS-U-IDE (Application Component) Intercompany Data Exchange
⤷ EE_INVOICE_RECEIPT (Package) Bill Receipt Checks
⤷ IS-U-IDE (Application Component) Intercompany Data Exchange
⤷ EE_INVOICE_RECEIPT (Package) Bill Receipt Checks
Basic Data
Table Category | TRANSP | Transparent table |
Transparent table | TINV_INV_LINE_A | Table Relationship Diagram |
Short Description | Payment Advice Line |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | A | Application Table (Master- and Transaction Data) |
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 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | * | |
2 | 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 | ||
3 | INT_INV_LINE_NO | INV_INT_INV_LINE_NO | INV_INT_INV_LINE_NO | NUMC | 8 | 0 | Line Item Number of Bill/Payment Advice Note Document | ||
4 | BETRW | INV_BETRW_GROSS | WRTV7 | CURR | 13 | 2 | Gross Amount in Transaction Currency with +/- Sign | ||
5 | BETRW_NET | INV_BETRW_NET | WRTV7 | CURR | 13 | 2 | Net Amount in Transaction Currency with +/- Sign | ||
6 | BETRW_REQ | INV_REQ_BETRW_GROSS | WRTV7 | CURR | 13 | 2 | Requested Gross Amount in Transaction Currency | ||
7 | BETRW_SKONTO | INV_BETRW_SKONTO | WRTV7 | CURR | 13 | 2 | Cash Discount Amount in Transaction Currency with +/+ Sign | ||
8 | CURRENCY | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | * | |
9 | TAXBW | INV_TAXBW | WRTV7 | CURR | 13 | 2 | Tax Amount in Transaction Currency | ||
10 | STPRZ | STRPZ_KK_1 | PRZ33_KK | DEC | 6 | 0 | Tax rate | ||
11 | MWSKZ | MWSKZ | MWSKZ | CHAR | 2 | 0 | Tax on sales/purchases code | * | |
12 | DATE_OF_PAYMENT | INV_DATE_OF_PAYMENT | DATS | 8 | 0 | Due Date | |||
13 | PAYMENTDATE | INV_PAYMENTDATE | DATS | 8 | 0 | Payment Date | |||
14 | EXT_LINE_NO | INV_EXT_LINE_NO | NUMC | 6 | 0 | External Document Line Item Number | |||
15 | DATE_FROM | INV_DATE_FROM | DATS | 8 | 0 | Start of Period | |||
16 | DATE_TO | INV_DATE_TO | DATS | 8 | 0 | End of Period | |||
17 | LINE_TYPE | INV_LINE_TYPE | INV_LINE_TYPE | NUMC | 4 | 0 | Line Type | TINV_C_LINETYPE | |
18 | TRANSF_RELEVANT | INV_KZ_TRANSF_RELEVANT | INV_KENNZX | CHAR | 1 | 0 | Relevant to Transfer | ||
19 | TRANSF_DONE | INV_KZ_TRANSF_DONE | INV_KENNZX | CHAR | 1 | 0 | Data Transferred | ||
20 | RSTGR | RSTGR | RSTGR | CHAR | 3 | 0 | Reason Code for Payments | TINV_C_ADJ_RSN | |
21 | INT_IDENT_TYPE | INV_INT_IDENT_TYPE | INV_INT_IDENT_TYPE | NUMC | 2 | 0 | Type of Internal Identifier | ||
22 | INT_IDENT | INV_INT_IDENT | INV_INT_IDENT | CHAR | 50 | 0 | Internal Document Identification | ||
23 | EXT_PARTNER | BU_BPEXT | CHAR20 | CHAR | 20 | 0 | Business Partner Number in External System | ||
24 | INT_PARTNER | BU_PARTNER | BU_PARTNER | CHAR | 10 | 0 | Business Partner Number | * | |
25 | EXT_INVOICE_NO | INV_EXT_DOC_NO_ADVICE | TEXT40 | CHAR | 40 | 0 | External Document Number | ||
26 | OWN_INVOICE_NO | INV_OWN_INVOICE_NO | TEXT40 | CHAR | 40 | 0 | Internal Document Number | ||
27 | VTREF | VTREF_KK | VTREF_KK | CHAR | 20 | 0 | Reference Specifications from Contract | ||
28 | .INCLUDE | 0 | 0 | ||||||
29 | CONTRACT | INV_CONTRACT | INV_CONTRACT | CHAR | 10 | 0 | Contract | ||
30 | VKONT_PAY | INV_VKONT_PAY | VKONT_KK | CHAR | 12 | 0 | Contract Account for Payment | * | |
31 | BVRKO | INV_BVRKO | SAKNR | CHAR | 10 | 0 | Clearing Account for Aggregation/Payment Distribution | * |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | TINV_INV_LINE_A | LINE_TYPE | TINV_C_LINETYPE | LINE_TYPE | |||
2 | TINV_INV_LINE_A | RSTGR | TINV_C_ADJ_RSN | RSTGR | KEY | C | CN |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in | 471 |