I_ProdnOrdConfMatlDocItemTP

DDL: I_PRODNORDCONFMATLDOCITEMTP Type: view_entity TRANSACTIONAL Package: PP_PRODORDCONF_RAP
39 Fields 1 Data Sources

Prodn Order Conf Material Document - TP

I_ProdnOrdConfMatlDocItemTP is a Transactional CDS View that provides data about "Prodn Order Conf Material Document - TP" in SAP S/4HANA. It reads from 1 data source (R_ProdnOrdConfMatlDocItemTP) and exposes 39 fields with key fields ConfirmationGroup, ConfirmationCount, MaterialDocument, MaterialDocumentItem, MaterialDocumentYear. Part of development package PP_PRODORDCONF_RAP.

Data Sources (1)

SourceAliasJoin Type
R_ProdnOrdConfMatlDocItemTP R_ProdnOrdConfMatlDocItemTP projection

Annotations (10)

NameValueLevelField
EndUserText.label Prodn Order Conf Material Document - TP 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.lifecycle.contract.type #PUBLIC_LOCAL_API view
VDM.viewType #TRANSACTIONAL view
ObjectModel.modelingPattern #TRANSACTIONAL_INTERFACE view
Metadata.ignorePropagatedAnnotations true view

Fields (39)

KeyFieldSource TableSource FieldDescription
KEY ConfirmationGroup ConfirmationGroup
KEY ConfirmationCount ConfirmationCount
KEY MaterialDocument MaterialDocument Material Doc.
KEY MaterialDocumentItem MaterialDocumentItem Material Document Item
KEY MaterialDocumentYear MaterialDocumentYear Material Document Year
OrderType OrderType Order Type
OrderID OrderID Order ID
OrderItem OrderItem Manufacturing Order Item
ManufacturingOrderCategory ManufacturingOrderCategory
Material Material Vehicle Model
Plant Plant Valuation Area
Reservation Reservation Reservation
ReservationItem ReservationItem Reservation Item
StorageLocation StorageLocation StorageLocation
ProductionSupplyArea ProductionSupplyArea Supply Area
Batch Batch Lot No.
InventoryValuationType InventoryValuationType Valuation Type
GoodsMovementType GoodsMovementType Movement Type
GoodsMovementRefDocType GoodsMovementRefDocType Reference Doc. Type
InventoryUsabilityCode InventoryUsabilityCode Stock Type
InventorySpecialStockType InventorySpecialStockType Special Stock Type
SalesOrder SalesOrder SD Document
SalesOrderItem SalesOrderItem Sales Order Item
WBSElementExternalID 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
MaterialDocumentItemText MaterialDocumentItemText Text
EntryUnit EntryUnit Unit of Entry
EntryUnitISOCode EntryUnitISOCode
EntryUnitSAPCode EntryUnitSAPCode
QuantityInEntryUnit QuantityInEntryUnit Quantity in Unit of Entry
_Customer _Customer
_Supplier _Supplier

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 I_ProdnOrdConfMatlDocItemTP.
-- 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 I_ProdnOrdConfMatlDocItemTP AS
SELECT
  ConfirmationGroup,
  ConfirmationCount,
  MaterialDocument,
  MaterialDocumentItem,
  MaterialDocumentYear,
  OrderType,
  OrderID,
  OrderItem,
  ManufacturingOrderCategory,
  Material,
  Plant,
  Reservation,
  ReservationItem,
  StorageLocation,
  ProductionSupplyArea,
  Batch,
  InventoryValuationType,
  GoodsMovementType,
  GoodsMovementRefDocType,
  InventoryUsabilityCode,
  InventorySpecialStockType,
  SalesOrder,
  SalesOrderItem,
  WBSElementExternalID,
  Supplier,
  Customer,
  ReservationIsFinallyIssued,
  IsCompletelyDelivered,
  ShelfLifeExpirationDate,
  ManufactureDate,
  StorageType,
  StorageBin,
  MaterialDocumentItemText,
  EntryUnit,
  EntryUnitISOCode,
  EntryUnitSAPCode,
  QuantityInEntryUnit
FROM R_ProdnOrdConfMatlDocItemTP
;

Learn More