P_SFONonTrcblComponentAssembly

DDL: P_SFONONTRCBLCOMPONENTASSEMBLY Type: view_entity CONSUMPTION Package: MPE_EXEC_COMMON
58 Fields 1 Data Sources 7 Associations

SFI non-traceable Component by Leading RESB

P_SFONonTrcblComponentAssembly is a Consumption CDS View that provides data about "SFI non-traceable Component by Leading RESB" in SAP S/4HANA. It reads from 1 data source (P_SFONonTrcblCompByLdngResv) and exposes 58 fields with key fields Reservation, ReservationItem, RecordType, OpActyNtwkInstance, OpActyNtwkElement. It has 7 associations to related views. Part of development package MPE_EXEC_COMMON.

Data Sources (1)

SourceAliasJoin Type
P_SFONonTrcblCompByLdngResv SFONonTrcblCompByLdngResv from

Associations (7)

CardinalityTargetAliasCondition
[0..1] I_ReservationDocumentHeader _Reservation $projection.Reservation = _Reservation.Reservation
[1..1] I_OpActyNtwkInstance _OpActyNtwkInstance $projection.OpActyNtwkInstance = _OpActyNtwkInstance.OpActyNtwkInstance
[1..1] I_OperationActivityInstance _OperationActivityInstance $projection.OpActyNtwkInstance = _OperationActivityInstance.OpActyNtwkInstance and $projection.OpActyNtwkElement = _OperationActivityInstance.OpActyNtwkElement
[0..1] I_ProductPlantBasic _ProductPlantBasic $projection.Material = _ProductPlantBasic.Product and $projection.Plant = _ProductPlantBasic.Plant
[1..1] I_MatlCompAssembleControl _MatlCompAssembleControl $projection.MatlCompAssembleControl = _MatlCompAssembleControl.MatlCompAssembleControl
[0..1] I_BillOfMaterialItemBasic _BillOfMaterialItemBasic $projection.BillOfMaterialCategory = _BillOfMaterialItemBasic.BillOfMaterialCategory and $projection.BillOfMaterialInternalID = _BillOfMaterialItemBasic.BillOfMaterial and $projection.BOMItem = _BillOfMaterialItemBasic.BillOfMaterialItemNodeNumber and $projection.BOMItemInternalChangeCount = _BillOfMaterialItemBasic.BOMItemInternalChangeCount
[0..1] I_MfgBOMItemWithPhantomHier _MfgBOMItemWithPhantomHier $projection.BillOfMaterialCategory = _MfgBOMItemWithPhantomHier.MfgBillOfMaterialCategory and $projection.BillOfMaterialInternalID = _MfgBOMItemWithPhantomHier.MfgBillOfMaterial and $projection.BillOfMaterialVariant = _MfgBOMItemWithPhantomHier.MfgBillOfMaterialVariant and $projection.BillOfMaterialVersion = _MfgBOMItemWithPhantomHier.MfgBillOfMaterialVersion and $projection.InheritedBOMItemNode = _MfgBOMItemWithPhantomHier.MfgBOMItmInhtdNodeNmbr

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #CONSUMPTION view
VDM.private true view

Fields (58)

KeyFieldSource TableSource FieldDescription
KEY Reservation P_SFONonTrcblCompByLdngResv Reservation Reservation
KEY ReservationItem P_SFONonTrcblCompByLdngResv ReservationItem Reservation Item
KEY RecordType P_SFONonTrcblCompByLdngResv RecordType Reservation Record Type
KEY OpActyNtwkInstance P_SFONonTrcblCompByLdngResv OpActyNtwkInstance Instance ID
KEY OpActyNtwkElement P_SFONonTrcblCompByLdngResv OpActyNtwkElement Element Number
Batch OpActyInstceComponentDetail Batch Lot No.
Material OpActyInstceComponentDetail Material Vehicle Model
Plant OpActyInstceComponentDetail Plant Valuation Area
StorageLocation OpActyInstceComponentDetail StorageLocation StorageLocation
MatlCompIsMarkedForBackflush OpActyInstceComponentDetail MatlCompIsMarkedForBackflush Backflush
IsBulkMaterialComponent OpActyInstceComponentDetail IsBulkMaterialComponent Bulk material
DebitCreditCode OpActyInstceComponentDetail DebitCreditCode Single-Character Flag
RequiredQuantityasRequiredQuantity
RequiredQuantityInBaseUnit OpActyInstceComponentDetail RequiredQuantityInBaseUnit
MaterialComponentQuantity P_SFONonTrcblCompByLdngResv MaterialComponentQuantity
ResvnItmWithdrawnQtyInBaseUnit P_SFONonTrcblCompByLdngResv ResvnItmWithdrawnQtyInBaseUnit Withdrawal Qty
MaterialBaseUnit OpActyInstceComponentDetail BaseUnit Unit of Measure
EntryUnit OpActyInstceComponentDetail EntryUnit Unit of Entry
ManufacturingOrderasManufacturingOrder
ManufacturingOrderOperation
MfgOrderOperationText OpActyInstceComponentDetail MfgOrderOperationText
OrderInternalID OpActyInstceComponentDetail OrderInternalBillOfOperations Order Internal Bill of Operations
OrderOperationInternalID OpActyInstceComponentDetail OrderIntBillOfOperationsItem Order Internal Bill of Operations Item
OpActyNtwkElementExternalID OpActyInstceNtwkElmntBasic OpActyNtwkElementExternalID Op. Activity
OpActyNtwkElementElement OpActyInstceNtwkElmntBasic OpActyNtwkElementElement Operation Activity
OpActyNtwkElementElmntVersCntr OpActyInstceNtwkElmntBasic OpActyNtwkElementElmntVersCntr OA Version
BillOfMaterialCategory OpActyInstceComponentDetail BillOfMaterialCategory BOM category
BillOfMaterialInternalID
BOMItem OpActyInstceComponentDetail BOMItem
BOMItemInternalChangeCount OpActyInstceComponentDetail BOMItemInternalChangeCount Counter
BillOfMaterialVariant OpActyInstceComponentDetail BillOfMaterialVariant AlternativeBOM
BillOfMaterialVersion OpActyInstceComponentDetail BillOfMaterialVersion BOM Version
BOMItemCategory OpActyInstceComponentDetail BOMItemCategory Item Category
InheritedBOMItemNode OpActyInstceComponentDetail InheritedBOMItemNode
EffectivityParameterVariant OpActyInstceComponentDetail EffectivityParameterVariant
InheritedNodeNumberForBOMItem _BillOfMaterialItemBasic InheritedNodeNumberForBOMItem Nodes
InheritedNodeNumberVersionBOM _BillOfMaterialItemBasic InheritedNodeNumberVersionBOM Item node
Assembly OpActyInstceComponentDetail Assembly Pegged Reqmt
FormulaKey OpActyInstceComponentDetail FormulaKey VSI Formula
VariableSizeDimension1 OpActyInstceComponentDetail VariableSizeDimension1 Size 1
VariableSizeDimension2 OpActyInstceComponentDetail VariableSizeDimension2 Size 2
VariableSizeDimension3 OpActyInstceComponentDetail VariableSizeDimension3 Size 3
VariableSizeDimensionUnit OpActyInstceComponentDetail VariableSizeDimensionUnit Size unit
VariableSizeComponentQuantity OpActyInstceComponentDetail VariableSizeComponentQuantity VSI Quantity
VariableSizeComponentUnit OpActyInstceComponentDetail VariableSizeComponentUnit VSI UoM
_Reservation _Reservation
_OpActyNtwkInstance _OpActyNtwkInstance
_OperationActivityInstance _OperationActivityInstance
_ManufacturingOrder OpActyInstceComponentDetail _ManufacturingOrder
_Batch OpActyInstceComponentDetail _Batch
_Material OpActyInstceComponentDetail _Material
_Plant OpActyInstceComponentDetail _Plant
_StorageLocation OpActyInstceComponentDetail _StorageLocation
_ProductPlantBasic _ProductPlantBasic
_MatlCompAssembleControl _MatlCompAssembleControl
_BOMItemCategory OpActyInstceComponentDetail _BOMItemCategory
_OperationActivityText OpActyInstceNtwkElmntBasic _OperationActivityText
_MfgBOMItemWithPhantomHier _MfgBOMItemWithPhantomHier

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_SFONonTrcblComponentAssembly.
-- 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_SFONonTrcblComponentAssembly AS
SELECT
  SFONonTrcblCompByLdngResv.Reservation AS Reservation,
  SFONonTrcblCompByLdngResv.ReservationItem AS ReservationItem,
  SFONonTrcblCompByLdngResv.RecordType AS RecordType,
  SFONonTrcblCompByLdngResv.OpActyNtwkInstance AS OpActyNtwkInstance,
  SFONonTrcblCompByLdngResv.OpActyNtwkElement AS OpActyNtwkElement,
  OpActyInstceComponentDetail.Batch AS Batch,
  OpActyInstceComponentDetail.Material AS Material,
  OpActyInstceComponentDetail.Plant AS Plant,
  OpActyInstceComponentDetail.StorageLocation AS StorageLocation,
  OpActyInstceComponentDetail.MatlCompIsMarkedForBackflush AS MatlCompIsMarkedForBackflush,
  OpActyInstceComponentDetail.IsBulkMaterialComponent AS IsBulkMaterialComponent,
  OpActyInstceComponentDetail.DebitCreditCode AS DebitCreditCode,
  OpActyInstceComponentDetail.RequiredQuantityInBaseUnit AS RequiredQuantityInBaseUnit,
  SFONonTrcblCompByLdngResv.MaterialComponentQuantity AS MaterialComponentQuantity,
  SFONonTrcblCompByLdngResv.ResvnItmWithdrawnQtyInBaseUnit AS ResvnItmWithdrawnQtyInBaseUnit,
  OpActyInstceComponentDetail.BaseUnit AS MaterialBaseUnit,
  OpActyInstceComponentDetail.EntryUnit AS EntryUnit,
  cast(OpActyInstceComponentDetail.ManufacturingOrderOperation as mpe_vornr_char preserving type) AS ManufacturingOrderOperation,
  OpActyInstceComponentDetail.MfgOrderOperationText AS MfgOrderOperationText,
  OpActyInstceComponentDetail.OrderInternalBillOfOperations AS OrderInternalID,
  OpActyInstceComponentDetail.OrderIntBillOfOperationsItem AS OrderOperationInternalID,
  OpActyInstceNtwkElmntBasic.OpActyNtwkElementExternalID AS OpActyNtwkElementExternalID,
  OpActyInstceNtwkElmntBasic.OpActyNtwkElementElement AS OpActyNtwkElementElement,
  OpActyInstceNtwkElmntBasic.OpActyNtwkElementElmntVersCntr AS OpActyNtwkElementElmntVersCntr,
  OpActyInstceComponentDetail.BillOfMaterialCategory AS BillOfMaterialCategory,
  cast( OpActyInstceComponentDetail.BillOfMaterialInternalID as mpe_exec_stnum preserving type ) AS BillOfMaterialInternalID,
  OpActyInstceComponentDetail.BOMItem AS BOMItem,
  OpActyInstceComponentDetail.BOMItemInternalChangeCount AS BOMItemInternalChangeCount,
  OpActyInstceComponentDetail.BillOfMaterialVariant AS BillOfMaterialVariant,
  OpActyInstceComponentDetail.BillOfMaterialVersion AS BillOfMaterialVersion,
  OpActyInstceComponentDetail.BOMItemCategory AS BOMItemCategory,
  OpActyInstceComponentDetail.InheritedBOMItemNode AS InheritedBOMItemNode,
  OpActyInstceComponentDetail.EffectivityParameterVariant AS EffectivityParameterVariant,
  _BillOfMaterialItemBasic.InheritedNodeNumberForBOMItem AS InheritedNodeNumberForBOMItem,
  _BillOfMaterialItemBasic.InheritedNodeNumberVersionBOM AS InheritedNodeNumberVersionBOM,
  OpActyInstceComponentDetail.Assembly AS Assembly,
  OpActyInstceComponentDetail.FormulaKey AS FormulaKey,
  OpActyInstceComponentDetail.VariableSizeDimension1 AS VariableSizeDimension1,
  OpActyInstceComponentDetail.VariableSizeDimension2 AS VariableSizeDimension2,
  OpActyInstceComponentDetail.VariableSizeDimension3 AS VariableSizeDimension3,
  OpActyInstceComponentDetail.VariableSizeDimensionUnit AS VariableSizeDimensionUnit,
  OpActyInstceComponentDetail.VariableSizeComponentQuantity AS VariableSizeComponentQuantity,
  OpActyInstceComponentDetail.VariableSizeComponentUnit AS VariableSizeComponentUnit,
  OpActyInstceComponentDetail._ManufacturingOrder AS _ManufacturingOrder,
  OpActyInstceComponentDetail._Batch AS _Batch,
  OpActyInstceComponentDetail._Material AS _Material,
  OpActyInstceComponentDetail._Plant AS _Plant,
  OpActyInstceComponentDetail._StorageLocation AS _StorageLocation,
  OpActyInstceComponentDetail._BOMItemCategory AS _BOMItemCategory,
  OpActyInstceNtwkElmntBasic._OperationActivityText AS _OperationActivityText
FROM P_SFONonTrcblCompByLdngResv AS SFONonTrcblCompByLdngResv
LEFT OUTER JOIN I_ReservationDocumentHeader AS _Reservation ON Reservation = _Reservation.Reservation  -- association [0..1]
LEFT OUTER JOIN I_OpActyNtwkInstance AS _OpActyNtwkInstance ON OpActyNtwkInstance = _OpActyNtwkInstance.OpActyNtwkInstance  -- association [1..1]
LEFT OUTER JOIN I_OperationActivityInstance AS _OperationActivityInstance ON OpActyNtwkInstance = _OperationActivityInstance.OpActyNtwkInstance AND OpActyNtwkElement = _OperationActivityInstance.OpActyNtwkElement  -- association [1..1]
LEFT OUTER JOIN I_ProductPlantBasic AS _ProductPlantBasic ON Material = _ProductPlantBasic.Product AND Plant = _ProductPlantBasic.Plant  -- association [0..1]
LEFT OUTER JOIN I_MatlCompAssembleControl AS _MatlCompAssembleControl ON MatlCompAssembleControl = _MatlCompAssembleControl.MatlCompAssembleControl  -- association [1..1]
LEFT OUTER JOIN I_BillOfMaterialItemBasic AS _BillOfMaterialItemBasic ON BillOfMaterialCategory = _BillOfMaterialItemBasic.BillOfMaterialCategory AND BillOfMaterialInternalID = _BillOfMaterialItemBasic.BillOfMaterial AND BOMItem = _BillOfMaterialItemBasic.BillOfMaterialItemNodeNumber AND BOMItemInternalChangeCount = _BillOfMaterialItemBasic.BOMItemInternalChangeCount  -- association [0..1]
LEFT OUTER JOIN I_MfgBOMItemWithPhantomHier AS _MfgBOMItemWithPhantomHier ON BillOfMaterialCategory = _MfgBOMItemWithPhantomHier.MfgBillOfMaterialCategory AND BillOfMaterialInternalID = _MfgBOMItemWithPhantomHier.MfgBillOfMaterial AND BillOfMaterialVariant = _MfgBOMItemWithPhantomHier.MfgBillOfMaterialVariant AND BillOfMaterialVersion = _MfgBOMItemWithPhantomHier.MfgBillOfMaterialVersion AND InheritedBOMItemNode = _MfgBOMItemWithPhantomHier.MfgBOMItmInhtdNodeNmbr  -- association [0..1]
;

Learn More