R_ProdnOrdConfMatlDocItemTP

DDL: R_PRODNORDCONFMATLDOCITEMTP Type: view_entity TRANSACTIONAL

Production Order Conf Material Document

R_ProdnOrdConfMatlDocItemTP is a Transactional CDS View that provides data about "Production Order Conf Material Document" in SAP S/4HANA. It reads from 1 data source (I_MfgOrderConfMatlDocItem) and exposes 41 fields with key fields ConfirmationGroup, ConfirmationCount, MaterialDocument, MaterialDocumentItem, MaterialDocumentYear. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_MfgOrderConfMatlDocItem I_MfgOrderConfMatlDocItem from

Associations (1)

CardinalityTargetAliasCondition
[0..*] R_ProdnOrderConfBatchCharcTP _ProdnOrderConfBatchCharc

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label Production Order Conf Material Document 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 (41)

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
_ProdnOrdConf _ProdnOrdConf
_Supplier _Supplier
_Customer _Customer
_ProdnOrderConfBatchCharc _ProdnOrderConfBatchCharc
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #REQUIRED
@EndUserText.label: 'Production Order Conf Material Document'
@ObjectModel.usageType: {serviceQuality: #D, sizeCategory: #XL, dataClass: #MIXED}

//@OData.entitySet.name: 'ProdnOrdConfMatlDocItm'


//@VDM.viewType: #COMPOSITE

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


define view entity R_ProdnOrdConfMatlDocItemTP
  as select from I_MfgOrderConfMatlDocItem
  association    to parent R_ProductionOrdConfirmationTP as _ProdnOrdConf on  $projection.ConfirmationGroup = _ProdnOrdConf.ConfirmationGroup
                                                                          and $projection.ConfirmationCount = _ProdnOrdConf.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 R_ProdnOrderConfBatchCharcTP as _ProdnOrderConfBatchCharc              // 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 production order 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.WBSElement,

      _WBSElement.WBSElementExternalID, // New field in CE1905!

      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

      _ProdnOrdConf,
      @Consumption.hidden: true
      _Supplier,
      @Consumption.hidden: true
      _Customer,
      _ProdnOrderConfBatchCharc

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_MFGORDERCONFMATLDOCITEM",
"I_UNITOFMEASURE",
"I_WBSELEMENTBASICDATA"
],
"ASSOCIATED":
[
"I_CUSTOMER",
"I_SUPPLIER",
"R_PRODNORDERCONFBATCHCHARCTP",
"R_PRODUCTIONORDCONFIRMATIONTP"
],
"BASE":
[
"I_MFGORDERCONFMATLDOCITEM"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/