I_PL_SAFTMATERIALDOCITEMBASIC

CDS View

SAF-T PL Material Document Item Basic

I_PL_SAFTMATERIALDOCITEMBASIC is a CDS View in S/4HANA. SAF-T PL Material Document Item Basic. 1 CDS views read from this table.

Used by 1 CDS view(s)

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_PL_SAFTMaterialDocumentRecd view inner COMPOSITE SAFT PL Material Document Record 
@AbapCatalog.sqlViewName: 'IPLSAFTMATDOCIB'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@AccessControl.personalData.blocking: #NOT_REQUIRED
@VDM.viewType: #BASIC
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.dataClass:  #MIXED
@ObjectModel.usageType.serviceQuality: #D
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'SAF-T PL Material Document Item Basic'
define view I_PL_SAFTMaterialDocItemBasic
  as select  from matdoc as a

  association [0..1] to I_UnitOfMeasure as _MaterialBaseUnit on $projection.MaterialBaseUnit = _MaterialBaseUnit.UnitOfMeasure
  association [0..1] to I_Currency      as _Currency         on $projection.CompanyCodeCurrency = _Currency.Currency

{
  key record_type as MaterialDocumentRecordType , 
  key cast(mjahr as nsdm_mjahr preserving type)              as MaterialDocumentYear,
  key mblnr                                                  as MaterialDocument,
  key cast(zeile as nsdm_mblpo preserving type)              as MaterialDocumentItem,

      @Semantics.unitOfMeasure: true
      meins                                                  as MaterialBaseUnit,
      @Semantics.quantity.unitOfMeasure: 'MaterialBaseUnit'
      lbkum                                                  as TotalValStockQuantity,
      @Semantics.currencyCode: true
      cast(waers as nsdm_comp_code_currency preserving type) as CompanyCodeCurrency,
      @Semantics.amount.currencyCode: 'CompanyCodeCurrency'
      salk3                                                  as StockValueInCCCrcy,

      _MaterialBaseUnit,
      _Currency
}
where
  a.mblnr <> ''

Learn More