C_MatlProdnModSequenceTP

DDL: C_MATLPRODNMODSEQUENCETP Type: view_entity CONSUMPTION
46 Fields 1 Data Sources

Material Production Model Sequence

C_MatlProdnModSequenceTP is a Consumption CDS View that provides data about "Material Production Model Sequence" in SAP S/4HANA. It reads from 1 data source (R_ProdnModelSequenceTP) and exposes 46 fields with key fields ProductionModelUUID, BillOfOperationsVersion, BillOfOperationsSequence, BOOSqncInternalVersionCounter.

Data Sources (1)

SourceAliasJoin Type
R_ProdnModelSequenceTP R_ProdnModelSequenceTP projection

Annotations (11)

NameValueLevelField
EndUserText.label Material Production Model Sequence view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED 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
UI.headerInfo.typeName Sequence view
UI.headerInfo.typeNamePlural Sequences view
UI.headerInfo.title.value SequenceText view

Fields (46)

KeyFieldSource TableSource FieldDescription
KEY ProductionModelUUID ProductionModelUUID Prodn Model UUID
KEY BillOfOperationsVersion BillOfOperationsVersion Routing Version
KEY BillOfOperationsSequence BillOfOperationsSequence Sequence
KEY BOOSqncInternalVersionCounter BOOSqncInternalVersionCounter Counter
BOOSequenceForEdit BOOSequenceForEdit Sequence
BillOfOperationsType BillOfOperationsType Task List Type
BillOfOperationsGroup BillOfOperationsGroup Group
BillOfOperationsVariant BillOfOperationsVariant Group Counter
IsDeleted IsDeleted TRUE
IsImplicitlyDeleted IsImplicitlyDeleted
BillOfOperationsSequenceCat BillOfOperationsSequenceCat
BOOSequenceCategoryName
SequenceText SequenceText
SequenceSchedulingAlignment SequenceSchedulingAlignment
SequenceSchedulingAlgnmtName _SequenceSchedulingAlgnmtText SequenceSchedulingAlgnmtName
BillOfOperationsRefSequence BillOfOperationsRefSequence
BOOSqncBranchOpInternalID BOOSqncBranchOpInternalID
BOOSqncBranchOperation BOOSqncBranchOperation Branch Operation
BOOSqncReturnOpInternalID BOOSqncReturnOpInternalID
BOOSqncReturnOperation BOOSqncReturnOperation Return Operation
virtualBOOSequenceHasSequencesboole_d
virtualBOOSequenceHasOperationsboole_d
BillOfOperationsUnit BillOfOperationsUnit
MinimumLotSizeQuantity MinimumLotSizeQuantity Min. Lot Size
MaximumLotSizeQuantity MaximumLotSizeQuantity Max. Lot Size
ChangeNumber ChangeNumber Change Number
BillOfMaterialCategory BillOfMaterialCategory BOM category
BillOfMaterialVariantUsage BillOfMaterialVariantUsage Usage
Plant Plant Valuation Area
ValidityStartDate ValidityStartDate Validity Start Date
ValidityEndDate ValidityEndDate ValidTo
CreationDate CreationDate Time Stamp
CreatedByUser CreatedByUser User Name
LastChangeDate LastChangeDate Time Stamp
LastChangedByUser LastChangedByUser User Name
_BillOfOperations _BillOfOperations
_BillOfOperationsGroup _BillOfOperationsGroup
_BillOfOperationsRefSequence _BillOfOperationsRefSequence
_BillOfOperationsSequence _BillOfOperationsSequence
_BillOfOperationsSequenceCat _BillOfOperationsSequenceCat
_BillOfOperationsType _BillOfOperationsType
_BOOOperationsBranchOperation _BOOOperationsBranchOperation
_BOOOperationsReturnOperation _BOOOperationsReturnOperation
_ChangeMaster _ChangeMaster
_SequenceSchedulingAlignment _SequenceSchedulingAlignment
_SequenceSchedulingAlgnmtText _SequenceSchedulingAlgnmtText

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_MatlProdnModSequenceTP.
-- 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_MatlProdnModSequenceTP AS
SELECT
  ProductionModelUUID,
  BillOfOperationsVersion,
  BillOfOperationsSequence,
  BOOSqncInternalVersionCounter,
  BOOSequenceForEdit,
  BillOfOperationsType,
  BillOfOperationsGroup,
  BillOfOperationsVariant,
  IsDeleted,
  IsImplicitlyDeleted,
  BillOfOperationsSequenceCat,
  _BillOfOperationsSequenceCat._Text[1:Language=$session.system_language ].BOOSequenceCategoryName AS BOOSequenceCategoryName,
  SequenceText,
  SequenceSchedulingAlignment,
  _SequenceSchedulingAlgnmtText.SequenceSchedulingAlgnmtName AS SequenceSchedulingAlgnmtName,
  BillOfOperationsRefSequence,
  BOOSqncBranchOpInternalID,
  BOOSqncBranchOperation,
  BOOSqncReturnOpInternalID,
  BOOSqncReturnOperation,
  virtual BOOSequenceHasSequences : boole_d AS virtualBOOSequenceHasSequencesboole_d,
  virtual BOOSequenceHasOperations : boole_d AS virtualBOOSequenceHasOperationsboole_d,
  BillOfOperationsUnit,
  MinimumLotSizeQuantity,
  MaximumLotSizeQuantity,
  ChangeNumber,
  BillOfMaterialCategory,
  BillOfMaterialVariantUsage,
  Plant,
  ValidityStartDate,
  ValidityEndDate,
  CreationDate,
  CreatedByUser,
  LastChangeDate,
  LastChangedByUser
FROM R_ProdnModelSequenceTP
;

Learn More