R_MatlValnInvtryPerFsclPerd

DDL: R_MATLVALNINVTRYPERFSCLPERD Type: view_entity COMPOSITE Package: FINS_ML_VDM

M EXTRACT with references

R_MatlValnInvtryPerFsclPerd is a Composite CDS View that provides data about "M EXTRACT with references" in SAP S/4HANA. It reads from 2 data sources (R_MatlValnInvtryPerFsclPerdBsc, I_Product) and exposes 36 fields with key fields AccountingDocument, GLAccountLineItem, FiscalYearPeriod, Ledger, CompanyCode. Part of development package FINS_ML_VDM.

2 data source(s) 36 fields

Data Sources (2)

SourceAliasJoin Type
R_MatlValnInvtryPerFsclPerdBsc m from
I_Product Product inner

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
AccessControl.personalData.blocking #NOT_REQUIRED view
EndUserText.label M EXTRACT with references view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view

Fields (36)

KeyFieldSource TableSource FieldDescription
KEY AccountingDocument R_MatlValnInvtryPerFsclPerdBsc AccountingDocument
KEY GLAccountLineItem R_MatlValnInvtryPerFsclPerdBsc GLAccountLineItem
KEY FiscalYearPeriod R_MatlValnInvtryPerFsclPerdBsc FiscalYearPeriod
KEY Ledger R_MatlValnInvtryPerFsclPerdBsc Ledger
KEY CompanyCode R_MatlValnInvtryPerFsclPerdBsc CompanyCode
KEY CostEstimate R_MatlValnInvtryPerFsclPerdBsc CostEstimate
Material R_MatlValnInvtryPerFsclPerdBsc Material
InventoryValuationType R_MatlValnInvtryPerFsclPerdBsc InventoryValuationType
ValuationArea R_MatlValnInvtryPerFsclPerdBsc ValuationArea
InvtryValnSpecialStockType R_MatlValnInvtryPerFsclPerdBsc InvtryValnSpecialStockType
SalesOrder R_MatlValnInvtryPerFsclPerdBsc SalesOrder
SalesOrderItem R_MatlValnInvtryPerFsclPerdBsc SalesOrderItem
Supplier R_MatlValnInvtryPerFsclPerdBsc Supplier
WBSElementInternalID R_MatlValnInvtryPerFsclPerdBsc WBSElementInternalID
UnitOfMeasure I_Product BaseUnit
ValuationQuantity R_MatlValnInvtryPerFsclPerdBsc ValuationQuantity
CompanyCodeCurrency curtpH Currency
AmountInCompanyCodeCurrency R_MatlValnInvtryPerFsclPerdBsc AmountInCompanyCodeCurrency
GlobalCurrency curtpK Currency
AmountInGlobalCurrency R_MatlValnInvtryPerFsclPerdBsc AmountInGlobalCurrency
FreeDefinedCurrency1 curtpO Currency
AmountInFreeDefinedCurrency1 R_MatlValnInvtryPerFsclPerdBsc AmountInFreeDefinedCurrency1
FreeDefinedCurrency2 curtpV Currency
AmountInFreeDefinedCurrency2 R_MatlValnInvtryPerFsclPerdBsc AmountInFreeDefinedCurrency2
FreeDefinedCurrency3 curtpB Currency
AmountInFreeDefinedCurrency3 R_MatlValnInvtryPerFsclPerdBsc AmountInFreeDefinedCurrency3
FreeDefinedCurrency4 curtpC Currency
AmountInFreeDefinedCurrency4 R_MatlValnInvtryPerFsclPerdBsc AmountInFreeDefinedCurrency4
FreeDefinedCurrency5 curtpD Currency
AmountInFreeDefinedCurrency5 R_MatlValnInvtryPerFsclPerdBsc AmountInFreeDefinedCurrency5
FreeDefinedCurrency6 curtpE Currency
AmountInFreeDefinedCurrency6 R_MatlValnInvtryPerFsclPerdBsc AmountInFreeDefinedCurrency6
FreeDefinedCurrency7 curtpF Currency
AmountInFreeDefinedCurrency7 R_MatlValnInvtryPerFsclPerdBsc AmountInFreeDefinedCurrency7
FreeDefinedCurrency8 curtpG Currency
AmountInFreeDefinedCurrency8 R_MatlValnInvtryPerFsclPerdBsc AmountInFreeDefinedCurrency8 
@AccessControl.authorizationCheck: #NOT_REQUIRED
@AccessControl.personalData.blocking: #NOT_REQUIRED
@EndUserText.label: 'M EXTRACT with references'
@VDM.viewType: #COMPOSITE
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L
define view entity R_MatlValnInvtryPerFsclPerd
  as select from R_MatlValnInvtryPerFsclPerdBsc as m
    inner join I_Product as Product on m.Material = Product.Product
  
    left outer to one join R_MatlLdgrCrcyTypeMappg  as curtpH  on m.CompanyCode  = curtpH.CompanyCode 
                                                              and m.Ledger       = curtpH.Ledger 
                                                              and curtpH.JrnlEntrItemCrcyRolePosition = 'H'
    left outer to one join R_MatlLdgrCrcyTypeMappg  as  curtpK on m.CompanyCode  = curtpK.CompanyCode
                                                              and m.Ledger       = curtpK.Ledger
                                                              and curtpK.JrnlEntrItemCrcyRolePosition = 'K'
    left outer to one join R_MatlLdgrCrcyTypeMappg  as curtpO  on m.CompanyCode  = curtpO.CompanyCode
                                                              and m.Ledger       = curtpO.Ledger
                                                              and curtpO.JrnlEntrItemCrcyRolePosition = 'O'
    left outer to one join R_MatlLdgrCrcyTypeMappg  as curtpV  on m.CompanyCode  = curtpV.CompanyCode
                                                              and m.Ledger       = curtpV.Ledger
                                                              and curtpV.JrnlEntrItemCrcyRolePosition = 'V'
    left outer to one join R_MatlLdgrCrcyTypeMappg  as curtpB  on m.CompanyCode  = curtpB.CompanyCode
                                                              and m.Ledger       = curtpB.Ledger
                                                              and curtpB.JrnlEntrItemCrcyRolePosition = 'B'
    left outer to one join R_MatlLdgrCrcyTypeMappg  as curtpC  on m.CompanyCode  = curtpC.CompanyCode
                                                              and m.Ledger       = curtpC.Ledger
                                                              and curtpC.JrnlEntrItemCrcyRolePosition = 'C'
    left outer to one join R_MatlLdgrCrcyTypeMappg  as curtpD  on m.CompanyCode  = curtpD.CompanyCode
                                                              and m.Ledger       = curtpD.Ledger
                                                              and curtpD.JrnlEntrItemCrcyRolePosition = 'D'
    left outer to one join R_MatlLdgrCrcyTypeMappg  as curtpE  on m.CompanyCode  = curtpE.CompanyCode
                                                              and m.Ledger       = curtpE.Ledger
                                                              and curtpE.JrnlEntrItemCrcyRolePosition = 'E'
    left outer to one join R_MatlLdgrCrcyTypeMappg  as curtpF  on m.CompanyCode  = curtpF.CompanyCode
                                                              and m.Ledger       = curtpF.Ledger
                                                              and curtpE.JrnlEntrItemCrcyRolePosition = 'F'
    left outer to one join R_MatlLdgrCrcyTypeMappg  as curtpG  on m.CompanyCode  = curtpG.CompanyCode
                                                              and m.Ledger       = curtpG.Ledger
                                                              and curtpF.JrnlEntrItemCrcyRolePosition = 'G'
{
  key m.AccountingDocument,
  key m.GLAccountLineItem,
  key m.FiscalYearPeriod, 
  key m.Ledger,
  key m.CompanyCode,
  key m.CostEstimate,
      m.Material,
      m.InventoryValuationType,
      m.ValuationArea,
      m.InvtryValnSpecialStockType,
      m.SalesOrder,
      m.SalesOrderItem,
      m.Supplier,
      m.WBSElementInternalID,

      Product.BaseUnit                                         as UnitOfMeasure,   
      @Semantics.quantity.unitOfMeasure: 'UnitOfMeasure'   
      m.ValuationQuantity,

      curtpH.Currency                                          as CompanyCodeCurrency,
      @Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} }
      m.AmountInCompanyCodeCurrency,

      curtpK.Currency                                          as GlobalCurrency,
      @Semantics: { amount : {currencyCode: 'GlobalCurrency'} }
      m.AmountInGlobalCurrency,

      curtpO.Currency                                          as FreeDefinedCurrency1,
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency1'} }
      m.AmountInFreeDefinedCurrency1,

      curtpV.Currency                                          as FreeDefinedCurrency2,
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency2'} }
      m.AmountInFreeDefinedCurrency2,

      curtpB.Currency                                          as FreeDefinedCurrency3,
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency3'} }
      m.AmountInFreeDefinedCurrency3,

      curtpC.Currency                                          as FreeDefinedCurrency4,
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency4'} }
      m.AmountInFreeDefinedCurrency4,

      curtpD.Currency                                          as FreeDefinedCurrency5,
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency5'} }
      m.AmountInFreeDefinedCurrency5,

      curtpE.Currency                                          as FreeDefinedCurrency6,
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency6'} }
      m.AmountInFreeDefinedCurrency6,

      curtpF.Currency                                          as FreeDefinedCurrency7,
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency7'} }
      m.AmountInFreeDefinedCurrency7,

      curtpG.Currency                                          as FreeDefinedCurrency8,
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency8'} }
      m.AmountInFreeDefinedCurrency8
}

Learn More