P_TrngSimilarProdnRtgPrpsl

DDL: P_TRNGSIMILARPRODNRTGPRPSL Type: view_entity COMPOSITE Package: PP_MD_SIM_RTG_PRPSL
25 Fields 1 Data Sources

Wrapper View for Training similar routing proposal

P_TrngSimilarProdnRtgPrpsl is a Composite CDS View that provides data about "Wrapper View for Training similar routing proposal" in SAP S/4HANA. It reads from 1 data source (P_TrngSimilarProdnRtgProposal) and exposes 25 fields with key fields BillOfMaterialHeaderUUID, BillOfMaterialVariantUsage, BillOfMaterialCategory, BillOfMaterial, BillOfMaterialVariant. Part of development package PP_MD_SIM_RTG_PRPSL.

Data Sources (1)

SourceAliasJoin Type
P_TrngSimilarProdnRtgProposal P_TrngSimilarProdnRtgProposal from

Annotations (7)

NameValueLevelField
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MASTER view
VDM.viewType #COMPOSITE view
VDM.private true view
AccessControl.authorizationCheck #NOT_REQUIRED view

Fields (25)

KeyFieldSource TableSource FieldDescription
KEY BillOfMaterialHeaderUUID BillOfMaterialHeaderUUID Guid
KEY BillOfMaterialVariantUsage BillOfMaterialVariantUsage Usage
KEY BillOfMaterialCategory BillOfMaterialCategory BOM category
KEY BillOfMaterial BillOfMaterial BOM
KEY BillOfMaterialVariant BillOfMaterialVariant AlternativeBOM
KEY BillOfMaterialVersion BillOfMaterialVersion BOM Version
KEY EngineeringChangeDocument EngineeringChangeDocument Change Number
KEY Material Material Vehicle Model
KEY Plant Plant Valuation Area
KEY ValidityStartDate ValidityStartDate Validity Start Date
ValidityEndDate ValidityEndDate ValidTo
MatFromLotSizeQuantity MatFromLotSizeQuantity From Lot Size
MaterialToLotSizeQuantity MaterialToLotSizeQuantity To Lot Size
BaseUnit BaseUnit Unit of Measure
ProductType ProductType Product Type Group
ProductGroup ProductGroup Product Sold Group
ProductDescription ProductDescription Description
BillOfMaterialComponent BillOfMaterialComponent Component
BillOfMaterialItemQuantity BillOfMaterialItemQuantity Quantity
BOMItemDescription BOMItemDescription Item Text
CompanyCode CompanyCode Receiver Company Code
RecordCreationDate RecordCreationDate Created On
TargetMaterial TargetMaterial
HeaderValidityStartDate HeaderValidityStartDate Valid From
HeaderValidityEndDate HeaderValidityEndDate to

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 P_TrngSimilarProdnRtgPrpsl.
-- 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 P_TrngSimilarProdnRtgPrpsl AS
SELECT
  BillOfMaterialHeaderUUID,
  BillOfMaterialVariantUsage,
  BillOfMaterialCategory,
  BillOfMaterial,
  BillOfMaterialVariant,
  BillOfMaterialVersion,
  EngineeringChangeDocument,
  Material,
  Plant,
  ValidityStartDate,
  ValidityEndDate,
  MatFromLotSizeQuantity,
  MaterialToLotSizeQuantity,
  BaseUnit,
  ProductType,
  ProductGroup,
  ProductDescription,
  BillOfMaterialComponent,
  BillOfMaterialItemQuantity,
  BOMItemDescription,
  CompanyCode,
  RecordCreationDate,
  TargetMaterial,
  HeaderValidityStartDate,
  HeaderValidityEndDate
FROM P_TrngSimilarProdnRtgProposal
;

Learn More