C_SalesOrderProductionModelTP

DDL: C_SALESORDERPRODUCTIONMODELTP Type: view_entity CONSUMPTION Package: MPE_PRODUCTION_MODEL_UI
21 Fields 1 Data Sources 1 OData Services

Sales Order Production Model Header

C_SalesOrderProductionModelTP is a Consumption CDS View that provides data about "Sales Order Production Model Header" in SAP S/4HANA. It reads from 1 data source (R_ProductionModelTP) and exposes 21 fields with key field ProductionModelUUID. It is exposed through 1 OData service (UI_SLSORD_PRODNMODEL_MANAGE). Part of development package MPE_PRODUCTION_MODEL_UI.

Data Sources (1)

SourceAliasJoin Type
R_ProductionModelTP R_ProductionModelTP projection

Annotations (9)

NameValueLevelField
EndUserText.label Sales Order Production Model Header view
AccessControl.authorizationCheck #MANDATORY view
VDM.viewType #CONSUMPTION view
ObjectModel.modelingPattern #TRANSACTIONAL_QUERY view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
Metadata.allowExtensions true view
Metadata.ignorePropagatedAnnotations true view

OData Services (1)

ServiceBindingVersionContractRelease
UI_SLSORD_PRODNMODEL_MANAGE UI_SLSORD_PRODNMODEL_MANAGE V4 C1 NOT_RELEASED

Fields (21)

KeyFieldSource TableSource FieldDescription
KEY ProductionModelUUID ProductionModelUUID Prodn Model UUID
ProdnModComplexAssemblyType ProdnModComplexAssemblyType
Material Material Vehicle Model
MaterialName _MaterialText MaterialName Material Description
SalesOrder SalesOrder SD Document
SalesOrderItem SalesOrderItem Sales Order Item
BillOfMaterialVariant BillOfMaterialVariant AlternativeBOM
BillOfMaterialCategory BillOfMaterialCategory BOM category
BillOfMaterialVariantUsage BillOfMaterialVariantUsage Usage
BillOfMaterialVersion BillOfMaterialVersion BOM Version
Plant Plant Valuation Area
PlantName _Plant PlantName Plant Name
BillOfOperationsType BillOfOperationsType Task List Type
BillOfOperationsGroup BillOfOperationsGroup Group
BillOfOperationsVariant BillOfOperationsVariant Group Counter
BillOfOperationsVersion BillOfOperationsVersion Routing Version
ProdnModelCreationDateTime ProdnModelCreationDateTime
ProductionModelCreatedByUser ProductionModelCreatedByUser
ProdnModelChangedDateTime ProdnModelChangedDateTime
ProductionModelChangedByUser ProductionModelChangedByUser
BillOfMaterial BillOfMaterial BOM

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 C_SalesOrderProductionModelTP.
-- 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 C_SalesOrderProductionModelTP AS
SELECT
  ProductionModelUUID,
  ProdnModComplexAssemblyType,
  Material,
  _MaterialText.MaterialName AS MaterialName,
  SalesOrder,
  SalesOrderItem,
  BillOfMaterialVariant,
  BillOfMaterialCategory,
  BillOfMaterialVariantUsage,
  BillOfMaterialVersion,
  Plant,
  _Plant.PlantName AS PlantName,
  BillOfOperationsType,
  BillOfOperationsGroup,
  BillOfOperationsVariant,
  BillOfOperationsVersion,
  ProdnModelCreationDateTime,
  ProductionModelCreatedByUser,
  ProdnModelChangedDateTime,
  ProductionModelChangedByUser,
  BillOfMaterial
FROM R_ProductionModelTP
;

Learn More