I_AROCoCodeAcctgPrinciple

DDL: I_AROCOCODEACCTGPRINCIPLE SQL: IAROCCACCPRN Type: view BASIC Package: ARO_UI_ODATA
5 Fields 1 Data Sources 1 Associations

Company Code to Accntng Principles Map

I_AROCoCodeAcctgPrinciple is a Basic CDS View that provides data about "Company Code to Accntng Principles Map" in SAP S/4HANA. It reads from 1 data source (taro_ap_assgn) and exposes 5 fields with key fields AROAccrualAppComponent, CompanyCode, AROAccountingPrinciple, Ledger. It has 1 association to related views. Part of development package ARO_UI_ODATA.

Data Sources (1)

SourceAliasJoin Type
taro_ap_assgn taro_ap_assgn from

Associations (1)

CardinalityTargetAliasCondition
[1..*] I_AROCoCodeAcctgPrncpMap _AccPrincipleLedger $projection.AROAccountingPrinciple = _AccPrincipleLedger.AROAccountingPrinciple and $projection.CompanyCode = _AccPrincipleLedger.CompanyCode

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName IAROCCACCPRN view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #BASIC view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Company Code to Accntng Principles Map view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY AROAccrualAppComponent component Softw. Comp.
KEY CompanyCode comp_code Procuring Comp. Cde
KEY AROAccountingPrinciple acc_principle Evaluation area EBRR
KEY Ledger _AccPrincipleLedger Ledger Ledger
_AccPrincipleLedger _AccPrincipleLedger

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 I_AROCoCodeAcctgPrinciple.
-- 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.
-- SQL view name: IAROCCACCPRN

CREATE VIEW I_AROCoCodeAcctgPrinciple AS
SELECT
  component AS AROAccrualAppComponent,
  comp_code AS CompanyCode,
  acc_principle AS AROAccountingPrinciple,
  _AccPrincipleLedger.Ledger AS Ledger
FROM taro_ap_assgn
LEFT OUTER JOIN I_AROCoCodeAcctgPrncpMap AS _AccPrincipleLedger ON AROAccountingPrinciple = _AccPrincipleLedger.AROAccountingPrinciple AND CompanyCode = _AccPrincipleLedger.CompanyCode  -- association [1..*]
;

Learn More