P_FinClsgCurrencyCustomizing

DDL: P_FINCLSGCURRENCYCUSTOMIZING Type: view_entity COMPOSITE
45 Fields 1 Data Sources

P_FinClsgCurrencyCustomizing is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (I_LedgerCompanyCodeCrcyRoles) and exposes 45 fields with key fields Ledger, CompanyCode.

Data Sources (1)

SourceAliasJoin Type
I_LedgerCompanyCodeCrcyRoles functionalcurrencysetting from

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
VDM.private true view
VDM.viewType #COMPOSITE view

Fields (45)

KeyFieldSource TableSource FieldDescription
KEY Ledger I_LedgerCompanyCodeCrcyRoles Ledger Ledger
KEY CompanyCode I_LedgerCompanyCodeCrcyRoles CompanyCode Receiver Company Code
FiscalYearVariant I_LedgerCompanyCodeCrcyRoles FiscalYearVariant FY Variant
CompanyCodeCurrencyRole I_LedgerCompanyCodeCrcyRoles CompanyCodeCurrencyRole
GlobalCurrencyRole I_LedgerCompanyCodeCrcyRoles GlobalCurrencyRole
FreeDefinedCurrency1Role I_LedgerCompanyCodeCrcyRoles FreeDefinedCurrency1Role
FreeDefinedCurrency2Role I_LedgerCompanyCodeCrcyRoles FreeDefinedCurrency2Role
FreeDefinedCurrency3Role I_LedgerCompanyCodeCrcyRoles FreeDefinedCurrency3Role
FreeDefinedCurrency4Role I_LedgerCompanyCodeCrcyRoles FreeDefinedCurrency4Role
FreeDefinedCurrency5Role I_LedgerCompanyCodeCrcyRoles FreeDefinedCurrency5Role
FreeDefinedCurrency6Role I_LedgerCompanyCodeCrcyRoles FreeDefinedCurrency6Role
FreeDefinedCurrency7Role I_LedgerCompanyCodeCrcyRoles FreeDefinedCurrency7Role
FreeDefinedCurrency8Role I_LedgerCompanyCodeCrcyRoles FreeDefinedCurrency8Role
AccountingPrinciple I_LedgerCompanyCodeCrcyRoles AccountingPrinciple AP Ledger/CoCode
FunctionalCurrencyRole I_LedgerCompanyCodeCrcyRoles FunctionalCurrencyRole
AdditionalCurrency1Field I_LedgerCompanyCodeCrcyRoles AdditionalCurrency1Field
AdditionalCurrency2Field I_LedgerCompanyCodeCrcyRoles AdditionalCurrency2Field
SourceCurrencyRole currencysetting SourceCurrencyRole
TargetCurrencyRole currencysetting TargetCurrencyRole
_AccountingPrinciple I_LedgerCompanyCodeCrcyRoles _AccountingPrinciple
_CoCodeCurrencyRoleCurrency I_LedgerCompanyCodeCrcyRoles _CoCodeCurrencyRoleCurrency
_CompanyCode I_LedgerCompanyCodeCrcyRoles _CompanyCode
_CompanyCodeCurrencyRole I_LedgerCompanyCodeCrcyRoles _CompanyCodeCurrencyRole
_FiscalYearVariant I_LedgerCompanyCodeCrcyRoles _FiscalYearVariant
_FreeDefinedCurrency1Role I_LedgerCompanyCodeCrcyRoles _FreeDefinedCurrency1Role
_FreeDefinedCurrency2Role I_LedgerCompanyCodeCrcyRoles _FreeDefinedCurrency2Role
_FreeDefinedCurrency3Role I_LedgerCompanyCodeCrcyRoles _FreeDefinedCurrency3Role
_FreeDefinedCurrency4Role I_LedgerCompanyCodeCrcyRoles _FreeDefinedCurrency4Role
_FreeDefinedCurrency5Role I_LedgerCompanyCodeCrcyRoles _FreeDefinedCurrency5Role
_FreeDefinedCurrency6Role I_LedgerCompanyCodeCrcyRoles _FreeDefinedCurrency6Role
_FreeDefinedCurrency7Role I_LedgerCompanyCodeCrcyRoles _FreeDefinedCurrency7Role
_FreeDefinedCurrency8Role I_LedgerCompanyCodeCrcyRoles _FreeDefinedCurrency8Role
_FreeDfndCrcyRole1Currency I_LedgerCompanyCodeCrcyRoles _FreeDfndCrcyRole1Currency
_FreeDfndCrcyRole2Currency I_LedgerCompanyCodeCrcyRoles _FreeDfndCrcyRole2Currency
_FreeDfndCrcyRole3Currency I_LedgerCompanyCodeCrcyRoles _FreeDfndCrcyRole3Currency
_FreeDfndCrcyRole4Currency I_LedgerCompanyCodeCrcyRoles _FreeDfndCrcyRole4Currency
_FreeDfndCrcyRole5Currency I_LedgerCompanyCodeCrcyRoles _FreeDfndCrcyRole5Currency
_FreeDfndCrcyRole6Currency I_LedgerCompanyCodeCrcyRoles _FreeDfndCrcyRole6Currency
_FreeDfndCrcyRole7Currency I_LedgerCompanyCodeCrcyRoles _FreeDfndCrcyRole7Currency
_FreeDfndCrcyRole8Currency I_LedgerCompanyCodeCrcyRoles _FreeDfndCrcyRole8Currency
_FunctionalCrcyRoleCurrency I_LedgerCompanyCodeCrcyRoles _FunctionalCrcyRoleCurrency
_FunctionalCurrencyRole I_LedgerCompanyCodeCrcyRoles _FunctionalCurrencyRole
_GlobalCurrencyRole I_LedgerCompanyCodeCrcyRoles _GlobalCurrencyRole
_GlobalCurrencyRoleCurrency I_LedgerCompanyCodeCrcyRoles _GlobalCurrencyRoleCurrency
_Ledger I_LedgerCompanyCodeCrcyRoles _Ledger

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view P_FinClsgCurrencyCustomizing.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW P_FinClsgCurrencyCustomizing AS
SELECT
  functionalcurrencysetting.Ledger AS Ledger,
  functionalcurrencysetting.CompanyCode AS CompanyCode,
  functionalcurrencysetting.FiscalYearVariant AS FiscalYearVariant,
  functionalcurrencysetting.CompanyCodeCurrencyRole AS CompanyCodeCurrencyRole,
  functionalcurrencysetting.GlobalCurrencyRole AS GlobalCurrencyRole,
  functionalcurrencysetting.FreeDefinedCurrency1Role AS FreeDefinedCurrency1Role,
  functionalcurrencysetting.FreeDefinedCurrency2Role AS FreeDefinedCurrency2Role,
  functionalcurrencysetting.FreeDefinedCurrency3Role AS FreeDefinedCurrency3Role,
  functionalcurrencysetting.FreeDefinedCurrency4Role AS FreeDefinedCurrency4Role,
  functionalcurrencysetting.FreeDefinedCurrency5Role AS FreeDefinedCurrency5Role,
  functionalcurrencysetting.FreeDefinedCurrency6Role AS FreeDefinedCurrency6Role,
  functionalcurrencysetting.FreeDefinedCurrency7Role AS FreeDefinedCurrency7Role,
  functionalcurrencysetting.FreeDefinedCurrency8Role AS FreeDefinedCurrency8Role,
  functionalcurrencysetting.AccountingPrinciple AS AccountingPrinciple,
  functionalcurrencysetting.FunctionalCurrencyRole AS FunctionalCurrencyRole,
  functionalcurrencysetting.AdditionalCurrency1Field AS AdditionalCurrency1Field,
  functionalcurrencysetting.AdditionalCurrency2Field AS AdditionalCurrency2Field,
  currencysetting.SourceCurrencyRole AS SourceCurrencyRole,
  currencysetting.TargetCurrencyRole AS TargetCurrencyRole,
  functionalcurrencysetting._AccountingPrinciple AS _AccountingPrinciple,
  functionalcurrencysetting._CoCodeCurrencyRoleCurrency AS _CoCodeCurrencyRoleCurrency,
  functionalcurrencysetting._CompanyCode AS _CompanyCode,
  functionalcurrencysetting._CompanyCodeCurrencyRole AS _CompanyCodeCurrencyRole,
  functionalcurrencysetting._FiscalYearVariant AS _FiscalYearVariant,
  functionalcurrencysetting._FreeDefinedCurrency1Role AS _FreeDefinedCurrency1Role,
  functionalcurrencysetting._FreeDefinedCurrency2Role AS _FreeDefinedCurrency2Role,
  functionalcurrencysetting._FreeDefinedCurrency3Role AS _FreeDefinedCurrency3Role,
  functionalcurrencysetting._FreeDefinedCurrency4Role AS _FreeDefinedCurrency4Role,
  functionalcurrencysetting._FreeDefinedCurrency5Role AS _FreeDefinedCurrency5Role,
  functionalcurrencysetting._FreeDefinedCurrency6Role AS _FreeDefinedCurrency6Role,
  functionalcurrencysetting._FreeDefinedCurrency7Role AS _FreeDefinedCurrency7Role,
  functionalcurrencysetting._FreeDefinedCurrency8Role AS _FreeDefinedCurrency8Role,
  functionalcurrencysetting._FreeDfndCrcyRole1Currency AS _FreeDfndCrcyRole1Currency,
  functionalcurrencysetting._FreeDfndCrcyRole2Currency AS _FreeDfndCrcyRole2Currency,
  functionalcurrencysetting._FreeDfndCrcyRole3Currency AS _FreeDfndCrcyRole3Currency,
  functionalcurrencysetting._FreeDfndCrcyRole4Currency AS _FreeDfndCrcyRole4Currency,
  functionalcurrencysetting._FreeDfndCrcyRole5Currency AS _FreeDfndCrcyRole5Currency,
  functionalcurrencysetting._FreeDfndCrcyRole6Currency AS _FreeDfndCrcyRole6Currency,
  functionalcurrencysetting._FreeDfndCrcyRole7Currency AS _FreeDfndCrcyRole7Currency,
  functionalcurrencysetting._FreeDfndCrcyRole8Currency AS _FreeDfndCrcyRole8Currency,
  functionalcurrencysetting._FunctionalCrcyRoleCurrency AS _FunctionalCrcyRoleCurrency,
  functionalcurrencysetting._FunctionalCurrencyRole AS _FunctionalCurrencyRole,
  functionalcurrencysetting._GlobalCurrencyRole AS _GlobalCurrencyRole,
  functionalcurrencysetting._GlobalCurrencyRoleCurrency AS _GlobalCurrencyRoleCurrency,
  functionalcurrencysetting._Ledger AS _Ledger
FROM I_LedgerCompanyCodeCrcyRoles AS functionalcurrencysetting
;

Learn More