Deprecated
This CDS view is deprecated in S/4HANA. View all deprecated CDS views →

P_InvtryAccountDetermination

DDL: P_INVTRYACCOUNTDETERMINATION SQL: PINVTRYACCDET Type: view CONSUMPTION

Account determination for Inventory

P_InvtryAccountDetermination is a Consumption CDS View that provides data about "Account determination for Inventory" in SAP S/4HANA. It reads from 2 data sources (I_StandardGLAcctDetnRule, I_TransactionTypeStdGLAcct) and exposes 4 fields.

Data Sources (2)

SourceAliasJoin Type
I_StandardGLAcctDetnRule rule left_outer
I_TransactionTypeStdGLAcct type from

Annotations (13)

NameValueLevelField
AbapCatalog.compiler.compareFilter true view
AbapCatalog.sqlViewName PINVTRYACCDET view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Account determination for Inventory view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #X view
VDM.private true view
VDM.viewType #CONSUMPTION view
VDM.lifecycle.status #DEPRECATED view
VDM.lifecycle.successor view

Fields (4)

KeyFieldSource TableSource FieldDescription
ChartOfAccounts I_TransactionTypeStdGLAcct ChartOfAccounts Node Class
ValuationAreaGroup I_TransactionTypeStdGLAcct ValuationAreaGroup Val.Grpg Code
ValuationClass I_TransactionTypeStdGLAcct ValuationClass Valuation Class
GLAccountDetermination I_TransactionTypeStdGLAcct DebitGLAccount G/L Account

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_InvtryAccountDetermination.
-- 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: PINVTRYACCDET

CREATE VIEW P_InvtryAccountDetermination AS
SELECT
  type.ChartOfAccounts AS ChartOfAccounts,
  type.ValuationAreaGroup AS ValuationAreaGroup,
  type.ValuationClass AS ValuationClass,
  type.DebitGLAccount AS GLAccountDetermination
FROM I_TransactionTypeStdGLAcct AS type
LEFT OUTER JOIN I_StandardGLAcctDetnRule AS rule ON /* join condition not captured in parsed metadata */
;