A_ProcOrdConfMatlDocItem

DDL: A_PROCORDCONFMATLDOCITEM Type: view_entity COMPOSITE
45 Fields 1 Data Sources 3 Associations

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 45 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 (45)

KeyFieldSource TableSource FieldDescription
KEY ConfirmationGroup MfgOrderConfirmationGroup
KEY ConfirmationCount MfgOrderConfirmation
KEY MaterialDocument MaterialDocument Material Doc.
KEY MaterialDocumentItem MaterialDocumentItem Material Document Item
KEY MaterialDocumentYear MaterialDocumentYear Material Document Year
OrderType ManufacturingOrderType
OrderID ManufacturingOrder Order
OrderItem ManufacturingOrderItem Manufacturing Order Item
ManufacturingOrderCategory ManufacturingOrderCategory
Material Material Vehicle Model
Plant Plant Valuation Area
Reservation Reservation Reservation
ReservationItem ReservationItem Reservation Item
StorageLocation StorageLocation StorageLocation
ProductionSupplyArea
Batch Batch Lot No.
InventoryValuationType InventoryValuationType Valuation Type
GoodsMovementType GoodsMovementType Movement Type
GoodsMovementReasonCode GoodsMovementReasonCode Reason for Mvmt
GoodsMovementRefDocType GoodsMovementRefDocType Reference Doc. Type
InventoryUsabilityCode InventoryUsabilityCode Stock Type
InventorySpecialStockType InventorySpecialStockType Special Stock Type
SalesOrder SalesOrder SD Document
SalesOrderItem SalesOrderItem Sales Order Item
WBSElementExternalID _WBSElement WBSElementExternalID WBS Element External ID
Supplier Supplier Supplier
Customer Customer Sold-to Party
ReservationIsFinallyIssued ReservationIsFinallyIssued Res Final Issue
IsCompletelyDelivered IsCompletelyDelivered Is completely delivered
ShelfLifeExpirationDate ShelfLifeExpirationDate SLED/BBD
ManufactureDate ManufactureDate Date of Manuf.
StorageType StorageType Storage Type
StorageBin StorageBin Storage Bin
EWMWarehouse EWMWarehouse Warehouse No.
EWMStorageBin EWMStorageBin Storage Bin
HandlingUnitExternalID HandlingUnitExternalID Handling Unit
MaterialDocumentItemText MaterialDocumentItemText Text
EntryUnit EntryUnit Unit of Entry
EntryUnitISOCode _EntryUnit UnitOfMeasureISOCode
EntryUnitSAPCode _EntryUnit UnitOfMeasureSAPCode
QuantityInEntryUnit QuantityInEntryUnit Quantity in Unit of Entry
_ProcOrdConf _ProcOrdConf
_Supplier _Supplier
_Customer _Customer
_ProcOrderConfBatchCharc _ProcOrderConfBatchCharc

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view A_ProcOrdConfMatlDocItem.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW A_ProcOrdConfMatlDocItem AS
SELECT
  MfgOrderConfirmationGroup AS ConfirmationGroup,
  MfgOrderConfirmation AS ConfirmationCount,
  MaterialDocument,
  MaterialDocumentItem,
  MaterialDocumentYear,
  ManufacturingOrderType AS OrderType,
  ManufacturingOrder AS OrderID,
  ManufacturingOrderItem AS OrderItem,
  ManufacturingOrderCategory,
  Material,
  Plant,
  Reservation,
  ReservationItem,
  StorageLocation,
  cast( '' as prvbe ) AS ProductionSupplyArea,
  Batch,
  InventoryValuationType,
  GoodsMovementType,
  GoodsMovementReasonCode,
  GoodsMovementRefDocType,
  InventoryUsabilityCode,
  InventorySpecialStockType,
  SalesOrder,
  SalesOrderItem,
  _WBSElement.WBSElementExternalID AS WBSElementExternalID,
  Supplier,
  Customer,
  ReservationIsFinallyIssued,
  IsCompletelyDelivered,
  ShelfLifeExpirationDate,
  ManufactureDate,
  StorageType,
  StorageBin,
  EWMWarehouse,
  EWMStorageBin,
  HandlingUnitExternalID,
  MaterialDocumentItemText,
  EntryUnit,
  _EntryUnit.UnitOfMeasureISOCode AS EntryUnitISOCode,
  _EntryUnit.UnitOfMeasureSAPCode AS EntryUnitSAPCode,
  QuantityInEntryUnit
FROM I_MfgOrderConfMatlDocItem
LEFT OUTER JOIN A_Supplier AS _Supplier ON Supplier = _Supplier.Supplier  -- association [0..1]
LEFT OUTER JOIN A_Customer AS _Customer ON Customer = _Customer.Customer  -- association [0..1]
LEFT OUTER JOIN A_ProcOrderConfBatchCharc AS _ProcOrderConfBatchCharc ON /* condition not available in parsed metadata */  -- association [0..*]
;

Learn More