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.

2 data source(s) 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
ValuationAreaGroup I_TransactionTypeStdGLAcct ValuationAreaGroup
ValuationClass I_TransactionTypeStdGLAcct ValuationClass
GLAccountDetermination I_TransactionTypeStdGLAcct DebitGLAccount 
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.sqlViewName: 'PINVTRYACCDET'
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Account determination for Inventory'
@Metadata.ignorePropagatedAnnotations:true
@ObjectModel.usageType: { dataClass: #MIXED, sizeCategory: #L, serviceQuality: #X }
@VDM: { private: true, viewType: #CONSUMPTION }
@VDM.lifecycle.status: #DEPRECATED
@VDM.lifecycle.successor: '' 

define view P_InvtryAccountDetermination
  as select from    I_TransactionTypeStdGLAcct as type
    left outer join I_StandardGLAcctDetnRule   as rule on  type.ChartOfAccounts = rule.ChartOfAccounts
                                                       and type.TransactionTypeDetermination = rule.TransactionTypeDetermination
                                                       and (
                                                            ( rule.IsValuationModifRelevant = 'X' ) 
                                                         or ( rule.IsValuationModifRelevant = '' and type.ValuationAreaGroup =  '' ) ) 
                                                       and (
                                                            ( rule.IsValuationClassRelevant =  'X' and type.ValuationClass <> '' )
                                                         or ( rule.IsValuationClassRelevant =  ''  and type.ValuationClass =  '' ) )
{
  type.ChartOfAccounts,
  type.ValuationAreaGroup,
  type.ValuationClass,
  type.DebitGLAccount  as GLAccountDetermination
}
where
  type.TransactionTypeDetermination = 'BSX' and type.GLAcctDetnDifferentiation = ''
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_STANDARDGLACCTDETNRULE",
"I_TRANSACTIONTYPESTDGLACCT"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0
}
}*/

Learn More