C_MaterialDocumentSerialNoFDP

DDL: C_MATERIALDOCUMENTSERIALNOFDP Type: view_entity CONSUMPTION Package: APPL_MM_IM_OUTPUT

Material Document Serial Numbers Output Forms

C_MaterialDocumentSerialNoFDP is a Consumption CDS View that provides data about "Material Document Serial Numbers Output Forms" in SAP S/4HANA. It reads from 2 data sources (I_MaintenanceItemObject, I_MaintItmObjListMaterialDoc) and exposes 15 fields with key fields Material, SerialNumber, MaterialDocument, MaterialDocumentItem, MaterialDocumentYear. It has 3 associations to related views. Part of development package APPL_MM_IM_OUTPUT.

2 data source(s) 15 fields

Data Sources (2)

SourceAliasJoin Type
I_MaintenanceItemObject _MaintenanceItemObject inner
I_MaintItmObjListMaterialDoc _SerialMaterialDoc from

Associations (3)

CardinalityTargetAliasCondition
[1..1] I_SerialNumberStockSegment _SerialNumberStockSegment $projection.Material = _SerialNumberStockSegment.Material and $projection.SerialNumber = _SerialNumberStockSegment.SerialNumber association[0..1] to I_MaterialDocumentItem_2 as _MaterialDocumentItem on $projection.MaterialDocument = _MaterialDocumentItem.MaterialDocument and $projection.MaterialDocumentItem = _MaterialDocumentItem.MaterialDocumentItem and $projection.MaterialDocumentYear = _MaterialDocumentItem.MaterialDocumentYear
[1..1] I_Material _Material $projection.Material = _Material.Material
[0..1] I_Equipment _Equipment $projection.Equipment = _Equipment.Equipment

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #CONSUMPTION view
VDM.lifecycle.contract.type #NONE view
Search.searchable true view
EndUserText.label Material Document Serial Numbers Output Forms view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY Material I_MaintenanceItemObject Material
KEY SerialNumber I_MaintenanceItemObject SerialNumber
KEY MaterialDocument I_MaintItmObjListMaterialDoc MaterialDocument
KEY MaterialDocumentItem I_MaintItmObjListMaterialDoc MaterialDocumentItem
KEY MaterialDocumentYear I_MaintItmObjListMaterialDoc MaterialDocumentYear
Equipment I_MaintenanceItemObject Equipment
Plant _MaterialDocumentItem Plant
StorageLocation _MaterialDocumentItem StorageLocation
GoodsMovementType _MaterialDocumentItem GoodsMovementType
PurchaseOrder _MaterialDocumentItem PurchaseOrder
PurchaseOrderItem _MaterialDocumentItem PurchaseOrderItem
_SerialNumberStockSegment _SerialNumberStockSegment
_MaterialDocumentItem _MaterialDocumentItem
_Material _Material
_Equipment _Equipment 
@AccessControl: {
                  authorizationCheck: #CHECK,
                  personalData.blocking: #NOT_REQUIRED
                 }

@ObjectModel: {
                usageType: {
                             sizeCategory: #XL,
                             serviceQuality: #C,
                             dataClass:#TRANSACTIONAL
                           },
                supportedCapabilities: [#CDS_MODELING_ASSOCIATION_TARGET,
                                        #SQL_DATA_SOURCE,
                                        #CDS_MODELING_DATA_SOURCE,
                                        #OUTPUT_FORM_DATA_PROVIDER ]
               }

@VDM: {
        viewType: #CONSUMPTION,
        lifecycle.contract.type: #NONE
      }

@Search.searchable: true
@EndUserText.label: 'Material Document Serial Numbers Output Forms'

define view entity C_MaterialDocumentSerialNoFDP
  as select from I_MaintItmObjListMaterialDoc as _SerialMaterialDoc

    inner join   I_MaintenanceItemObject      as _MaintenanceItemObject on _SerialMaterialDoc.MaintenanceItemObjectList = _MaintenanceItemObject.MaintenanceItemObjectList

  association [1..1] to I_SerialNumberStockSegment as _SerialNumberStockSegment on  $projection.Material     = _SerialNumberStockSegment.Material
                                                                                and $projection.SerialNumber = _SerialNumberStockSegment.SerialNumber
  
  association[0..1] to I_MaterialDocumentItem_2 as _MaterialDocumentItem  on  $projection.MaterialDocument     = _MaterialDocumentItem.MaterialDocument
                                                                          and $projection.MaterialDocumentItem = _MaterialDocumentItem.MaterialDocumentItem
                                                                          and $projection.MaterialDocumentYear = _MaterialDocumentItem.MaterialDocumentYear

  association [1..1] to I_Material               as _Material             on  $projection.Material = _Material.Material

  association [0..1] to I_Equipment              as _Equipment            on  $projection.Equipment = _Equipment.Equipment
{
      @ObjectModel.foreignKey.association: '_Material'
  key _MaintenanceItemObject.Material,
  key _MaintenanceItemObject.SerialNumber,
  key _SerialMaterialDoc.MaterialDocument,
  key _SerialMaterialDoc.MaterialDocumentItem,
  key _SerialMaterialDoc.MaterialDocumentYear,
      @ObjectModel.foreignKey.association: '_Equipment'
      _MaintenanceItemObject.Equipment,
      _MaterialDocumentItem.Plant             as Plant,
      _MaterialDocumentItem.StorageLocation   as StorageLocation,
      _MaterialDocumentItem.GoodsMovementType as GoodsMovementType,
      _MaterialDocumentItem.PurchaseOrder     as PurchaseOrder,
      _MaterialDocumentItem.PurchaseOrderItem as PurchaseOrderItem,

      /* Associations */
      _SerialNumberStockSegment,
      _MaterialDocumentItem,
      _Material,
      _Equipment
}

Learn More