SAP ABAP View FIN_V_ACGRI (View: Line Items in GR/IR Journal)
Hierarchy
☛
SEM-BW (Software Component) SEM-BW: Strategic Enterprise Management
⤷ FIN-BAC-AE (Application Component) Accounting Engine
⤷ FINB_ACC_DOCUMENT (Package) Structue of Accounting Document
⤷ FIN-BAC-AE (Application Component) Accounting Engine
⤷ FINB_ACC_DOCUMENT (Package) Structue of Accounting Document
Basic Data
View Type | D | Database View |
Database View | FIN_V_ACGRI | |
Short Description | View: Line Items in GR/IR Journal | |
Root table | FINACHD | Accounting Document Header |
Table
# | Table Name | Foreign Table | Foreign Field | Foreign DIR |
---|---|---|---|---|
1 | FINACHD | FINACHD | ||
2 | FINACITGRI |
Join Conditions
# | Table Name | Field Name | Negation | Operator | Constants | Cont. line | AND/OR | Offset | F Length | Mco Field |
---|---|---|---|---|---|---|---|---|---|---|
1 | FINACHD | CLIENT | JL | EQ | 0 | 0 | ||||
2 | FINACITGRI | CLIENT | JR | EQ | AND | 0 | 0 | |||
3 | FINACHD | FIN_TECHDOCNO | JL | EQ | 0 | 0 | ||||
4 | FINACITGRI | FIN_TECHDOCNO | JR | EQ | 0 | 0 | ||||
View Fields
# | View field | Table | Field | Maintenance Flag | Key | Data element | Mod | Short Description |
---|---|---|---|---|---|---|---|---|
1 | CLIENT | FINACHD | CLIENT | MANDT | Client | |||
2 | FIN_TECHDOCNO | FINACHD | FIN_TECHDOCNO | FIN_TECHDOCNO | Technical Identifier of a Document | |||
3 | FIN_ITEMNO | FINACITGRI | FIN_ITEMNO | FIN_ITEMNO | Line Item Number | |||
4 | ACC_SYSTEM | FINACHD | ACC_SYSTEM | ACC_SYSTEM | Accounting System | |||
5 | KOKRS | FINACHD | KOKRS | KOKRS | Controlling Area | |||
6 | FIN_COMPANY | FINACHD | FIN_COMPANY | FIN_COMPANY | Company | |||
7 | FIN_FISCYEAR | FINACHD | FIN_FISCYEAR | FIN_FISCYEAR | Fiscal Year | |||
8 | FIN_DOCTYPE | FINACHD | FIN_DOCTYPE | FIN_DOCTYPE | Document Type | |||
9 | FIN_ACCDOCNO | FINACHD | FIN_ACCDOCNO | FIN_ACCDOCNO | Document Number | |||
10 | FIN_CHOFACCT | FINACHD | FIN_CHOFACCT | FIN_CHOFACCT | Chart of Accounts | |||
11 | FIN_HDRTEXT | FINACHD | FIN_HDRTEXT | FIN_HDRTEXT | Document Header Text | |||
12 | FIN_REFDOCNO | FINACHD | FIN_REFDOCNO | FIN_REFDOCNO | Reference Document Number | |||
13 | FIN_POSTDAT | FINACHD | FIN_POSTDAT | FIN_POSTDAT | Posting Date | |||
14 | FIN_DOCDAT | FINACHD | FIN_DOCDAT | FIN_DOCDAT | Document Date | |||
15 | FIN_VALUATDAT | FINACHD | FIN_VALUATDAT | FIN_VALUATDAT | Key Date for Valuation of Business Transaction | |||
16 | FINB_SND_ID | FINACHD | FINB_SND_ID | FINB_SND_ID | Sender Identification | |||
17 | FINB_SNDKEY | FINACHD | FINB_SNDKEY | FINB_SNDKEY | Document Key of the Sending System | |||
18 | FIN_REVTYPE | FINACHD | FIN_REVTYPE | FIN_REVTYPE | Reversal Type | |||
19 | FIN_REVIND | FINACHD | FIN_REVIND | FIN_REVIND | Reversal Indicator | |||
20 | FIN_REVDAT | FINACHD | FIN_REVDAT | FIN_REVDAT | Reversal Date | |||
21 | FIN_REVFISCYEAR | FINACHD | FIN_REVFISCYEAR | FIN_REVFISCYEAR | Fiscal Year of Reversed Document | |||
22 | FIN_REVDOCNO | FINACHD | FIN_REVDOCNO | FIN_REVDOCNO | Reversed Document | |||
23 | FIN_REVTECHDOCNO | FINACHD | FIN_REVTECHDOCNO | FIN_REVTECHDOCNO | Technical Identifier of Reversed Document | |||
24 | FIN_FISCYEARVAR | FINACHD | FIN_FISCYEARVAR | FIN_FISCYEARVAR | Fiscal Year Variant | |||
25 | FIN_FISCPER | FINACHD | FIN_FISCPER | FIN_FISCPER | Fiscal Period | |||
26 | FIN_FISCYEARPER | FINACHD | FIN_FISCYEARPER | FIN_FISCYEARPER | Fiscal Year and Period | |||
27 | FIN_CURRCONVDAT | FINACHD | FIN_CURRCONVDAT | FIN_CURRCONVDAT | Date of Translation of Transaction Currency into Local | |||
28 | FIN_CLOSESTEP | FINACHD | FIN_CLOSESTEP | FIN_CLOSESTEP | Closing Phase | |||
29 | FIN_REVALIND | FINACHD | FIN_REVALIND | FIN_REVALIND | Indicator for Revaluation Documents | |||
30 | FIN_BTATYPE | FINACHD | FIN_BTATYPE | FIN_BTATYPE | Business Transaction Category | |||
31 | /EACC/BTA_NAME | FINACHD | /EACC/BTA_NAME | /EACC/BTA_NAME | Business Transaction Name | |||
32 | UNAME | FINACHD | UNAME | UNAME | User Name | |||
33 | DATUM | FINACHD | DATUM | DATUM | Date | |||
34 | UZEIT | FINACHD | UZEIT | UZEIT | Time | |||
35 | TIMESTAMPL | FINACHD | TIMESTAMPL | TIMESTAMPL | UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) | |||
36 | SAPRL | FINACHD | SAPRL | SAPRL | SAP Release | |||
37 | FIN_TRANCHE | FINACHD | FIN_TRANCHE | FIN_TRANCHE | Tranche | |||
38 | FIN_EEW_ACHD | FINACHD | FIN_EEW_ACHD | DUMMY | Dummy function in length 1 | |||
39 | FIN_GLITEMNO | FINACITGRI | FIN_GLITEMNO | FIN_GLITEMNO | Item Number of General Ledger Document | |||
40 | FIN_DRCRIND | FINACITGRI | FIN_DRCRIND | FIN_DRCRIND | Debit/Credit Indicator | |||
41 | FIN_GLACCT | FINACITGRI | FIN_GLACCT | FIN_GLACCT | G/L Account | |||
42 | FIN_GLIND | FINACITGRI | FIN_GLIND | FIN_GLIND | Relevant for General Ledger | |||
43 | FIN_ITEMTEXT | FINACITGRI | FIN_ITEMTEXT | FIN_ITEMTEXT | Document Item Text | |||
44 | FIN_SEGMENT | FINACITGRI | FIN_SEGMENT | FIN_SEGMENT | Segment | |||
45 | FIN_PROFITCTR | FINACITGRI | FIN_PROFITCTR | FIN_PROFITCTR | Profit Center | |||
46 | FIN_FUNCAREA | FINACITGRI | FIN_FUNCAREA | FIN_FUNCAREA | Functional Area | |||
47 | FIN_SEGMENT_P | FINACITGRI | FIN_SEGMENT_P | FIN_SEGMENT_P | Partner Segment | |||
48 | FIN_PROFITCTR_P | FINACITGRI | FIN_PROFITCTR_P | FIN_PROFITCTR_P | Partner Profit Center | |||
49 | FIN_FUNCAREA_P | FINACITGRI | FIN_FUNCAREA_P | FIN_FUNCAREA_P | Partner Functional Area | |||
50 | FIN_AMTTRA | FINACITGRI | FIN_AMTTRA | FIN_AMTTRA | Amount in Transaction Currency | |||
51 | FIN_CURRTRA | FINACITGRI | FIN_CURRTRA | FIN_CURRTRA | Transaction Currency | |||
52 | FIN_AMTCOMP | FINACITGRI | FIN_AMTCOMP | FIN_AMTCOMP | Amount in Local Currency | |||
53 | FIN_CURRCOMP | FINACITGRI | FIN_CURRCOMP | FIN_CURRCOMP | Local Currency | |||
54 | FIN_AMTACCSYS | FINACITGRI | FIN_AMTACCSYS | FIN_AMTACCSYS | Amount in Accounting System Currency | |||
55 | FIN_CURRACCSYS | FINACITGRI | FIN_CURRACCSYS | FIN_CURRACCSYS | Accounting System Currency | |||
56 | FIN_AMTHARD | FINACITGRI | FIN_AMTHARD | FIN_AMTHARD | Amount in Hard Currency | |||
57 | FIN_CURRHARD | FINACITGRI | FIN_CURRHARD | FIN_CURRHARD | Hard Currency | |||
58 | FIN_AMTINDEX | FINACITGRI | FIN_AMTINDEX | FIN_AMTINDEX | Amount in Index-Based Currency | |||
59 | FIN_CURRINDEX | FINACITGRI | FIN_CURRINDEX | FIN_CURRINDEX | Index-Based Currency | |||
60 | FIN_AMTCOMPGLOB | FINACITGRI | FIN_AMTCOMPGLOB | FIN_AMTCOMPGLOB | Amount in Global Company Currency | |||
61 | FIN_CURRCOMPGLOB | FINACITGRI | FIN_CURRCOMPGLOB | FIN_CURRCOMPGLOB | Global Company Currency | |||
62 | FIN_EEW_AMTAMT | FINACITGRI | FIN_EEW_AMTAMT | FIN_EEW_AMT | Extension Include for Additional Currencies | |||
63 | FIN_QTYGL | FINACITGRI | FIN_QTYGL | FIN_QTYGL | Quantity in General Ledger | |||
64 | FIN_UOMGL | FINACITGRI | FIN_UOMGL | FIN_UOMGL | Unit of Measure for General Ledger | |||
65 | FIN_ITEMSIGN | FINACITGRI | FIN_ITEMSIGN | FIN_ITEMSIGN | +/- Sign for a Line Item | |||
66 | FIN_POSTYPE | FINACITGRI | FIN_POSTYPE | FIN_POSTYPE | Item Category | |||
67 | FIN_JOURNAL | FINACITGRI | FIN_JOURNAL | FIN_JOURNAL | Journal | |||
68 | FIN_GLTRATYPE | FINACITGRI | FIN_GLTRATYPE | FIN_GLTRATYPE | Transaction Type for General Ledger | |||
69 | FIN_EEW_ACIT | FINACITGRI | FIN_EEW_ACIT | FIN_EEW_ACIT | Extension Point for Item of ACC Document | |||
70 | FOBJ_TYPE_NAME | FINACITGRI | FOBJ_TYPE_NAME | FOBJ_TYPE_NAME | Name of an Object Type | |||
71 | FOBJ_OBJECT_ID | FINACITGRI | FOBJ_OBJECT_ID | FOBJ_OBJECT_ID | Object ID | |||
72 | FOBJ_TYPE_NAME_P | FINACITGRI | FOBJ_TYPE_NAME_P | FOBJ_TYPE_NAME_P | Name of Partner Object Type | |||
73 | FOBJ_OBJECT_ID_P | FINACITGRI | FOBJ_OBJECT_ID_P | FOBJ_OBJECT_ID_P | Partner Object ID | |||
74 | FIN_QTYVAL | FINACITGRI | FIN_QTYVAL | FIN_QTYVAL | Valuation Quantity | |||
75 | FIN_UOMVAL | FINACITGRI | FIN_UOMVAL | FIN_UOMVAL | Valuation Unit of Measure | |||
76 | FIN_QTYORD | FINACITGRI | FIN_QTYORD | FIN_QTYORD | Quantity in Order Unit | |||
77 | FIN_UOMORD | FINACITGRI | FIN_UOMORD | FIN_UOMORD | Order Unit | |||
78 | FIN_QTYPRC | FINACITGRI | FIN_QTYPRC | FIN_QTYPRC | Purchase Order Price Quantity | |||
79 | FIN_UOMPRC | FINACITGRI | FIN_UOMPRC | FIN_UOMPRC | Order Price Unit | |||
80 | FIN_EEW_ACITGRI | FINACITGRI | FIN_EEW_ACITGRI | FIN_EEW_ACITGRI | Extension Point for LI in GR/IR Journal | |||
81 | FIN_LOCATION | FINACITGRI | FIN_LOCATION | FIN_LOCATION | Location | |||
82 | FIN_EEW_ACITGRIR | FINACITGRI | FIN_EEW_ACITGRIR | FIN_EEW_ACITGRIR | Extension Point for Reporting in GR/IR Journal | |||
83 | FIN_QTYREF | FINACITGRI | FIN_QTYREF | FIN_QTYREF | Quantity in Reference Unit of Measure | |||
84 | FIN_UOMREF | FINACITGRI | FIN_UOMREF | FIN_UOMREF | Reference Unit of Measure | |||
Maintenance Status
read only |
read and change |
Time-dependent views: like U, validity data like ' ' |
read, change, delete and insert |
Delivery Class | ||
Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in | 400 |