P_SFOAssldTrcblCompLdngResvn

DDL: P_SFOASSLDTRCBLCOMPLDNGRESVN Type: view_entity CONSUMPTION
108 Fields 2 Data Sources 1 Associations

P_SFOAssldTrcblCompLdngResvn is a Consumption CDS View in SAP S/4HANA. It reads from 2 data sources (I_OpActyNtwkInstanceBasic, P_SFOTrcblComponentAssembly) and exposes 108 fields with key fields AssemblyDocument, AssemblyDocumentItem, Reservation, ReservationItem, RecordType. It has 1 association to related views.

Data Sources (2)

SourceAliasJoin Type
I_OpActyNtwkInstanceBasic OpActyNtwkInstanceBasic inner
P_SFOTrcblComponentAssembly SFOTrcblComponentAssembly from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_ProductPlantBasic _ProductPlantBasic $projection.Material = _ProductPlantBasic.Product and $projection.Plant = _ProductPlantBasic.Plant

Annotations (7)

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

Fields (108)

KeyFieldSource TableSource FieldDescription
KEY AssemblyDocument P_SFOTrcblComponentAssembly AssemblyDocument
KEY AssemblyDocumentItem P_SFOTrcblComponentAssembly AssemblyDocumentItem
KEY Reservation P_SFOTrcblComponentAssembly Reservation
KEY ReservationItem P_SFOTrcblComponentAssembly ReservationItem
KEY RecordType P_SFOTrcblComponentAssembly RecordType
KEY OpActyNtwkInstance P_SFOTrcblComponentAssembly OpActyNtwkInstance
KEY OpActyNtwkElement P_SFOTrcblComponentAssembly OpActyNtwkElement
KEY ShopFloorItem P_SFOTrcblComponentAssembly ShopFloorItem Serial.Mat. ID
KEY Batch P_SFOTrcblComponentAssembly Batch Lot No.
KEY Material P_SFOTrcblComponentAssembly Material Vehicle Model
KEY Plant P_SFOTrcblComponentAssembly Plant Valuation Area
StorageLocation P_SFOTrcblComponentAssembly StorageLocation StorageLocation
DgtlMockUpCharcsUUID P_SFOTrcblComponentAssembly DgtlMockUpCharcsUUID DMU GUID
MfgRefStrucBOMLeafAssgmtUUID P_SFOTrcblComponentAssembly MfgRefStrucBOMLeafAssgmtUUID Leaf Assignment UUID
MfgRefStructureItemDetailUUID P_SFOTrcblComponentAssembly MfgRefStructureItemDetailUUID
MfgRefStrucItmDetIsContextual P_SFOTrcblComponentAssembly MfgRefStrucItmDetIsContextual
dec1343asco_mengeasRequiredQuantity
MaterialComponentQuantity P_SFOTrcblComponentAssembly MaterialComponentQuantity
QuantityInEntryUnit P_SFOTrcblComponentAssembly QuantityInEntryUnit Quantity in Unit of Entry
EntryUnit P_SFOTrcblComponentAssembly EntryUnit Unit of Entry
MaterialBaseUnit P_SFOTrcblComponentAssembly MaterialBaseUnit Valuation Unit
DebitCreditCode P_SFOTrcblComponentAssembly DebitCreditCode Single-Character Flag
InventoryUsabilityCode P_SFOTrcblComponentAssembly InventoryUsabilityCode Stock Type
ManufacturingOrder P_SFOTrcblComponentAssembly ManufacturingOrder Order
_Material P_SFOTrcblComponentAssembly _Material
_Plant P_SFOTrcblComponentAssembly _Plant
_ProductPlantBasic P_SFOTrcblComponentAssembly _ProductPlantBasic
AssemblyDocumentasAssemblyDocument
KEY AssemblyDocumentItem P_SFOTrcblComponentAssembly AssemblyDocumentItem
KEY Reservation P_SFOTrcblComponentAssembly LeadingReservation
KEY ReservationItem P_SFOTrcblComponentAssembly LeadingReservationItem
KEY RecordType P_SFOTrcblComponentAssembly LeadingReservationRecordType
KEY OpActyNtwkInstance P_SFOTrcblComponentAssembly LeadingOpActyNtwkInstance
KEY OpActyNtwkElement P_SFOTrcblComponentAssembly LeadingOpActyNtwkElement
KEY ShopFloorItem P_SFOTrcblComponentAssembly ShopFloorItem Serial.Mat. ID
KEY Batch P_SFOTrcblComponentAssembly Batch Lot No.
KEY Material P_SFOTrcblComponentAssembly Material Vehicle Model
KEY Plant P_SFOTrcblComponentAssembly Plant Valuation Area
StorageLocation P_SFOTrcblComponentAssembly StorageLocation StorageLocation
DgtlMockUpCharcsUUID P_SFOTrcblComponentAssembly DgtlMockUpCharcsUUID DMU GUID
MfgRefStrucBOMLeafAssgmtUUID P_SFOTrcblComponentAssembly MfgRefStrucBOMLeafAssgmtUUID Leaf Assignment UUID
MfgRefStructureItemDetailUUID P_SFOTrcblComponentAssembly MfgRefStructureItemDetailUUID
MfgRefStrucItmDetIsContextual P_SFOTrcblComponentAssembly MfgRefStrucItmDetIsContextual
dec1343asco_mengeasRequiredQuantity
QuantityInEntryUnit Quantity in Unit of Entry
EntryUnit P_SFOTrcblComponentAssembly EntryUnit Unit of Entry
MaterialBaseUnit P_SFOTrcblComponentAssembly MaterialBaseUnit Valuation Unit
DebitCreditCode P_SFOTrcblComponentAssembly DebitCreditCode Single-Character Flag
InventoryUsabilityCode P_SFOTrcblComponentAssembly InventoryUsabilityCode Stock Type
ManufacturingOrder P_SFOTrcblComponentAssembly ManufacturingOrder Order
_Material P_SFOTrcblComponentAssembly _Material
_Plant P_SFOTrcblComponentAssembly _Plant
_ProductPlantBasic P_SFOTrcblComponentAssembly _ProductPlantBasic
AssemblyDocumentasAssemblyDocument
KEY AssemblyDocumentItem P_SFOTrcblComponentAssembly AssemblyDocumentItem
KEY Reservation P_SFOTrcblComponentAssembly LeadingReservation
KEY ReservationItem P_SFOTrcblComponentAssembly LeadingReservationItem
KEY RecordType P_SFOTrcblComponentAssembly LeadingReservationRecordType
KEY OpActyNtwkInstance P_SFOTrcblComponentAssembly LeadingOpActyNtwkInstance
KEY OpActyNtwkElement P_SFOTrcblComponentAssembly LeadingOpActyNtwkElement
KEY ShopFloorItem P_SFOTrcblComponentAssembly ShopFloorItem Serial.Mat. ID
KEY Batch P_SFOTrcblComponentAssembly Batch Lot No.
KEY Material P_SFOTrcblComponentAssembly Material Vehicle Model
KEY Plant P_SFOTrcblComponentAssembly Plant Valuation Area
StorageLocation P_SFOTrcblComponentAssembly StorageLocation StorageLocation
DgtlMockUpCharcsUUID P_SFOTrcblComponentAssembly DgtlMockUpCharcsUUID DMU GUID
MfgRefStrucBOMLeafAssgmtUUID P_SFOTrcblComponentAssembly MfgRefStrucBOMLeafAssgmtUUID Leaf Assignment UUID
MfgRefStructureItemDetailUUID P_SFOTrcblComponentAssembly MfgRefStructureItemDetailUUID
MfgRefStrucItmDetIsContextual P_SFOTrcblComponentAssembly MfgRefStrucItmDetIsContextual
dec1343asco_mengeasRequiredQuantity
MaterialComponentQuantity P_SFOTrcblComponentAssembly MaterialComponentQuantity
QuantityInEntryUnit P_SFOTrcblComponentAssembly QuantityInEntryUnit Quantity in Unit of Entry
EntryUnit P_SFOTrcblComponentAssembly EntryUnit Unit of Entry
MaterialBaseUnit P_SFOTrcblComponentAssembly MaterialBaseUnit Valuation Unit
DebitCreditCode P_SFOTrcblComponentAssembly DebitCreditCode Single-Character Flag
InventoryUsabilityCode P_SFOTrcblComponentAssembly InventoryUsabilityCode Stock Type
ManufacturingOrder P_SFOTrcblComponentAssembly ManufacturingOrder Order
_Material P_SFOTrcblComponentAssembly _Material
_Plant P_SFOTrcblComponentAssembly _Plant
_ProductPlantBasic P_SFOTrcblComponentAssembly _ProductPlantBasic
AssemblyDocumentasAssemblyDocument
KEY AssemblyDocumentItem MfgOrderComponentAssembly AssemblyDocumentItem
KEY Reservation
KEY ReservationItem
KEY RecordType
KEY OpActyNtwkInstance
KEY OpActyNtwkElement
KEY ShopFloorItem MfgOrderComponentAssembly ShopFloorItem Serial.Mat. ID
KEY Batch MfgOrderComponentAssembly Batch Lot No.
KEY Material MfgOrderComponentAssembly Material Vehicle Model
KEY Plant MfgOrderComponentAssembly Plant Valuation Area
StorageLocation MfgOrderComponentAssembly StorageLocation StorageLocation
DgtlMockUpCharcsUUID DMU GUID
MfgRefStrucBOMLeafAssgmtUUID Leaf Assignment UUID
MfgRefStructureItemDetailUUID
MfgRefStrucItmDetIsContextual
RequiredQuantity MfgOrderComponentAssembly RequiredQuantity Requirement qty
MaterialComponentQuantity MfgOrderComponentAssembly MaterialComponentQuantity
QuantityInEntryUnit MfgOrderComponentAssembly QuantityInEntryUnit Quantity in Unit of Entry
EntryUnit MfgOrderComponentAssembly EntryUnit Unit of Entry
MaterialBaseUnit MfgOrderComponentAssembly MaterialBaseUnit Valuation Unit
DebitCreditCode MfgOrderComponentAssembly DebitCreditCode Single-Character Flag
InventoryUsabilityCode MfgOrderComponentAssembly InventoryUsabilityCode Stock Type
ManufacturingOrder I_OpActyNtwkInstanceBasic ManufacturingOrder Order
_Material MfgOrderComponentAssembly _Material
_Plant MfgOrderComponentAssembly _Plant
_ProductPlantBasic _ProductPlantBasic
_ManufacturingOrder I_OpActyNtwkInstanceBasic _ManufacturingOrder

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_SFOAssldTrcblCompLdngResvn.
-- 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_SFOAssldTrcblCompLdngResvn AS
SELECT
  SFOTrcblComponentAssembly.AssemblyDocument AS AssemblyDocument,
  SFOTrcblComponentAssembly.AssemblyDocumentItem AS AssemblyDocumentItem,
  SFOTrcblComponentAssembly.Reservation AS Reservation,
  SFOTrcblComponentAssembly.ReservationItem AS ReservationItem,
  SFOTrcblComponentAssembly.RecordType AS RecordType,
  SFOTrcblComponentAssembly.OpActyNtwkInstance AS OpActyNtwkInstance,
  SFOTrcblComponentAssembly.OpActyNtwkElement AS OpActyNtwkElement,
  SFOTrcblComponentAssembly.ShopFloorItem AS ShopFloorItem,
  SFOTrcblComponentAssembly.Batch AS Batch,
  SFOTrcblComponentAssembly.Material AS Material,
  SFOTrcblComponentAssembly.Plant AS Plant,
  SFOTrcblComponentAssembly.StorageLocation AS StorageLocation,
  SFOTrcblComponentAssembly.DgtlMockUpCharcsUUID AS DgtlMockUpCharcsUUID,
  SFOTrcblComponentAssembly.MfgRefStrucBOMLeafAssgmtUUID AS MfgRefStrucBOMLeafAssgmtUUID,
  SFOTrcblComponentAssembly.MfgRefStructureItemDetailUUID AS MfgRefStructureItemDetailUUID,
  SFOTrcblComponentAssembly.MfgRefStrucItmDetIsContextual AS MfgRefStrucItmDetIsContextual,
  cast(round(fltp_to_dec( SFOTrcblComponentAssembly.RequiredQuantity as abap.dec(13,4) ), 3) as co_menge ) as RequiredQuantity AS dec1343asco_mengeasRequiredQuantity,
  SFOTrcblComponentAssembly.MaterialComponentQuantity AS MaterialComponentQuantity,
  SFOTrcblComponentAssembly.QuantityInEntryUnit AS QuantityInEntryUnit,
  SFOTrcblComponentAssembly.EntryUnit AS EntryUnit,
  SFOTrcblComponentAssembly.MaterialBaseUnit AS MaterialBaseUnit,
  SFOTrcblComponentAssembly.DebitCreditCode AS DebitCreditCode,
  SFOTrcblComponentAssembly.InventoryUsabilityCode AS InventoryUsabilityCode,
  SFOTrcblComponentAssembly.ManufacturingOrder AS ManufacturingOrder,
  SFOTrcblComponentAssembly._Material AS _Material,
  SFOTrcblComponentAssembly._Plant AS _Plant,
  SFOTrcblComponentAssembly._ProductPlantBasic AS _ProductPlantBasic,
  SFOTrcblComponentAssembly._ManufacturingOrder AS AssemblyDocumentasAssemblyDocument,
  MfgOrderComponentAssembly.RequiredQuantity AS RequiredQuantity,
  OpActyNtwkInstanceBasic._ManufacturingOrder AS _ManufacturingOrder
FROM P_SFOTrcblComponentAssembly AS SFOTrcblComponentAssembly
INNER JOIN I_OpActyNtwkInstanceBasic AS OpActyNtwkInstanceBasic ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ProductPlantBasic AS _ProductPlantBasic ON Material = _ProductPlantBasic.Product AND Plant = _ProductPlantBasic.Plant  -- association [0..1]
;

Learn More