I_PL_SAFTMaterialDocItemBasic

DDL: I_PL_SAFTMATERIALDOCITEMBASIC SQL: IPLSAFTMATDOCIB Type: view BASIC

SAF-T PL Material Document Item Basic

I_PL_SAFTMaterialDocItemBasic is a Basic CDS View that provides data about "SAF-T PL Material Document Item Basic" in SAP S/4HANA. It reads from 1 data source (matdoc) and exposes 10 fields with key fields MaterialDocumentRecordType, MaterialDocumentYear, MaterialDocument, MaterialDocumentItem. It has 2 associations to related views.

1 data source(s) 10 fields

Data Sources (1)

SourceAliasJoin Type
matdoc a from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_UnitOfMeasure _MaterialBaseUnit $projection.MaterialBaseUnit = _MaterialBaseUnit.UnitOfMeasure
[0..1] I_Currency _Currency $projection.CompanyCodeCurrency = _Currency.Currency

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IPLSAFTMATDOCIB view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
AccessControl.personalData.blocking #NOT_REQUIRED view
VDM.viewType #BASIC view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label SAF-T PL Material Document Item Basic view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY MaterialDocumentRecordType record_type
KEY MaterialDocumentYear
KEY MaterialDocument mblnr
KEY MaterialDocumentItem
MaterialBaseUnit meins
TotalValStockQuantity lbkum
CompanyCodeCurrency
StockValueInCCCrcy salk3
_MaterialBaseUnit _MaterialBaseUnit
_Currency _Currency 
@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 <> ''

/*+[internal] {
"BASEINFO":
{
"FROM":
[
"MATDOC"
],
"ASSOCIATED":
[
"I_CURRENCY",
"I_UNITOFMEASURE"
],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More