P_InvtryTransBsdWithMvt

DDL: P_INVTRYTRANSBSDWITHMVT Type: view_entity COMPOSITE Package: FCML4H_DISPLAY

Transactional based inventory with movement

P_InvtryTransBsdWithMvt is a Composite CDS View that provides data about "Transactional based inventory with movement" in SAP S/4HANA. It reads from 3 data sources (I_MaterialDocumentRecord, P_MaterialLedgerDocument, P_MaterialWithActualCosting) and exposes 29 fields with key fields PriceDeterminationControl, CostEstimate, ValuationArea, CurrencyRole, Ledger. Part of development package FCML4H_DISPLAY.

3 data source(s) 29 fields

Data Sources (3)

SourceAliasJoin Type
I_MaterialDocumentRecord MaterialDocument inner
P_MaterialLedgerDocument MaterialLedgerDocument from
P_MaterialWithActualCosting MaterialWithActualCosting inner

Parameters (2)

NameTypeDefault
P_FromFiscalYearPeriod fml_fyearperiod_from
P_ToFiscalYearPeriod fml_fyearperiod_to

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view
VDM.private true view

Fields (29)

KeyFieldSource TableSource FieldDescription
KEY PriceDeterminationControl P_MaterialWithActualCosting PriceDeterminationControl
KEY CostEstimate P_MaterialLedgerDocument CostEstimate
KEY ValuationArea P_MaterialWithActualCosting ValuationArea
KEY CurrencyRole P_MaterialLedgerDocument LedgerValuationCurrencyRole
KEY Ledger P_MaterialLedgerDocument Ledger
KEY MaterialLedgerCategory P_MaterialLedgerDocument categ
KEY MatlLdgrDocIsCostingRelevant P_MaterialLedgerDocument xabr
KEY ProcessCategory P_MaterialLedgerDocument ProcessCategory
KEY MovementType I_MaterialDocumentRecord GoodsMovementType
KEY GLAccount I_MaterialDocumentRecord GLAccount
KEY ProcurementAlternative P_MaterialLedgerDocument ProcurementAlternative
KEY ProductionProcess P_MaterialLedgerDocument ProductionProcess
FiscalYearPeriod P_MaterialLedgerDocument FiscalYearPeriod
Material P_MaterialWithActualCosting Material
InventoryValuationType P_MaterialWithActualCosting InventoryValuationType
SalesOrder P_MaterialWithActualCosting SalesOrder
SalesOrderItem P_MaterialWithActualCosting SalesOrderItem
InventorySpecialStockType P_MaterialWithActualCosting InventorySpecialStockType
Supplier P_MaterialWithActualCosting Supplier
WBSElementExternalID
GoodsMovementTypeName
ValuationQuantity P_MaterialLedgerDocument ValuationQuantity
ValuationQuantityUnit P_MaterialLedgerDocument ValuationQuantityUnit
InventoryAmtInCCCrcy P_MaterialLedgerDocument InventoryAmtInCCCrcy
PriceDifferenceAmtInCCCrcy P_MaterialLedgerDocument PriceDifferenceAmtInCCCrcy
ExchRateDiffAmtInCoCodeCrcy P_MaterialLedgerDocument ExchRateDiffAmtInCoCodeCrcy
Currency P_MaterialLedgerDocument Currency
CompanyCode P_MaterialWithActualCosting CompanyCode
ControllingArea P_MaterialWithActualCosting ControllingArea 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
    serviceQuality: #B,
    sizeCategory: #XXL,
    dataClass: #MIXED
}
@VDM: {
  viewType: #COMPOSITE,
  private: true
}
define view entity P_InvtryTransBsdWithMvt
  with parameters
    P_FromFiscalYearPeriod :fml_fyearperiod_from,
    P_ToFiscalYearPeriod   :fml_fyearperiod_to
  as select from P_MaterialLedgerDocument    as MaterialLedgerDocument
    inner join   P_MaterialWithActualCosting as MaterialWithActualCosting on MaterialLedgerDocument.CostEstimate = MaterialWithActualCosting.CostEstimate
    inner join   I_MaterialDocumentRecord    as MaterialDocument          on  MaterialLedgerDocument.awref  = MaterialDocument.MaterialDocument
                                                                          and MaterialLedgerDocument.aworg  = MaterialDocument.MaterialDocumentYear
                                                                          and MaterialLedgerDocument.awitem = concat(
      '00', MaterialDocument.MaterialDocumentItem
    )
{
  key MaterialWithActualCosting.PriceDeterminationControl                 as PriceDeterminationControl,
  key MaterialLedgerDocument.CostEstimate                                 as CostEstimate,
  key MaterialWithActualCosting.ValuationArea                             as ValuationArea,
  key MaterialLedgerDocument.LedgerValuationCurrencyRole                  as CurrencyRole,
  key MaterialLedgerDocument.Ledger                                       as Ledger,
  key MaterialLedgerDocument.categ                                        as MaterialLedgerCategory,
  key MaterialLedgerDocument.xabr                                         as MatlLdgrDocIsCostingRelevant,
  key MaterialLedgerDocument.ProcessCategory                              as ProcessCategory,
  key MaterialDocument.GoodsMovementType                                  as MovementType,
  key MaterialDocument.GLAccount                                          as GLAccount,
  key MaterialLedgerDocument.ProcurementAlternative                       as ProcurementAlternative,
  key MaterialLedgerDocument.ProductionProcess                            as ProductionProcess,
      MaterialLedgerDocument.FiscalYearPeriod                             as FiscalYearPeriod,
      MaterialWithActualCosting.Material                                  as Material,
      MaterialWithActualCosting.InventoryValuationType                    as InventoryValuationType,
      MaterialWithActualCosting.SalesOrder                                as SalesOrder,
      MaterialWithActualCosting.SalesOrderItem                            as SalesOrderItem,
      MaterialWithActualCosting.InventorySpecialStockType                 as InventorySpecialStockType,
      MaterialWithActualCosting.Supplier                                  as Supplier,
      MaterialWithActualCosting._WBSElementBasicData.WBSElementExternalID as WBSElementExternalID,
      MaterialDocument._GoodsMvtTypeBySpclStkIndT[1: Language = $session.system_language].GoodsMovementTypeName,
      @Semantics.quantity.unitOfMeasure: 'ValuationQuantityUnit'
      MaterialLedgerDocument.ValuationQuantity                            as ValuationQuantity,
      MaterialLedgerDocument.ValuationQuantityUnit                        as ValuationQuantityUnit,
      @Semantics.amount.currencyCode: 'Currency'
      MaterialLedgerDocument.InventoryAmtInCCCrcy                         as InventoryAmtInCCCrcy,
      @Semantics.amount.currencyCode: 'Currency'
      MaterialLedgerDocument.PriceDifferenceAmtInCCCrcy                   as PriceDifferenceAmtInCCCrcy,
      @Semantics.amount.currencyCode: 'Currency'
      MaterialLedgerDocument.ExchRateDiffAmtInCoCodeCrcy                  as ExchRateDiffAmtInCoCodeCrcy,
      MaterialLedgerDocument.Currency                                     as Currency,
      MaterialWithActualCosting.CompanyCode                               as CompanyCode,
      MaterialWithActualCosting.ControllingArea                           as ControllingArea

}
where
       MaterialLedgerDocument.xabr             != 'X'
  and(
       MaterialLedgerDocument.categ            =  'PC'
    or MaterialLedgerDocument.categ            =  'ZU'
    or MaterialLedgerDocument.categ            =  'VP'
    or MaterialLedgerDocument.categ            =  'VN'
  )
  and(
       MaterialLedgerDocument.glvor            =  'RMWA'
    or MaterialLedgerDocument.glvor            =  'RMWE'
    or MaterialLedgerDocument.glvor            =  'RMWF'
    or MaterialLedgerDocument.glvor            =  'RMWI'
    or MaterialLedgerDocument.glvor            =  'RMWL'
    or MaterialLedgerDocument.glvor            =  'RMWQ'
    or MaterialLedgerDocument.glvor            =  'RMRU'
  )
  and  MaterialLedgerDocument.FiscalYearPeriod between $parameters.P_FromFiscalYearPeriod and $parameters.P_ToFiscalYearPeriod

Learn More