A_ProcOrdConfMatlDocItem

DDL: A_PROCORDCONFMATLDOCITEM Type: view_entity COMPOSITE

Material Movements for Confirmation

A_ProcOrdConfMatlDocItem is a Composite CDS View that provides data about "Material Movements for Confirmation" in SAP S/4HANA. It reads from 1 data source (I_MfgOrderConfMatlDocItem) and exposes 44 fields with key fields ConfirmationGroup, ConfirmationCount, MaterialDocument, MaterialDocumentItem, MaterialDocumentYear. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_MfgOrderConfMatlDocItem I_MfgOrderConfMatlDocItem from

Associations (3)

CardinalityTargetAliasCondition
[0..1] A_Supplier _Supplier $projection.Supplier = _Supplier.Supplier
[0..1] A_Customer _Customer $projection.Customer = _Customer.Customer
[0..*] A_ProcOrderConfBatchCharc _ProcOrderConfBatchCharc

Annotations (10)

NameValueLevelField
EndUserText.label Material Movements for Confirmation view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
OData.entitySet.name ProcOrdConfMatlDocItm view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
Metadata.ignorePropagatedAnnotations true view

Fields (44)

KeyFieldSource TableSource FieldDescription
KEY ConfirmationGroup MfgOrderConfirmationGroup
KEY ConfirmationCount MfgOrderConfirmation
KEY MaterialDocument MaterialDocument
KEY MaterialDocumentItem MaterialDocumentItem
KEY MaterialDocumentYear MaterialDocumentYear
OrderType ManufacturingOrderType
OrderID ManufacturingOrder
OrderItem ManufacturingOrderItem
ManufacturingOrderCategory ManufacturingOrderCategory
Material Material
Plant Plant
Reservation Reservation
ReservationItem ReservationItem
StorageLocation StorageLocation
ProductionSupplyArea
Batch Batch
InventoryValuationType InventoryValuationType
GoodsMovementType GoodsMovementType
GoodsMovementReasonCode GoodsMovementReasonCode
GoodsMovementRefDocType GoodsMovementRefDocType
InventoryUsabilityCode InventoryUsabilityCode
InventorySpecialStockType InventorySpecialStockType
SalesOrder SalesOrder
SalesOrderItem SalesOrderItem
WBSElementExternalID _WBSElement WBSElementExternalID
Supplier Supplier
Customer Customer
ReservationIsFinallyIssued ReservationIsFinallyIssued
IsCompletelyDelivered IsCompletelyDelivered
ShelfLifeExpirationDate ShelfLifeExpirationDate
ManufactureDate ManufactureDate
StorageType StorageType
StorageBin StorageBin
EWMWarehouse EWMWarehouse
EWMStorageBin EWMStorageBin
MaterialDocumentItemText MaterialDocumentItemText
EntryUnit EntryUnit
EntryUnitISOCode _EntryUnit UnitOfMeasureISOCode
EntryUnitSAPCode _EntryUnit UnitOfMeasureSAPCode
QuantityInEntryUnit QuantityInEntryUnit
_ProcOrdConf _ProcOrdConf
_Supplier _Supplier
_Customer _Customer
_ProcOrderConfBatchCharc _ProcOrderConfBatchCharc
@EndUserText.label: 'Material Movements for Confirmation'
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #REQUIRED

@ObjectModel.usageType: {serviceQuality: #D, sizeCategory: #XL, dataClass: #MIXED}

@OData.entitySet.name: 'ProcOrdConfMatlDocItm'

@VDM.viewType: #COMPOSITE
@VDM.lifecycle.contract.type: #PUBLIC_REMOTE_API
@Metadata.ignorePropagatedAnnotations: true
define view entity A_ProcOrdConfMatlDocItem 
  as select from I_MfgOrderConfMatlDocItem
  association to parent A_ProcOrdConfirmation_2 as _ProcOrdConf on $projection.ConfirmationGroup = _ProcOrdConf.ConfirmationGroup
                                                               and $projection.ConfirmationCount = _ProcOrdConf.ConfirmationCount
  association [0..1] to A_Supplier              as _Supplier    on $projection.Supplier          = _Supplier.Supplier
  association [0..1] to A_Customer              as _Customer    on $projection.Customer          = _Customer.Customer      
  composition [0..*] of A_ProcOrderConfBatchCharc as _ProcOrderConfBatchCharc              // new in CE2102

{

//Key

  key MfgOrderConfirmationGroup                 as ConfirmationGroup, 
  key MfgOrderConfirmation                      as ConfirmationCount,
  @ObjectModel.sapObjectNodeTypeReference: 'MaterialDocument'
  key MaterialDocument,
  key MaterialDocumentItem,
  key MaterialDocumentYear, 

//General remarks

//eTag Field is not necessary in the proessuction orrder confirmation process.

//Same behavior implemented like in the material document.


//Order and Operation Data

  @ObjectModel.sapObjectNodeTypeReference: 'WorkOrderType'
  ManufacturingOrderType                        as OrderType,
  ManufacturingOrder                            as OrderID,
  ManufacturingOrderItem                        as OrderItem,
  @ObjectModel.sapObjectNodeTypeReference: 'ManufacturingOrderCategory'
  ManufacturingOrderCategory,                   // new field in CE2002

  
//Goods Movement Data  

  Material,
  Plant,
  @ObjectModel.sapObjectNodeTypeReference: 'ReservationDocument'
  Reservation,
  ReservationItem,
  @ObjectModel.sapObjectNodeTypeReference: 'StorageLocation'
  StorageLocation,
  cast( '' as prvbe ) as ProductionSupplyArea,     // only needed for create, "write-only"       // New field in CE2008!

  Batch,
  @ObjectModel.sapObjectNodeTypeReference: 'ProductValuationType'
  InventoryValuationType,
  @ObjectModel.sapObjectNodeTypeReference: 'GoodsMovementType'
  GoodsMovementType,
  @ObjectModel.sapObjectNodeTypeReference: 'GoodsMovementReason'
  GoodsMovementReasonCode,
  @ObjectModel.sapObjectNodeTypeReference: 'GoodsMovementReferenceDocType'
  GoodsMovementRefDocType,
  @ObjectModel.sapObjectNodeTypeReference: 'InventoryUsabilityCode'
  InventoryUsabilityCode,
  @ObjectModel.sapObjectNodeTypeReference: 'InventorySpecialStockType'
  InventorySpecialStockType,
  @ObjectModel.sapObjectNodeTypeReference: 'SalesOrder'
  SalesOrder,
  SalesOrderItem,
  _WBSElement.WBSElementExternalID,
  Supplier,
  Customer,
  ReservationIsFinallyIssued,
  IsCompletelyDelivered,                                                
  ShelfLifeExpirationDate,
  ManufactureDate,
  StorageType,
  StorageBin,
  
// EWM Data

  @ObjectModel.sapObjectNodeTypeReference: 'Warehouse'
  EWMWarehouse,
  @ObjectModel.sapObjectNodeTypeReference: 'WarehouseStorageBin'
  EWMStorageBin,

// Text

  MaterialDocumentItemText,

//Quantities and UoM

  EntryUnit,
  _EntryUnit.UnitOfMeasureISOCode               as EntryUnitISOCode,                  // New field in CE2002!

  _EntryUnit.UnitOfMeasureSAPCode               as EntryUnitSAPCode,                  // CE2102 

  @Semantics.quantity.unitOfMeasure: 'EntryUnit'
  QuantityInEntryUnit,
 
//Associations

  _ProcOrdConf,
  @Consumption.hidden: true 
  _Supplier,
  @Consumption.hidden: true 
  _Customer,
  _ProcOrderConfBatchCharc
}
where ManufacturingOrderCategory = '40';
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_MFGORDERCONFMATLDOCITEM",
"I_UNITOFMEASURE",
"I_WBSELEMENTBASICDATA"
],
"ASSOCIATED":
[
"A_CUSTOMER",
"A_PROCORDCONFIRMATION_2",
"A_PROCORDERCONFBATCHCHARC",
"A_SUPPLIER"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/