R_MaterialDocItemSerialNoTP

DDL: R_MATERIALDOCITEMSERIALNOTP Type: view_entity TRANSACTIONAL

RAP Matdoc Serialnumbers

R_MaterialDocItemSerialNoTP is a Transactional CDS View that provides data about "RAP Matdoc Serialnumbers" in SAP S/4HANA. It reads from 1 data source (I_SerialNumberMaterialDocument) and exposes 6 fields with key fields SerialNumber, MaterialDocument, MaterialDocumentItem, MaterialDocumentYear. It has 1 association to related views.

1 data source(s) 6 fields

Data Sources (1)

SourceAliasJoin Type
I_SerialNumberMaterialDocument I_SerialNumberMaterialDocument from

Associations (1)

CardinalityTargetAliasCondition
[1..1] R_MaterialDocumentTP _MaterialDocumentHeader $projection.MaterialDocumentYear = _MaterialDocumentHeader.MaterialDocumentYear and $projection.MaterialDocument = _MaterialDocumentHeader.MaterialDocument

Annotations (8)

NameValueLevelField
EndUserText.label RAP Matdoc Serialnumbers view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY SerialNumber SerialNumber
KEY MaterialDocument MaterialDocument
KEY MaterialDocumentItem MaterialDocumentItem
KEY MaterialDocumentYear MaterialDocumentYear
_MaterialDocumentItem _MaterialDocumentItem
_MaterialDocumentHeader _MaterialDocumentHeader 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@EndUserText.label: 'RAP Matdoc Serialnumbers'
@AccessControl: {
                   authorizationCheck: #CHECK,
                   personalData.blocking: #NOT_REQUIRED
                }
@VDM: {
        viewType: #TRANSACTIONAL,
        lifecycle.contract.type: #SAP_INTERNAL_API
      }
@ObjectModel: {
                usageType: {
                             sizeCategory: #XXL,
                             serviceQuality: #C,
                             dataClass:#TRANSACTIONAL
                           }
}
/*+[hideWarning] { "IDS" : [ "KEY_CHECK" ]  } */ /*Material in Key not needed, Materialdocumentitem already provides the Material */
define view entity R_MaterialDocItemSerialNoTP as select from I_SerialNumberMaterialDocument
association to parent R_MaterialDocumentItemTP as _MaterialDocumentItem
  on  $projection.MaterialDocumentYear = _MaterialDocumentItem.MaterialDocumentYear
  and $projection.MaterialDocument     = _MaterialDocumentItem.MaterialDocument
  and $projection.MaterialDocumentItem = _MaterialDocumentItem.MaterialDocumentItem
  association [1..1] to R_MaterialDocumentTP as _MaterialDocumentHeader 
  on  $projection.MaterialDocumentYear = _MaterialDocumentHeader.MaterialDocumentYear
  and $projection.MaterialDocument     = _MaterialDocumentHeader.MaterialDocument
 {
  
  key SerialNumber,
  key MaterialDocument,
  key MaterialDocumentItem,
  key MaterialDocumentYear,
  
  
  _MaterialDocumentItem, // Make association public

  _MaterialDocumentHeader 
}

Learn More