P_SFOAssldTrcblCompLdngResvn

DDL: P_SFOASSLDTRCBLCOMPLDNGRESVN Type: view_entity CONSUMPTION
81 Fields 1 Data Sources

P_SFOAssldTrcblCompLdngResvn is a Consumption CDS View in SAP S/4HANA. It reads from 1 data source (P_SFOTrcblComponentAssembly) and exposes 81 fields with key fields AssemblyDocument, AssemblyDocumentItem, Reservation, ReservationItem, RecordType.

Data Sources (1)

SourceAliasJoin Type
P_SFOTrcblComponentAssembly SFOTrcblComponentAssembly from

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 (81)

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
AssemblyDocument
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
AssemblyDocument
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
_ManufacturingOrder P_SFOTrcblComponentAssembly _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 _ManufacturingOrder
FROM P_SFOTrcblComponentAssembly AS SFOTrcblComponentAssembly
;

Learn More