I_LEDGERCOMPANYCODECRCYROLES

CDS View
43 Fields 149 CDS Views

Currency Roles for Ledger

I_LEDGERCOMPANYCODECRCYROLES is a CDS View in S/4HANA. Currency Roles for Ledger. It contains 43 fields. 149 CDS views read from this table.

CDS Views using this table (149)

ViewTypeJoinVDMDescription
C_LedgerCompanyCodeCrcyRoles view from CONSUMPTION Currency role info on Ledger and Company Code
FAA_CalctDrvdAreaValnVws view inner Calculate Derived Area Valuation Views
FAA_UPA_MIG_BAL_DOC view_entity inner Asset documents
FAA_UPA_MIG_BAL_ODOC view_entity inner Old asset documents
FAA_UPA_MIG_BAL_PLAN view_entity inner Asset plan values
FAA_UPA_MIG_DA_MATH_FMLA view_entity inner Mathematical formula
FAC_AUDIT_Z3_ASSET_CHGDOC view left_outer Asset Master change document
FAC_AUDIT_Z3_ASSET_MASTER view inner Asset Master
FAC_AUDIT_Z3_BANK_REC_MASTER view inner Bank Account Master Data
FAC_AUDIT_Z3_BILLHDRITEM view inner Billing Document Header & Item
FAC_AUDIT_Z3_Customer_change view left_outer Customer Change Document
FAC_AUDIT_Z3_MATERIAL_CHGDOC view left_outer Material Change Document
FAC_AUDIT_Z3_MATERIAL_ITEM view inner Material items
FAC_AUDIT_Z3_MATERIAL_MASTER view inner Material master
FAC_AUDIT_Z3_PRICEELEMENT view inner Pricing Element
FAC_AUDIT_Z3_PROPOSE_TAX_VIEW view inner Tax Proposal Posting View Based
FAC_AUDIT_Z3_PURCHASEORDERITEM view inner Purchase Order Item
FAC_AUDIT_Z3_SALESHDRITM view inner Sales Document Header & Items
FAC_DART_Z3_AP_LINEITEM view inner Account Payable - Line Items
FAC_DART_Z3_AP_OPENITEM view inner DART Z3 Account Payable - Open Items
FAC_DART_Z3_AR_LINEITEM view inner Account Receivable - Line Items
FAC_DART_Z3_AR_OPENITEM view inner Audit Z3 Account Receivable - Open Items
FAC_DART_Z3_COSTCENTER view inner Cost Center Master Data
FAC_DART_Z3_FISCALVARIANT view inner Fiscal period for variant
FAC_DART_Z3_GL_LEDGER_ITEM view inner Audit Z3 G/L Accounts-Line Items
FAC_DART_Z3_GLACCOUNT_CHGDOC view left_outer G/L account change document
FAC_DART_Z3_JournalEnty_CHGDOC view left_outer Journal Entry Change Document
FAC_DART_Z3_MATLINVTRY_LINEITM view inner Material Inventory Line Item
FAC_DART_Z3_PROFITCENTER view inner Profit Center
FAC_DART_Z3_SALES_LINEITEM view inner Sales Documents - Line Items
FAC_DART_Z3_TAX_LINEITEM view inner Tax - Line Items
FAC_DART_Z3_VNDRCHGDOC view inner Vendor change Document
FAC_DART_Z3_WIP_LINEITEM view inner DART Z3 WIP Line Item
FAC_DART_Z3_WIP_LINEITEM_FP0 view inner DART Z3 WIP Line Item
fiscds_rldnr_vh view from Currencies for company Code and ledger
I_ActualAssetBalWithTmpPlanVal view_entity left_outer COMPOSITE Actual asset balance with temp. plan values
I_CoCodeLedgerSourceLedger view_entity from BASIC Company Code Assignment of Ledgers
I_CurrencyTypesCorrespnc view from COMPOSITE Currency Types for Correspondence
I_DeprAreaByCoCodeWithCrcyRole view left_outer COMPOSITE Depreciation Areas of Company Code with Currency Role
I_FiscalCalendarDateForLedger view inner COMPOSITE Fiscal Calendar Dates for Ledger
I_FixedAssetPlanValue view inner BASIC Fixed Asset Plan Values
I_FixedAssetTmpPlanVal view inner BASIC Fixed Asset Temporary Plan Values
I_FixedAssetValue view inner COMPOSITE I_FixedAssetValue
I_FixedAssetValueForToFsclPerd view inner COMPOSITE Fixed Asset Values
I_FixedAssetValWithTmpPlanVal view left_outer COMPOSITE Fixed Asset values with temp. plan values
I_FsclDateFuncRangeFiscalValue view inner COMPOSITE Fiscal Time Ranges for Range of Fiscal Date Function
I_FsclDateFuncRangeForLedger view inner COMPOSITE Fiscal Date Function for Ledger
I_FxdAstLineItemWithCrcyRole view inner COMPOSITE Fixed Asset Line Items with currency role
I_JVADefaultFundCrcy view inner COMPOSITE JVA Default Funding Currencies
I_JVAFundCrcyByLoclCrcy view inner COMPOSITE JVA Funding Currencies by local currency
I_LdgrCoCodeCrcyRolesStdVH view from COMPOSITE Currency Roles for Ledger
I_LdgrCompanyCodeCurrencyRole view_entity from COMPOSITE Currency Role in Ledger and Company Code
I_LdgrCompanyCodeCurrencyRole view_entity union_all COMPOSITE Currency Role in Ledger and Company Code
I_LedgerCoCode view from COMPOSITE Company Code Settings for Ledger
I_LedgerCompanyCodeCrcyRoleVH view from COMPOSITE Currency Roles for Ledger
I_LedgerCompanyCodeVH view from COMPOSITE Company Codes for Ledger
I_RAJournalEntryItem view_entity inner COMPOSITE Revenue Accounting VDM Extending ACDOCA
I_StatementOfChanges view inner COMPOSITE Statement of Changes line items
P_AcctgPrncpGLAccountLineItem view inner BASIC
P_AnalyticalAgingIncrement view from COMPOSITE
P_AssetBalanceCube2 view_entity from COMPOSITE
P_AssetBalanceCube2 view_entity union_all COMPOSITE
P_AssetHistorySheetCube3 view_entity union_all COMPOSITE
P_AssetHistorySheetCube4 view_entity from COMPOSITE
P_AssetLdgrCoCodeCrcyRoles2 view from COMPOSITE
P_AssetLdgrCoCodeCrcyRoles2 view union_all COMPOSITE
P_AstNetBookBalWthAllAreas1 view inner CONSUMPTION
P_BalanceSheetCurrencyRole view from COMPOSITE
P_BalanceSheetCurrencyRole view union_all COMPOSITE
P_CCLdgrShiftedPeriods view inner BASIC
P_CCLdgrShiftedPrevYearPer view inner BASIC
P_CCLdngLdgrPerDates view inner BASIC
P_CCLdngLdgrPeriodDates view inner BASIC
P_CrcyRoleForLedgerCompanyCode view_entity from COMPOSITE Currency Role for Ledger Company Code
P_CrcyRoleForLedgerCompanyCode view_entity union_all COMPOSITE Currency Role for Ledger Company Code
P_CurrencyRoleForCompanyCode view from BASIC
P_CurrencyRoleForCompanyCode view union_all BASIC
P_DrctCarryFwdDeltaPostgByQ view_entity inner COMPOSITE
P_EBCostEstimate view inner COMPOSITE
P_EBOC_ActualCost2 view inner COMPOSITE
P_EBOC_EventBasedVariance2 view inner COMPOSITE
P_EBOC_MaterialCostEstimate2 view inner COMPOSITE
P_EBOC_OrderPlanCost2 view inner COMPOSITE
P_EBOC_PlanCostEstimate2 view inner COMPOSITE
P_EBOC_Variance2 view inner COMPOSITE
P_EBOC_WIP2 view inner COMPOSITE
P_EBOrderActualCost2 view inner COMPOSITE
P_EBOrderPlanCost2 view inner COMPOSITE
P_EBOrderSplitVarianceCost2 view inner COMPOSITE
P_EBOrderVarianceCost2 view inner COMPOSITE
P_EBOrderWIPCost2 view inner COMPOSITE
P_EBPAO_ActualCost view inner COMPOSITE
P_EBPAO_ActualCostDebitKPI2 view inner COMPOSITE
P_EBPAO_ActualCostDebitWC view inner COMPOSITE
P_EBPAO_ActualCostTrend view inner COMPOSITE
P_EBPAO_ActualDebitByCrcyRole view inner COMPOSITE
P_EBPAO_NonJointProdnActlCost view inner COMPOSITE
P_EBPAO_OrdPlanCostByCrcyRole view inner COMPOSITE
P_EBPAO_PCCActlCost view inner COMPOSITE
P_EBPAO_PCCActualCost2 view inner COMPOSITE
P_EBPAO_PCCActualCostDebitKPI2 view inner COMPOSITE
P_EBPAO_PCCActualCostDebitWC2 view inner COMPOSITE
P_EBPAO_PCCActualCostTrend view inner COMPOSITE
P_EBPAO_PCCProductionCost view inner COMPOSITE
P_EBPAO_PlanCost view inner COMPOSITE
P_EBPAO_PlanCostDebitWC view inner COMPOSITE
P_EBPAO_TR_PlanCostDebit view inner COMPOSITE
P_EBPAO_TR_TotalVariance2 view inner COMPOSITE
P_EBPAO_TR_VarianceByType2 view inner COMPOSITE
P_EBPAO_VarianceOverview2 view inner COMPOSITE
P_EBPAO_VarianceTrend2 view inner COMPOSITE
P_EBPAO_WIPOverview2 view inner COMPOSITE
P_EBPAO_WIPTrend2 view inner COMPOSITE
P_EBPC_COGM_ActualCost view inner COMPOSITE
P_EBPCC_ActualCost2 view inner COMPOSITE
P_EBPCC_ActualCost4Info view inner COMPOSITE
P_EBWIP_MaterialCostEstimate2 view inner COMPOSITE
P_EBWIP_ProductionCost2 view inner COMPOSITE
P_EBWIP_WIP2 view inner COMPOSITE
P_FinClsgCurrencyCustomizing view_entity from COMPOSITE
P_FixedAssetDepreciationList2 view_entity from COMPOSITE
P_FixedAssetDepreciationList2 view_entity union_all COMPOSITE
P_FixedAssetTransaction2 view_entity from COMPOSITE
P_GLAcctBalance01 view inner COMPOSITE
P_GLAcctBalbyPeriod01 view_entity inner COMPOSITE
P_IT_StRpFxdAstRegDeprArea view left_outer CONSUMPTION IT FxdAst Reg. - Depr.area at FY per.end
P_LdngLdgrGlobCrcyTranslation view_entity from BASIC
P_LedgerCompanyCode view from BASIC
P_LedgerCompanyCodeCrcyRoles2 view from COMPOSITE
P_LedgerCompanyCodeCrcyRoles2 view union_all COMPOSITE
P_LedgerCompanyCurrencyBranch view from COMPOSITE
P_LedgerCompanyCurrencyBranch view union_all COMPOSITE
P_MfgOrderEvtBsdVariance2 view inner COMPOSITE
P_MfgOrderEvtBsdWIP2 view inner COMPOSITE
P_MfgOrdPlanCost1 view left_outer COMPOSITE
P_MfgOrdPlanCost1V2 view inner COMPOSITE
P_MfgOrdPlanCostByLdgr1V2 view inner COMPOSITE
P_MfgOrdPlanCostByLdgr2V2 view inner COMPOSITE
P_ML_CoCode_Ledger_BCF view_entity from COMPOSITE
P_ML_CoCode_Ledger_BCFW view_entity from COMPOSITE
P_PCCActualCostBYCrcy view_entity inner COMPOSITE
P_PCCCostEstimateItem1V2 view inner COMPOSITE
P_PCCTargetCostByLdgrCrcy view_entity inner COMPOSITE
P_ProcessedImpairmentLineItem view inner COMPOSITE
P_RealTimeMfgOrderPostedKPI view inner COMPOSITE
P_RealTimeMfgOrderToBePostKPI1 view inner COMPOSITE
P_RTPC_REM_OrderPostedKPI view inner COMPOSITE
R_JrnlEntrLdgrCoCodeCrcyRole view_entity from COMPOSITE Ledger Company Code Currency Role for MJE
R_JrnlEntrLdgrCoCodeCrcyRole view_entity union_all COMPOSITE Ledger Company Code Currency Role for MJE

Fields (43)

KeyField CDS FieldsUsed in Views
KEY AccountingPrinciple AccountingPrinciple 12
KEY CompanyCode bukrs,CompanyCode 14
KEY Ledger Ledger,rldnr 14
_AccountingPrinciple _AccountingPrinciple 1
_CoCodeCurrencyRoleCurrency _CoCodeCurrencyRoleCurrency 1
_CompanyCode _CompanyCode 2
_CompanyCodeCurrencyRole _CompanyCodeCurrencyRole 1
_FiscalYearVariant _FiscalYearVariant 1
_FreeDefinedCurrency1Role _FreeDefinedCurrency1Role 1
_FreeDefinedCurrency2Role _FreeDefinedCurrency2Role 1
_FreeDefinedCurrency3Role _FreeDefinedCurrency3Role 1
_FreeDefinedCurrency4Role _FreeDefinedCurrency4Role 1
_FreeDefinedCurrency5Role _FreeDefinedCurrency5Role 1
_FreeDefinedCurrency6Role _FreeDefinedCurrency6Role 1
_FreeDefinedCurrency7Role _FreeDefinedCurrency7Role 1
_FreeDefinedCurrency8Role _FreeDefinedCurrency8Role 1
_FreeDfndCrcyRole1Currency _FreeDfndCrcyRole1Currency 1
_FreeDfndCrcyRole2Currency _FreeDfndCrcyRole2Currency 1
_FreeDfndCrcyRole3Currency _FreeDfndCrcyRole3Currency 1
_FreeDfndCrcyRole4Currency _FreeDfndCrcyRole4Currency 1
_FreeDfndCrcyRole5Currency _FreeDfndCrcyRole5Currency 1
_FreeDfndCrcyRole6Currency _FreeDfndCrcyRole6Currency 1
_FreeDfndCrcyRole7Currency _FreeDfndCrcyRole7Currency 1
_FreeDfndCrcyRole8Currency _FreeDfndCrcyRole8Currency 1
_FunctionalCrcyRoleCurrency _FunctionalCrcyRoleCurrency 1
_FunctionalCurrencyRole _FunctionalCurrencyRole 1
_GlobalCurrencyRole _GlobalCurrencyRole 1
_GlobalCurrencyRoleCurrency _GlobalCurrencyRoleCurrency 1
_Ledger _Ledger 2
AdditionalCurrency1Field AdditionalCurrency1Field 1
AdditionalCurrency2Field AdditionalCurrency2Field 1
CompanyCodeCurrencyRole CompanyCodeCurrencyRole 19
FiscalYearVariant FiscalYearVariant 38
FreeDefinedCurrency1Role FreeDefinedCurrency1Role 19
FreeDefinedCurrency2Role FreeDefinedCurrency2Role 19
FreeDefinedCurrency3Role FreeDefinedCurrency3Role 19
FreeDefinedCurrency4Role FreeDefinedCurrency4Role 19
FreeDefinedCurrency5Role FreeDefinedCurrency5Role 19
FreeDefinedCurrency6Role FreeDefinedCurrency6Role 19
FreeDefinedCurrency7Role FreeDefinedCurrency7Role 19
FreeDefinedCurrency8Role FreeDefinedCurrency8Role 19
FunctionalCurrencyRole FunctionalCurrencyRole 9
GlobalCurrencyRole GlobalCurrencyRole 21

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.

-- Currency Roles for Ledger
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_LEDGERCOMPANYCODECRCYROLES (
    ACCOUNTINGPRINCIPLE,
    COMPANYCODE,
    LEDGER,
    _ACCOUNTINGPRINCIPLE,
    _COCODECURRENCYROLECURRENCY,
    _COMPANYCODE,
    _COMPANYCODECURRENCYROLE,
    _FISCALYEARVARIANT,
    _FREEDEFINEDCURRENCY1ROLE,
    _FREEDEFINEDCURRENCY2ROLE,
    _FREEDEFINEDCURRENCY3ROLE,
    _FREEDEFINEDCURRENCY4ROLE,
    _FREEDEFINEDCURRENCY5ROLE,
    _FREEDEFINEDCURRENCY6ROLE,
    _FREEDEFINEDCURRENCY7ROLE,
    _FREEDEFINEDCURRENCY8ROLE,
    _FREEDFNDCRCYROLE1CURRENCY,
    _FREEDFNDCRCYROLE2CURRENCY,
    _FREEDFNDCRCYROLE3CURRENCY,
    _FREEDFNDCRCYROLE4CURRENCY,
    _FREEDFNDCRCYROLE5CURRENCY,
    _FREEDFNDCRCYROLE6CURRENCY,
    _FREEDFNDCRCYROLE7CURRENCY,
    _FREEDFNDCRCYROLE8CURRENCY,
    _FUNCTIONALCRCYROLECURRENCY,
    _FUNCTIONALCURRENCYROLE,
    _GLOBALCURRENCYROLE,
    _GLOBALCURRENCYROLECURRENCY,
    _LEDGER,
    ADDITIONALCURRENCY1FIELD,
    ADDITIONALCURRENCY2FIELD,
    COMPANYCODECURRENCYROLE,
    FISCALYEARVARIANT,
    FREEDEFINEDCURRENCY1ROLE,
    FREEDEFINEDCURRENCY2ROLE,
    FREEDEFINEDCURRENCY3ROLE,
    FREEDEFINEDCURRENCY4ROLE,
    FREEDEFINEDCURRENCY5ROLE,
    FREEDEFINEDCURRENCY6ROLE,
    FREEDEFINEDCURRENCY7ROLE,
    FREEDEFINEDCURRENCY8ROLE,
    FUNCTIONALCURRENCYROLE,
    GLOBALCURRENCYROLE,
    PRIMARY KEY (ACCOUNTINGPRINCIPLE, COMPANYCODE, LEDGER)
);

Learn More