R_ProdnOrdConfMatlDocItemTP
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)
| Source | Alias | Join Type |
|---|---|---|
| I_MfgOrderConfMatlDocItem | I_MfgOrderConfMatlDocItem | from |
Associations (1)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [0..*] | R_ProdnOrderConfBatchCharcTP | _ProdnOrderConfBatchCharc | |
Annotations (9)
| Name | Value | Level | Field |
|---|---|---|---|
| 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)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| 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":""
}
}*/
Learn More
- What Is a CDS View in SAP S/4HANA?
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- CDS View Annotations — A Complete Guide
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA