R_ProcOrdConfMatlDocItemTP

DDL: R_PROCORDCONFMATLDOCITEMTP Type: view_entity TRANSACTIONAL

Process Order Conf Material Document

R_ProcOrdConfMatlDocItemTP is a Transactional CDS View that provides data about "Process Order Conf Material Document" in SAP S/4HANA. It reads from 1 data source (I_MfgOrderConfMatlDocItem) and exposes 40 fields with key fields ConfirmationGroup, ConfirmationCount, MaterialDocument, MaterialDocumentItem, MaterialDocumentYear.

Data Sources (1)

SourceAliasJoin Type
I_MfgOrderConfMatlDocItem I_MfgOrderConfMatlDocItem from

Annotations (9)

NameValueLevelField
EndUserText.label Process Order Conf Material Document 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
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
Metadata.ignorePropagatedAnnotations true view

Fields (40)

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
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
MaterialDocumentItemText MaterialDocumentItemText
EntryUnit EntryUnit
EntryUnitISOCode _EntryUnit UnitOfMeasureISOCode
EntryUnitSAPCode _EntryUnit UnitOfMeasureSAPCode
QuantityInEntryUnit QuantityInEntryUnit
_ProcOrdConf _ProcOrdConf
_Supplier _Supplier
_Customer _Customer
@EndUserText.label: 'Process Order Conf Material Document'
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #REQUIRED

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

@VDM.viewType: #TRANSACTIONAL
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@Metadata.ignorePropagatedAnnotations: true

define view entity R_ProcOrdConfMatlDocItemTP
  as select from I_MfgOrderConfMatlDocItem
  association to parent R_ProcessOrderConfirmationTP 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,
  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

  ManufacturingOrderType                        as OrderType,
  ManufacturingOrder                            as OrderID,
  ManufacturingOrderItem                        as OrderItem,
  ManufacturingOrderCategory,                   // new field in CE2002

  
//Goods Movement Data  

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

  Batch,
  InventoryValuationType,
  GoodsMovementType,
  GoodsMovementRefDocType,
  InventoryUsabilityCode,
  InventorySpecialStockType,
  SalesOrder,
  SalesOrderItem,
  _WBSElement.WBSElementExternalID,
  Supplier,
  Customer,
  ReservationIsFinallyIssued,
  IsCompletelyDelivered,                                                
  ShelfLifeExpirationDate,
  ManufactureDate,
  StorageType,
  StorageBin,

// 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
}
where ManufacturingOrderCategory = '40';
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_MFGORDERCONFMATLDOCITEM",
"I_UNITOFMEASURE",
"I_WBSELEMENTBASICDATA"
],
"ASSOCIATED":
[
"I_CUSTOMER",
"I_SUPPLIER",
"R_PROCESSORDERCONFIRMATIONTP"
],
"BASE":
[
"I_MFGORDERCONFMATLDOCITEM"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/