SAP ABAP Table REXCCORRINVITEMREF_C (Invoice item data for correspondence (Hung. localization))
Hierarchy
☛
EA-FIN (Software Component) EA-FIN
⤷ FI-LOC (Application Component) Localization
⤷ GLO_REFX_CORR_DDIC (Package) Localization Flexible Real Estate
⤷ FI-LOC (Application Component) Localization
⤷ GLO_REFX_CORR_DDIC (Package) Localization Flexible Real Estate
Basic Data
Table Category | INTTAB | Structure |
Structure | REXCCORRINVITEMREF_C | Table Relationship Diagram |
Short Description | Invoice item data for correspondence (Hung. localization) |
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 | RE Invoice Item | |||||
2 | .INCLUDE | 0 | 0 | RE Invoice Item and Additional Fields | |||||
3 | .INCLUDE | 0 | 0 | RE Invoice Item | |||||
4 | .INCLUDE | 0 | 0 | RE Invoice Item | |||||
5 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | * | |
6 | .INCLUDE | 0 | 0 | RE Invoice Item: Key Fields | |||||
7 | INVGUID | RERAINVGUID | RECAGUID | RAW | 16 | 0 | GUID: Unique Internal Key for RE Invoice | VIRAINV | |
8 | ITEMNO | RERAINVITEMNO | POSNR_ACC | NUMC | 10 | 0 | Item Number in RE Invoice | ||
9 | .INCLUDE | 0 | 0 | RE Invoice Item: Non-Key Fields | |||||
10 | OBJNR | RERAINVOBJNR | J_OBJNR | CHAR | 22 | 0 | Object Number of Contract for the Invoice Item | * | |
11 | OBJNRCALC | RECDOBJNRCALC | J_OBJNR | CHAR | 22 | 0 | Object Number for Calculation | * | |
12 | ITEMSRCIND | RERAINVITEMSRCIND | RERAINVITEMSRCIND | CHAR | 1 | 0 | Source of Invoice Item | ||
13 | CONDTYPE | RECDCONDTYPE | RECDCONDTYPE | CHAR | 4 | 0 | Condition Type | TIVCDCONDTYPE | |
14 | FLOWTYPE | RECDFLOWTYPE | RECDFLOWTYPE | CHAR | 4 | 0 | Flow Type | TIVCDFLOWTYPE | |
15 | BLINEDATE | DZFBDT | DATUM | DATS | 8 | 0 | Baseline date for due date calculation | ||
16 | CALCFROM | DBERVON | DATUM | DATS | 8 | 0 | Start of Calculation Period | ||
17 | CALCTO | DBERBIS | DATUM | DATS | 8 | 0 | End of Calculation Period | ||
18 | ISADVANCEPAYMENT | RECDADVANCEPAYMENT | RECABOOL | CHAR | 1 | 0 | Condition Is Advance Payment Condition | ||
19 | CURRENCY | RECACTLCCURRKEY | WAERS | CUKY | 5 | 0 | Local Currency | * | |
20 | GROSSAMOUNT | RECACTLCGROSSAMOUNT | RECACURR | CURR | 15 | 2 | Gross Amount in Local Currency | ||
21 | NETAMOUNT | RECACTLCNETAMOUNT | RECACURR | CURR | 15 | 2 | Net Amount in Local Currency | ||
22 | TAXAMOUNT | RECACTLCTAXAMOUNT | RECACURR | CURR | 15 | 2 | Tax Amount in Local Currency | ||
23 | TAXTYPE | RERATAXTYPE | RERATAXTYPE | CHAR | 4 | 0 | Tax Type | TIVRATAXTYPE | |
24 | TAXGROUP | RERATAXGROUP | RERATAXGROUP | CHAR | 20 | 0 | Tax Group | TIVRATAXGROUP | |
25 | PYMTMETH | RERAPYMTMETH | CHAR4 | CHAR | 4 | 0 | Payment Method | ||
26 | PYMTTERM | RERAPYMTTERM | ZTERM | CHAR | 4 | 0 | Terms of Payment Key | ||
27 | XMACCTSHEETITEM | RERAXLACCTSHEETITEM | RECAXLDESCRIPTION | CHAR | 60 | 0 | Name of Contract Account Sheet Item | ||
28 | .INCLUDE | 0 | 0 | RE Invoice Item: Fields from FI Document Item | |||||
29 | DOCITEMID | RERADOCITEMID | RERADOCITEMID | CHAR | 30 | 0 | Coded Key of FI Document Item for RE Internal Use | ||
30 | REFDOCID | RERAREFDOCID | CHAR20 | CHAR | 20 | 0 | Reference Key of Document | ||
31 | REFITEMNO | RERAREFITEMNO | POSNR_ACC | NUMC | 10 | 0 | Reference to Other Item Number of Document | ||
32 | LOGSYSTEM | LOGSYSTEM | LOGSYS | CHAR | 10 | 0 | Logical System | * | |
33 | OBJ_TYPE | AWTYP | AWTYP | CHAR | 5 | 0 | Reference procedure | * | |
34 | OBJ_KEY | AWKEY | AWKEY | CHAR | 20 | 0 | Object key | ||
35 | PSTNGDATE | RERAPSTNGDATE | RECADATE | DATS | 8 | 0 | Posting Date | ||
36 | DOCDATE | RERADOCDATE | RECADATE | DATS | 8 | 0 | Document Date | ||
37 | CLEARINGDATE | RERACLRNGDATE | RECADATE | DATS | 8 | 0 | Clearing Date | ||
38 | CLEARINGSTATUS | RERACLEARINGSTATUS | CHAR02 | CHAR | 2 | 0 | Clearing status | ||
39 | PROCESSID | RECAPROCESSID | RECAPROCESSID | CHAR | 16 | 0 | Process Identification -> Accounting Reference Number | ||
40 | PSTNGPROCEDURE | RERAPROCEDURE | RERAPROCEDURE | CHAR | 4 | 0 | Posting Procedure | * | |
41 | XMACCTSHEETHDR | RERAXLACCTSHEETHDR | RECAXLDESCRIPTION | CHAR | 60 | 0 | Name from Document Header | ||
42 | TAXRATE | RERATAXRATE | PRZ43V | DEC | 7 | 3 | Tax Rate | ||
43 | TAXDATE | RERATAXDATE | RECADATE | DATS | 8 | 0 | Date of Tax Calculation | ||
44 | TXJCD | TXJCD | TXJCD | CHAR | 15 | 0 | Tax Jurisdiction | * | |
45 | HOUSEBKID | RERAHOUSEBKID | CHAR15 | CHAR | 15 | 0 | Key for House Bank | ||
46 | HOUSEBKACC | RERAHOUSEBKACC | CHAR15 | CHAR | 15 | 0 | Key for House Bank Account | ||
47 | BANKDETAILID | RERABANKDETAILID | CHAR15 | CHAR | 15 | 0 | Bank Details ID | ||
48 | FCCURRKEY | RECACTFCCURRKEY | WAERS | CUKY | 5 | 0 | Foreign Currency | * | |
49 | FCGROSSAMOUNT | RECACTFCGROSSAMOUNT | RECACURR | CURR | 15 | 2 | Gross Amount in Foreign Currency | ||
50 | FCNETAMOUNT | RECACTFCNETAMOUNT | RECACURR | CURR | 15 | 2 | Net Amount in Foreign Currency | ||
51 | FCTAXAMOUNT | RECACTFCTAXAMOUNT | RECACURR | CURR | 15 | 2 | Tax Amount in Foreign Currency | ||
52 | CTRULE | RECACTRULE | RECACTRULE | CHAR | 20 | 0 | Currency Translation Rule | * | |
53 | CTRATE | RECACTRATE | KURSF | DEC | 9 | 5 | Exchange Rate | ||
54 | CTDATEREQ | RECACTDATEREQ | DATS | DATS | 8 | 0 | Planned Translation Date | ||
55 | CTDATEACT | RECACTDATEACT | DATS | DATS | 8 | 0 | Actual Translation Date | ||
56 | POSTCDCURR | RECACTPOSTCDCURR | RECABOOL | CHAR | 1 | 0 | Post in Condition Currency | ||
57 | TCCURRKEY | RERATCCURRKEY | WAERS | CUKY | 5 | 0 | Document Currency (Transaction Currency) | * | |
58 | TCGROSSAMOUNT | RERATCGROSSAMOUNT | RECACURR | CURR | 15 | 2 | Gross Amount in Document Currency (Transaction Currency) | ||
59 | TCNETAMOUNT | RERATCNETAMOUNT | RECACURR | CURR | 15 | 2 | Net Amount in Document Currency (Transaction Currency) | ||
60 | TCTAXAMOUNT | RERATCTAXAMOUNT | RECACURR | CURR | 15 | 2 | Tax Amount in Document Currency (Transaction Currency) | ||
61 | SEPAMNDID | RETMSEPAMNDID | RETMSEPAMNDID | CHAR | 35 | 0 | SEPA Mandate: Unique Reference to Mandate per Vendor | ||
62 | SEPARECCRDID | RETMSEPARECCRDID | RETMSEPACRDID | CHAR | 35 | 0 | SEPA Mandate: Creditor ID | ||
63 | XCONDTYPEM | RECDXCONDTYPEM | TEXT20 | CHAR | 20 | 0 | Name of Condition Type | ||
64 | XCONDTYPEL | RECDXCONDTYPEL | RECAXMDESCRIPTION | CHAR | 30 | 0 | Name of Condition Type | ||
65 | XFLOWTYPE | RECDXFLOWTYPE | TEXT30 | CHAR | 30 | 0 | Name of Flow Type | ||
66 | XDATERANGECALC | RECAXDATERANGE | CHAR23 | CHAR | 23 | 0 | Time Period (Text) | ||
67 | INSTALLMENTITEM | RECPINSTALLMENT | RECABOOL | CHAR | 1 | 0 | Item from Installment Payment? | ||
68 | CUKY2ND | RECPCUKY2ND | WAERS | CUKY | 5 | 0 | Second Currency for Correspondence | * | |
69 | GROSSAMOUNT_2ND | RECACURR2ND | RECACURR | CURR | 15 | 2 | Amount in 2nd Currency | ||
70 | NETAMOUNT_2ND | RECACURR2ND | RECACURR | CURR | 15 | 2 | Amount in 2nd Currency | ||
71 | TAXAMOUNT_2ND | RECACURR2ND | RECACURR | CURR | 15 | 2 | Amount in 2nd Currency | ||
72 | CORR_REASON | REXCCORRCORRREASON | CHAR100 | CHAR | 100 | 0 | Reason for Correction/Reversal | ||
73 | INVNO_ORIG | RERAINVNO | RERAINVNO | NUMC | 10 | 0 | Invoice Number | ||
74 | INVITEMNO_ORIG | RERAINVITEMNO | POSNR_ACC | NUMC | 10 | 0 | Item Number in RE Invoice | ||
75 | INVFISCYEAR_ORIG | GJAHR | GJAHR | NUMC | 4 | 0 | Fiscal Year | ||
76 | INVITEMNETAMOUNT_OLD | REXCCORRINVITEMAMOUNTOLD | RECACURR | CURR | 15 | 2 | Old item value, with negative signed amounts | ||
77 | TAXRATE_OLD | RERATAXRATE | PRZ43V | DEC | 7 | 3 | Tax Rate | ||
78 | TAXAMOUNT_OLD | RERATAXAMOUNT | RECACURR | CURR | 15 | 2 | Tax Amount in Transaction Currency | ||
79 | INVITEMGROSSAMOUNT_OLD | RERAGROSSAMOUNT | RECACURR | CURR | 15 | 2 | Gross Amount in Transaction Currency | ||
80 | INVITEMNETAMOUNT_DIFF | REXCCORRINVITEMAMOUNTOLD | RECACURR | CURR | 15 | 2 | Old item value, with negative signed amounts | ||
81 | TAXRATE_DIFF | RERATAXRATE | PRZ43V | DEC | 7 | 3 | Tax Rate | ||
82 | TAXAMOUNT_DIFF | RERATAXAMOUNT | RECACURR | CURR | 15 | 2 | Tax Amount in Transaction Currency | ||
83 | INVITEMGROSSAMOUNT_DIFF | REXCCORRINVITEMAMOUNTOLD | RECACURR | CURR | 15 | 2 | Old item value, with negative signed amounts | ||
84 | REFDOCID_OLD | REXCCORRREFDOCIDOLD | CHAR20 | CHAR | 20 | 0 | Reference Key of corrected Document | ||
85 | DOCITEMID_OLD | REXCCORRDOCITEMNOOLD | RERADOCITEMID | CHAR | 30 | 0 | Coded Key of corrected FI Document Item for RE Internal Use | ||
86 | INVITEMNETAMOUNT_NEW | REXCCORRINVITEMAMOUNTOLD | RECACURR | CURR | 15 | 2 | Old item value, with negative signed amounts | ||
87 | TAXRATE_NEW | RERATAXRATE | PRZ43V | DEC | 7 | 3 | Tax Rate | ||
88 | TAXAMOUNT_NEW | RERATAXAMOUNT | RECACURR | CURR | 15 | 2 | Tax Amount in Transaction Currency | ||
89 | INVITEMGROSSAMOUNT_NEW | RERAGROSSAMOUNT | RECACURR | CURR | 15 | 2 | Gross Amount in Transaction Currency | ||
90 | TRRULE | REXCCORRTRRULE | RECABOOL | CHAR | 1 | 0 | Changed currency tranlation rule |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | REXCCORRINVITEMREF_C | CONDTYPE | TIVCDCONDTYPE | CONDTYPE | REF | C | CN |
2 | REXCCORRINVITEMREF_C | FLOWTYPE | TIVCDFLOWTYPE | FLOWTYPE | REF | C | CN |
3 | REXCCORRINVITEMREF_C | INVGUID | VIRAINV | INVGUID | KEY | 1 | N |
4 | REXCCORRINVITEMREF_C | TAXGROUP | TIVRATAXGROUP | TAXGROUP | REF | 1 | CN |
5 | REXCCORRINVITEMREF_C | TAXTYPE | TIVRATAXTYPE | TAXTYPE | REF | 1 | CN |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in | 605 |