I_GLAcctCOGSSplitTargetAcct

DDL: I_GLACCTCOGSSPLITTARGETACCT SQL: IGLACCTCOGSACCT Type: view COMPOSITE

Map G/L Account to COGS Split Target Account

I_GLAcctCOGSSplitTargetAcct is a Composite CDS View that provides data about "Map G/L Account to COGS Split Target Account" in SAP S/4HANA. It reads from 2 data sources (P_DefaultCOGSSplitTargetAcct, P_GLAcctCOGSSplitTargetAcct) and exposes 13 fields with key fields GLAccount, ChartOfAccounts, CostComponentStructure, COGSSplitProfile, COGSSplitSourceAccount.

Data Sources (2)

SourceAliasJoin Type
P_DefaultCOGSSplitTargetAcct P_DefaultCOGSSplitTargetAcct union
P_GLAcctCOGSSplitTargetAcct P_GLAcctCOGSSplitTargetAcct from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName IGLACCTCOGSACCT view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #MANDATORY view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.serviceQuality #C view
EndUserText.label Map G/L Account to COGS Split Target Account view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY GLAccount P_GLAcctCOGSSplitTargetAcct GLAccount General Ledger
KEY ChartOfAccounts P_GLAcctCOGSSplitTargetAcct ChartOfAccounts Node Class
KEY CostComponentStructure P_GLAcctCOGSSplitTargetAcct CostComponentStructure
KEY COGSSplitProfile P_GLAcctCOGSSplitTargetAcct COGSSplitProfile
KEY COGSSplitSourceAccount P_GLAcctCOGSSplitTargetAcct COGSSplitSourceAccount
KEY COGSSplitStrategy P_GLAcctCOGSSplitTargetAcct COGSSplitStrategy
GLAccount General Ledger
KEY ChartOfAccounts P_DefaultCOGSSplitTargetAcct ChartOfAccounts Node Class
KEY CostComponentStructure P_DefaultCOGSSplitTargetAcct CostComponentStructure
KEY COGSSplitProfile P_DefaultCOGSSplitTargetAcct COGSSplitProfile
KEY COGSSplitSourceAccount P_DefaultCOGSSplitTargetAcct COGSSplitSourceAccount
KEY COGSSplitStrategy P_DefaultCOGSSplitTargetAcct COGSSplitStrategy
COGSSplitTargetAccount P_DefaultCOGSSplitTargetAcct COGSSplitTargetAccount

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_GLAcctCOGSSplitTargetAcct.
-- 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: IGLACCTCOGSACCT

CREATE VIEW I_GLAcctCOGSSplitTargetAcct AS
SELECT
  P_GLAcctCOGSSplitTargetAcct.GLAccount AS GLAccount,
  P_GLAcctCOGSSplitTargetAcct.ChartOfAccounts AS ChartOfAccounts,
  P_GLAcctCOGSSplitTargetAcct.CostComponentStructure AS CostComponentStructure,
  P_GLAcctCOGSSplitTargetAcct.COGSSplitProfile AS COGSSplitProfile,
  P_GLAcctCOGSSplitTargetAcct.COGSSplitSourceAccount AS COGSSplitSourceAccount,
  P_GLAcctCOGSSplitTargetAcct.COGSSplitStrategy AS COGSSplitStrategy,
  P_DefaultCOGSSplitTargetAcct.COGSSplitTargetAccount AS COGSSplitTargetAccount
FROM P_GLAcctCOGSSplitTargetAcct
-- UNION with additional select branch(es): P_DefaultCOGSSplitTargetAcct
;