A_ProcOrdConfMatlDocItem
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)
| Source | Alias | Join Type |
|---|---|---|
| I_MfgOrderConfMatlDocItem | I_MfgOrderConfMatlDocItem | from |
Associations (3)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [0..1] | A_Supplier | _Supplier | $projection.Supplier = _Supplier.Supplier |
| [0..1] | A_Customer | _Customer | $projection.Customer = _Customer.Customer |
| [0..*] | A_ProcOrderConfBatchCharc | _ProcOrderConfBatchCharc | |
Annotations (10)
| Name | Value | Level | Field |
|---|---|---|---|
| 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)
| 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 | |||
| 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":""
}
}*/
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