What is P_SFIAssldTrcblCompLdngResvn in SAP S/4HANA?

P_SFIAssldTrcblCompLdngResvn is a consumption CDS view in SAP S/4HANA. SFI Assembled Component By Leading Reservation It contains 78 fields.

Which tables does P_SFIAssldTrcblCompLdngResvn read from?

P_SFIAssldTrcblCompLdngResvn reads data from: P_SFITrcblComponentAssembly.

What VDM layer is P_SFIAssldTrcblCompLdngResvn?

P_SFIAssldTrcblCompLdngResvn is classified as a Consumption view optimized for specific business scenarios and reporting.

P_SFIAssldTrcblCompLdngResvn

DDL: P_SFIASSLDTRCBLCOMPLDNGRESVN Type: view_entity CONSUMPTION Package: MPE_EXEC_SFI

78 Fields 1 Data Sources

SFI Assembled Component By Leading Reservation

P_SFIAssldTrcblCompLdngResvn is a Consumption CDS View that provides data about "SFI Assembled Component By Leading Reservation" in SAP S/4HANA. It reads from 1 data source (P_SFITrcblComponentAssembly) and exposes 78 fields with key fields AssemblyDocument, AssemblyDocumentItem, Reservation, ReservationItem, RecordType. Part of development package MPE_EXEC_SFI.

Data Sources (1)

Source	Alias	Join Type
P_SFITrcblComponentAssembly	SFITrcblComponentAssembly	from

Annotations (7)

Name	Value	Level
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 (78)

Key	Field	Source Table	Source Field	Description
KEY	AssemblyDocument	P_SFITrcblComponentAssembly	AssemblyDocument
KEY	AssemblyDocumentItem	P_SFITrcblComponentAssembly	AssemblyDocumentItem
KEY	Reservation	P_SFITrcblComponentAssembly	Reservation
KEY	ReservationItem	P_SFITrcblComponentAssembly	ReservationItem
KEY	RecordType	P_SFITrcblComponentAssembly	RecordType
KEY	OpActyNtwkInstance	P_SFITrcblComponentAssembly	OpActyNtwkInstance
KEY	OpActyNtwkElement	P_SFITrcblComponentAssembly	OpActyNtwkElement
KEY	AssemblyShopFloorItem	P_SFITrcblComponentAssembly	AssemblyShopFloorItem
KEY	ShopFloorItem	P_SFITrcblComponentAssembly	ShopFloorItem	Serial.Mat. ID
KEY	Batch	P_SFITrcblComponentAssembly	Batch	Lot No.
KEY	Material	P_SFITrcblComponentAssembly	Material	Vehicle Model
KEY	Plant	P_SFITrcblComponentAssembly	Plant	Valuation Area
	StorageLocation	P_SFITrcblComponentAssembly	StorageLocation	StorageLocation
	DgtlMockUpCharcsUUID	P_SFITrcblComponentAssembly	DgtlMockUpCharcsUUID	DMU GUID
	MfgRefStrucBOMLeafAssgmtUUID	P_SFITrcblComponentAssembly	MfgRefStrucBOMLeafAssgmtUUID	Leaf Assignment UUID
	MfgRefStructureItemDetailUUID	P_SFITrcblComponentAssembly	MfgRefStructureItemDetailUUID
	MfgRefStrucItmDetIsContextual	P_SFITrcblComponentAssembly	MfgRefStrucItmDetIsContextual
	RequiredQuantity	P_SFITrcblComponentAssembly	RequiredQuantity	Requirement qty
	MaterialComponentQuantity	P_SFITrcblComponentAssembly	MaterialComponentQuantity
	QuantityInEntryUnit	P_SFITrcblComponentAssembly	QuantityInEntryUnit	Quantity in Unit of Entry
	MaterialBaseUnit	P_SFITrcblComponentAssembly	MaterialBaseUnit	Valuation Unit
	EntryUnit	P_SFITrcblComponentAssembly	EntryUnit	Unit of Entry
	DebitCreditCode	P_SFITrcblComponentAssembly	DebitCreditCode	Single-Character Flag
	InventoryUsabilityCode	P_SFITrcblComponentAssembly	InventoryUsabilityCode	Stock Type
	_Material	P_SFITrcblComponentAssembly	_Material
	_Plant	P_SFITrcblComponentAssembly	_Plant
	AssemblyDocument
KEY	AssemblyDocumentItem	P_SFITrcblComponentAssembly	AssemblyDocumentItem
KEY	Reservation	P_SFITrcblComponentAssembly	LeadingReservation
KEY	ReservationItem	P_SFITrcblComponentAssembly	LeadingReservationItem
KEY	RecordType	P_SFITrcblComponentAssembly	LeadingReservationRecordType
KEY	OpActyNtwkInstance	P_SFITrcblComponentAssembly	LeadingOpActyNtwkInstance
KEY	OpActyNtwkElement	P_SFITrcblComponentAssembly	LeadingOpActyNtwkElement
KEY	AssemblyShopFloorItem	P_SFITrcblComponentAssembly	AssemblyShopFloorItem
KEY	ShopFloorItem	P_SFITrcblComponentAssembly	ShopFloorItem	Serial.Mat. ID
KEY	Batch	P_SFITrcblComponentAssembly	Batch	Lot No.
KEY	Material	P_SFITrcblComponentAssembly	Material	Vehicle Model
KEY	Plant	P_SFITrcblComponentAssembly	Plant	Valuation Area
	StorageLocation	P_SFITrcblComponentAssembly	StorageLocation	StorageLocation
	DgtlMockUpCharcsUUID	P_SFITrcblComponentAssembly	DgtlMockUpCharcsUUID	DMU GUID
	MfgRefStrucBOMLeafAssgmtUUID	P_SFITrcblComponentAssembly	MfgRefStrucBOMLeafAssgmtUUID	Leaf Assignment UUID
	MfgRefStructureItemDetailUUID	P_SFITrcblComponentAssembly	MfgRefStructureItemDetailUUID
	MfgRefStrucItmDetIsContextual	P_SFITrcblComponentAssembly	MfgRefStrucItmDetIsContextual
	RequiredQuantity	P_SFITrcblComponentAssembly	RequiredQuantity	Requirement qty
	QuantityInEntryUnit			Quantity in Unit of Entry
	MaterialBaseUnit	P_SFITrcblComponentAssembly	MaterialBaseUnit	Valuation Unit
	EntryUnit	P_SFITrcblComponentAssembly	EntryUnit	Unit of Entry
	DebitCreditCode	P_SFITrcblComponentAssembly	DebitCreditCode	Single-Character Flag
	InventoryUsabilityCode	P_SFITrcblComponentAssembly	InventoryUsabilityCode	Stock Type
	_Material	P_SFITrcblComponentAssembly	_Material
	_Plant	P_SFITrcblComponentAssembly	_Plant
	AssemblyDocument
KEY	AssemblyDocumentItem	P_SFITrcblComponentAssembly	AssemblyDocumentItem
KEY	Reservation	P_SFITrcblComponentAssembly	LeadingReservation
KEY	ReservationItem	P_SFITrcblComponentAssembly	LeadingReservationItem
KEY	RecordType	P_SFITrcblComponentAssembly	LeadingReservationRecordType
KEY	OpActyNtwkInstance	P_SFITrcblComponentAssembly	LeadingOpActyNtwkInstance
KEY	OpActyNtwkElement	P_SFITrcblComponentAssembly	LeadingOpActyNtwkElement
KEY	AssemblyShopFloorItem	P_SFITrcblComponentAssembly	AssemblyShopFloorItem
KEY	ShopFloorItem	P_SFITrcblComponentAssembly	ShopFloorItem	Serial.Mat. ID
KEY	Batch	P_SFITrcblComponentAssembly	Batch	Lot No.
KEY	Material	P_SFITrcblComponentAssembly	Material	Vehicle Model
KEY	Plant	P_SFITrcblComponentAssembly	Plant	Valuation Area
	StorageLocation	P_SFITrcblComponentAssembly	StorageLocation	StorageLocation
	DgtlMockUpCharcsUUID	P_SFITrcblComponentAssembly	DgtlMockUpCharcsUUID	DMU GUID
	MfgRefStrucBOMLeafAssgmtUUID	P_SFITrcblComponentAssembly	MfgRefStrucBOMLeafAssgmtUUID	Leaf Assignment UUID
	MfgRefStructureItemDetailUUID	P_SFITrcblComponentAssembly	MfgRefStructureItemDetailUUID
	MfgRefStrucItmDetIsContextual	P_SFITrcblComponentAssembly	MfgRefStrucItmDetIsContextual
	RequiredQuantity	P_SFITrcblComponentAssembly	RequiredQuantity	Requirement qty
	MaterialComponentQuantity	P_SFITrcblComponentAssembly	MaterialComponentQuantity
	QuantityInEntryUnit	P_SFITrcblComponentAssembly	QuantityInEntryUnit	Quantity in Unit of Entry
	MaterialBaseUnit	P_SFITrcblComponentAssembly	MaterialBaseUnit	Valuation Unit
	EntryUnit	P_SFITrcblComponentAssembly	EntryUnit	Unit of Entry
	DebitCreditCode	P_SFITrcblComponentAssembly	DebitCreditCode	Single-Character Flag
	InventoryUsabilityCode	P_SFITrcblComponentAssembly	InventoryUsabilityCode	Stock Type
	_Material	P_SFITrcblComponentAssembly	_Material
	_Plant	P_SFITrcblComponentAssembly	_Plant
	_ProductPlantBasic	P_SFITrcblComponentAssembly	_ProductPlantBasic

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_SFIAssldTrcblCompLdngResvn.
-- 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_SFIAssldTrcblCompLdngResvn AS
SELECT
  SFITrcblComponentAssembly.AssemblyDocument AS AssemblyDocument,
  SFITrcblComponentAssembly.AssemblyDocumentItem AS AssemblyDocumentItem,
  SFITrcblComponentAssembly.Reservation AS Reservation,
  SFITrcblComponentAssembly.ReservationItem AS ReservationItem,
  SFITrcblComponentAssembly.RecordType AS RecordType,
  SFITrcblComponentAssembly.OpActyNtwkInstance AS OpActyNtwkInstance,
  SFITrcblComponentAssembly.OpActyNtwkElement AS OpActyNtwkElement,
  SFITrcblComponentAssembly.AssemblyShopFloorItem AS AssemblyShopFloorItem,
  SFITrcblComponentAssembly.ShopFloorItem AS ShopFloorItem,
  SFITrcblComponentAssembly.Batch AS Batch,
  SFITrcblComponentAssembly.Material AS Material,
  SFITrcblComponentAssembly.Plant AS Plant,
  SFITrcblComponentAssembly.StorageLocation AS StorageLocation,
  SFITrcblComponentAssembly.DgtlMockUpCharcsUUID AS DgtlMockUpCharcsUUID,
  SFITrcblComponentAssembly.MfgRefStrucBOMLeafAssgmtUUID AS MfgRefStrucBOMLeafAssgmtUUID,
  SFITrcblComponentAssembly.MfgRefStructureItemDetailUUID AS MfgRefStructureItemDetailUUID,
  SFITrcblComponentAssembly.MfgRefStrucItmDetIsContextual AS MfgRefStrucItmDetIsContextual,
  SFITrcblComponentAssembly.RequiredQuantity AS RequiredQuantity,
  SFITrcblComponentAssembly.MaterialComponentQuantity AS MaterialComponentQuantity,
  SFITrcblComponentAssembly.QuantityInEntryUnit AS QuantityInEntryUnit,
  SFITrcblComponentAssembly.MaterialBaseUnit AS MaterialBaseUnit,
  SFITrcblComponentAssembly.EntryUnit AS EntryUnit,
  SFITrcblComponentAssembly.DebitCreditCode AS DebitCreditCode,
  SFITrcblComponentAssembly.InventoryUsabilityCode AS InventoryUsabilityCode,
  SFITrcblComponentAssembly._Material AS _Material,
  SFITrcblComponentAssembly._Plant AS _Plant,
  SFITrcblComponentAssembly._ProductPlantBasic AS _ProductPlantBasic
FROM P_SFITrcblComponentAssembly AS SFITrcblComponentAssembly
;

Depth:

P_SFIAssldTrcblCompLdngResvn view_entity

P_SFITrcblComponentAssembly view_entity