I_GLACCOUNTITEMCURRENCYROLEC
G/L Account Item By Currency Role - Cube
I_GLACCOUNTITEMCURRENCYROLEC is a CDS View in S/4HANA. G/L Account Item By Currency Role - Cube. It contains 131 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| P_GLAcctItemCurrencyRole | view_entity | from | COMPOSITE | Private View of G/L Account Line Item with Currency Cube |
Fields (131)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | CompanyCode | CompanyCode | 1 |
| KEY | CurrencyRole | CurrencyRole | 1 |
| KEY | FiscalYear | FiscalYear | 1 |
| KEY | JournalEntry | JournalEntry | 1 |
| KEY | Ledger | Ledger | 1 |
| KEY | LedgerGLLineItem | LedgerGLLineItem | 1 |
| KEY | SourceLedger | SourceLedger | 1 |
| _AccountAssignmentType | _AccountAssignmentType | 1 | |
| _AccountingDocumentType | _AccountingDocumentType | 1 | |
| _BalanceTransactionCurrency | _BalanceTransactionCurrency | 1 | |
| _BaseUnit | _BaseUnit | 1 | |
| _BillToParty | _BillToParty | 1 | |
| _BusinessArea | _BusinessArea | 1 | |
| _ChartOfAccounts | _ChartOfAccounts | 1 | |
| _CompanyCode | _CompanyCode | 1 | |
| _CompanyCodeCurrency | _CompanyCodeCurrency | 1 | |
| _ControllingArea | _ControllingArea | 1 | |
| _CostCenter | _CostCenter | 1 | |
| _CostSourceUnit | _CostSourceUnit | 1 | |
| _CurrencyRole | _CurrencyRole | 1 | |
| _Customer | _Customer | 1 | |
| _CustomerGroup | _CustomerGroup | 1 | |
| _CustomerSupplierCountry | _CustomerSupplierCountry | 1 | |
| _DistributionChannel | _DistributionChannel | 1 | |
| _FinancialAccountType | _FinancialAccountType | 1 | |
| _FiscalYear | _FiscalYear | 1 | |
| _FreeDefinedCurrency1 | _FreeDefinedCurrency1 | 1 | |
| _FreeDefinedCurrency2 | _FreeDefinedCurrency2 | 1 | |
| _FreeDefinedCurrency3 | _FreeDefinedCurrency3 | 1 | |
| _FreeDefinedCurrency4 | _FreeDefinedCurrency4 | 1 | |
| _FreeDefinedCurrency5 | _FreeDefinedCurrency5 | 1 | |
| _FreeDefinedCurrency6 | _FreeDefinedCurrency6 | 1 | |
| _FreeDefinedCurrency7 | _FreeDefinedCurrency7 | 1 | |
| _FreeDefinedCurrency8 | _FreeDefinedCurrency8 | 1 | |
| _FunctionalArea | _FunctionalArea | 1 | |
| _FunctionalCurrency | _FunctionalCurrency | 1 | |
| _GLAccountInChartOfAccounts | _GLAccountInChartOfAccounts | 1 | |
| _GlobalCurrency | _GlobalCurrency | 1 | |
| _JournalEntry | _JournalEntry | 1 | |
| _Ledger | _Ledger | 1 | |
| _Order | _Order | 1 | |
| _Plant | _Plant | 1 | |
| _ProfitCenter | _ProfitCenter | 1 | |
| _SalesDistrict | _SalesDistrict | 1 | |
| _SalesDocument | _SalesDocument | 1 | |
| _SalesOrganization | _SalesOrganization | 1 | |
| _Segment | _Segment | 1 | |
| _ServiceDocument | _ServiceDocument | 1 | |
| _ShipToParty | _ShipToParty | 1 | |
| _SoldProduct | _SoldProduct | 1 | |
| _SoldProductGroup | _SoldProductGroup | 1 | |
| _SourceLedger | _SourceLedger | 1 | |
| _Supplier | _Supplier | 1 | |
| _TransactionCurrency | _TransactionCurrency | 1 | |
| AccountAssignment | AccountAssignment | 1 | |
| AccountAssignmentType | AccountAssignmentType | 1 | |
| AccountingDocumentType | AccountingDocumentType | 1 | |
| AmountInBalanceTransacCrcy | AmountInBalanceTransacCrcy | 1 | |
| AmountInCompanyCodeCurrency | AmountInCompanyCodeCurrency | 1 | |
| AmountInCurrencyRoleCurrency | AmountInCurrencyRoleCurrency | 1 | |
| AmountInFreeDefinedCurrency1 | AmountInFreeDefinedCurrency1 | 1 | |
| AmountInFreeDefinedCurrency2 | AmountInFreeDefinedCurrency2 | 1 | |
| AmountInFreeDefinedCurrency3 | AmountInFreeDefinedCurrency3 | 1 | |
| AmountInFreeDefinedCurrency4 | AmountInFreeDefinedCurrency4 | 1 | |
| AmountInFreeDefinedCurrency5 | AmountInFreeDefinedCurrency5 | 1 | |
| AmountInFreeDefinedCurrency6 | AmountInFreeDefinedCurrency6 | 1 | |
| AmountInFreeDefinedCurrency7 | AmountInFreeDefinedCurrency7 | 1 | |
| AmountInFreeDefinedCurrency8 | AmountInFreeDefinedCurrency8 | 1 | |
| AmountInFunctionalCurrency | AmountInFunctionalCurrency | 1 | |
| AmountInGlobalCurrency | AmountInGlobalCurrency | 1 | |
| AmountInTransactionCurrency | AmountInTransactionCurrency | 1 | |
| AssetClass | AssetClass | 1 | |
| BalanceTransactionCurrency | BalanceTransactionCurrency | 1 | |
| BaseUnit | BaseUnit | 1 | |
| BillToParty | BillToParty | 1 | |
| BusinessArea | BusinessArea | 1 | |
| ChartOfAccounts | ChartOfAccounts | 1 | |
| CompanyCodeCurrency | CompanyCodeCurrency | 1 | |
| ControllingArea | ControllingArea | 1 | |
| CostCenter | CostCenter | 1 | |
| CostSourceUnit | CostSourceUnit | 1 | |
| CurrencyField | CurrencyField | 1 | |
| CurrencyRoleCurrency | CurrencyRoleCurrency | 1 | |
| Customer | Customer | 1 | |
| CustomerGroup | CustomerGroup | 1 | |
| CustomerSupplierCountry | CustomerSupplierCountry | 1 | |
| CustomerSupplierIndustry | CustomerSupplierIndustry | 1 | |
| DistributionChannel | DistributionChannel | 1 | |
| FinancialAccountType | FinancialAccountType | 1 | |
| FiscalPeriod | FiscalPeriod | 1 | |
| FixedAmountInCoCodeCrcy | FixedAmountInCoCodeCrcy | 1 | |
| FixedAmountInGlobalCrcy | FixedAmountInGlobalCrcy | 1 | |
| FixedAmountInTransCrcy | FixedAmountInTransCrcy | 1 | |
| FixedQuantity | FixedQuantity | 1 | |
| FreeDefinedCurrency1 | FreeDefinedCurrency1 | 1 | |
| FreeDefinedCurrency2 | FreeDefinedCurrency2 | 1 | |
| FreeDefinedCurrency3 | FreeDefinedCurrency3 | 1 | |
| FreeDefinedCurrency4 | FreeDefinedCurrency4 | 1 | |
| FreeDefinedCurrency5 | FreeDefinedCurrency5 | 1 | |
| FreeDefinedCurrency6 | FreeDefinedCurrency6 | 1 | |
| FreeDefinedCurrency7 | FreeDefinedCurrency7 | 1 | |
| FreeDefinedCurrency8 | FreeDefinedCurrency8 | 1 | |
| FunctionalArea | FunctionalArea | 1 | |
| FunctionalCurrency | FunctionalCurrency | 1 | |
| GLAccount | GLAccount | 1 | |
| GlobalCurrency | GlobalCurrency | 1 | |
| OrderCategory | OrderCategory | 1 | |
| OrderID | OrderID | 1 | |
| OrganizationDivision | OrganizationDivision | 1 | |
| Plant | Plant | 1 | |
| PostingDate | PostingDate | 1 | |
| ProfitCenter | ProfitCenter | 1 | |
| ProjectInternalID | ProjectInternalID | 1 | |
| ProjectNetwork | ProjectNetwork | 1 | |
| Quantity | Quantity | 1 | |
| SalesDistrict | SalesDistrict | 1 | |
| SalesDocument | SalesDocument | 1 | |
| SalesDocumentItem | SalesDocumentItem | 1 | |
| SalesOrganization | SalesOrganization | 1 | |
| Segment | Segment | 1 | |
| ServiceDocument | ServiceDocument | 1 | |
| ServiceDocumentType | ServiceDocumentType | 1 | |
| ShipToParty | ShipToParty | 1 | |
| SoldProduct | SoldProduct | 1 | |
| SoldProductGroup | SoldProductGroup | 1 | |
| SubLedgerAcctLineItemType | SubLedgerAcctLineItemType | 1 | |
| Supplier | Supplier | 1 | |
| TransactionCurrency | TransactionCurrency | 1 | |
| ValuationArea | ValuationArea | 1 | |
| ValuationQuantity | ValuationQuantity | 1 | |
| WBSElementInternalID | WBSElementInternalID | 1 |
Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.
-- G/L Account Item By Currency Role - Cube
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_GLACCOUNTITEMCURRENCYROLEC (
COMPANYCODE,
CURRENCYROLE,
FISCALYEAR,
JOURNALENTRY,
LEDGER,
LEDGERGLLINEITEM,
SOURCELEDGER,
_ACCOUNTASSIGNMENTTYPE,
_ACCOUNTINGDOCUMENTTYPE,
_BALANCETRANSACTIONCURRENCY,
_BASEUNIT,
_BILLTOPARTY,
_BUSINESSAREA,
_CHARTOFACCOUNTS,
_COMPANYCODE,
_COMPANYCODECURRENCY,
_CONTROLLINGAREA,
_COSTCENTER,
_COSTSOURCEUNIT,
_CURRENCYROLE,
_CUSTOMER,
_CUSTOMERGROUP,
_CUSTOMERSUPPLIERCOUNTRY,
_DISTRIBUTIONCHANNEL,
_FINANCIALACCOUNTTYPE,
_FISCALYEAR,
_FREEDEFINEDCURRENCY1,
_FREEDEFINEDCURRENCY2,
_FREEDEFINEDCURRENCY3,
_FREEDEFINEDCURRENCY4,
_FREEDEFINEDCURRENCY5,
_FREEDEFINEDCURRENCY6,
_FREEDEFINEDCURRENCY7,
_FREEDEFINEDCURRENCY8,
_FUNCTIONALAREA,
_FUNCTIONALCURRENCY,
_GLACCOUNTINCHARTOFACCOUNTS,
_GLOBALCURRENCY,
_JOURNALENTRY,
_LEDGER,
_ORDER,
_PLANT,
_PROFITCENTER,
_SALESDISTRICT,
_SALESDOCUMENT,
_SALESORGANIZATION,
_SEGMENT,
_SERVICEDOCUMENT,
_SHIPTOPARTY,
_SOLDPRODUCT,
_SOLDPRODUCTGROUP,
_SOURCELEDGER,
_SUPPLIER,
_TRANSACTIONCURRENCY,
ACCOUNTASSIGNMENT,
ACCOUNTASSIGNMENTTYPE,
ACCOUNTINGDOCUMENTTYPE,
AMOUNTINBALANCETRANSACCRCY,
AMOUNTINCOMPANYCODECURRENCY,
AMOUNTINCURRENCYROLECURRENCY,
AMOUNTINFREEDEFINEDCURRENCY1,
AMOUNTINFREEDEFINEDCURRENCY2,
AMOUNTINFREEDEFINEDCURRENCY3,
AMOUNTINFREEDEFINEDCURRENCY4,
AMOUNTINFREEDEFINEDCURRENCY5,
AMOUNTINFREEDEFINEDCURRENCY6,
AMOUNTINFREEDEFINEDCURRENCY7,
AMOUNTINFREEDEFINEDCURRENCY8,
AMOUNTINFUNCTIONALCURRENCY,
AMOUNTINGLOBALCURRENCY,
AMOUNTINTRANSACTIONCURRENCY,
ASSETCLASS,
BALANCETRANSACTIONCURRENCY,
BASEUNIT,
BILLTOPARTY,
BUSINESSAREA,
CHARTOFACCOUNTS,
COMPANYCODECURRENCY,
CONTROLLINGAREA,
COSTCENTER,
COSTSOURCEUNIT,
CURRENCYFIELD,
CURRENCYROLECURRENCY,
CUSTOMER,
CUSTOMERGROUP,
CUSTOMERSUPPLIERCOUNTRY,
CUSTOMERSUPPLIERINDUSTRY,
DISTRIBUTIONCHANNEL,
FINANCIALACCOUNTTYPE,
FISCALPERIOD,
FIXEDAMOUNTINCOCODECRCY,
FIXEDAMOUNTINGLOBALCRCY,
FIXEDAMOUNTINTRANSCRCY,
FIXEDQUANTITY,
FREEDEFINEDCURRENCY1,
FREEDEFINEDCURRENCY2,
FREEDEFINEDCURRENCY3,
FREEDEFINEDCURRENCY4,
FREEDEFINEDCURRENCY5,
FREEDEFINEDCURRENCY6,
FREEDEFINEDCURRENCY7,
FREEDEFINEDCURRENCY8,
FUNCTIONALAREA,
FUNCTIONALCURRENCY,
GLACCOUNT,
GLOBALCURRENCY,
ORDERCATEGORY,
ORDERID,
ORGANIZATIONDIVISION,
PLANT,
POSTINGDATE,
PROFITCENTER,
PROJECTINTERNALID,
PROJECTNETWORK,
QUANTITY,
SALESDISTRICT,
SALESDOCUMENT,
SALESDOCUMENTITEM,
SALESORGANIZATION,
SEGMENT,
SERVICEDOCUMENT,
SERVICEDOCUMENTTYPE,
SHIPTOPARTY,
SOLDPRODUCT,
SOLDPRODUCTGROUP,
SUBLEDGERACCTLINEITEMTYPE,
SUPPLIER,
TRANSACTIONCURRENCY,
VALUATIONAREA,
VALUATIONQUANTITY,
WBSELEMENTINTERNALID,
PRIMARY KEY (COMPANYCODE, CURRENCYROLE, FISCALYEAR, JOURNALENTRY, LEDGER, LEDGERGLLINEITEM, SOURCELEDGER)
);Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA