P_SpltSFITrcblCompAssembly

DDL: P_SPLTSFITRCBLCOMPASSEMBLY Type: view_entity CONSUMPTION
88 Fields 1 Data Sources

P_SpltSFITrcblCompAssembly is a Consumption CDS View in SAP S/4HANA. It reads from 1 data source (P_SpltSFITrcblCompInstceAssy) and exposes 88 fields with key fields AssemblyDocument, AssemblyDocumentItem, AssemblyDocumentItem, AssemblyDocumentItem.

Data Sources (1)

SourceAliasJoin Type
P_SpltSFITrcblCompInstceAssy Assembly from

Annotations (7)

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

Fields (88)

KeyFieldSource TableSource FieldDescription
KEY AssemblyDocument P_SpltSFITrcblCompInstceAssy AssemblyDocument
KEY AssemblyDocumentItem P_SpltSFITrcblCompInstceAssy AssemblyDocumentItem
Reservation P_SpltSFITrcblCompInstceAssy Reservation Reservation
ReservationItem P_SpltSFITrcblCompInstceAssy ReservationItem Reservation Item
RecordType P_SpltSFITrcblCompInstceAssy RecordType Reservation Record Type
OpActyNtwkInstance P_SpltSFITrcblCompInstceAssy OpActyNtwkInstance Instance ID
OpActyNtwkElement P_SpltSFITrcblCompInstceAssy OpActyNtwkElement Element Number
ActiveReplaceShopFloorItem P_SpltSFITrcblCompInstceAssy ActiveReplaceShopFloorItem
OriginalReplacedShopFloorItem P_SpltSFITrcblCompInstceAssy OriginalReplacedShopFloorItem
AssemblyShopFloorItem P_SpltSFITrcblCompInstceAssy AssemblyShopFloorItem
AssembledShopFloorItem P_SpltSFITrcblCompInstceAssy AssembledShopFloorItem
Batch P_SpltSFITrcblCompInstceAssy Batch Lot No.
Material P_SpltSFITrcblCompInstceAssy Material Vehicle Model
Plant P_SpltSFITrcblCompInstceAssy Plant Valuation Area
StorageLocation P_SpltSFITrcblCompInstceAssy StorageLocation StorageLocation
OriglDgtlMockUpCharcsUUID P_SpltSFITrcblCompInstceAssy OriglDgtlMockUpCharcsUUID DMU GUID
DgtlMockUpCharcsUUID P_SpltSFITrcblCompInstceAssy DgtlMockUpCharcsUUID DMU GUID
MfgRefStrucBOMLeafAssgmtUUID P_SpltSFITrcblCompInstceAssy MfgRefStrucBOMLeafAssgmtUUID Leaf Assignment UUID
MfgRefStructureItemDetailUUID P_SpltSFITrcblCompInstceAssy MfgRefStructureItemDetailUUID
MfgRefStrucItmDetIsContextual P_SpltSFITrcblCompInstceAssy MfgRefStrucItmDetIsContextual
RequiredQuantity P_SpltSFITrcblCompInstceAssy RequiredQuantity Requirement qty
MaterialComponentQuantity P_SpltSFITrcblCompInstceAssy MaterialComponentQuantity
QuantityInEntryUnit P_SpltSFITrcblCompInstceAssy QuantityInEntryUnit Quantity in Unit of Entry
MaterialBaseUnit P_SpltSFITrcblCompInstceAssy MaterialBaseUnit Valuation Unit
EntryUnit P_SpltSFITrcblCompInstceAssy EntryUnit Unit of Entry
DebitCreditCode P_SpltSFITrcblCompInstceAssy DebitCreditCode Single-Character Flag
InventoryUsabilityCode P_SpltSFITrcblCompInstceAssy InventoryUsabilityCode Stock Type
_Material P_SpltSFITrcblCompInstceAssy _Material
_Plant P_SpltSFITrcblCompInstceAssy _Plant
AssemblyDocumentasAssemblyDocument
KEY AssemblyDocumentItem P_SpltSFITrcblCompInstceAssy AssemblyDocumentItem
Reservation P_SpltSFITrcblCompInstceAssy Reservation Reservation
ReservationItem P_SpltSFITrcblCompInstceAssy ReservationItem Reservation Item
RecordType P_SpltSFITrcblCompInstceAssy RecordType Reservation Record Type
OpActyNtwkInstance P_SpltSFITrcblCompInstceAssy OpActyNtwkInstance Instance ID
OpActyNtwkElement P_SpltSFITrcblCompInstceAssy OpActyNtwkElement Element Number
ActiveReplaceShopFloorItem P_SpltSFITrcblCompInstceAssy ActiveReplaceShopFloorItem
OriginalReplacedShopFloorItem P_SpltSFITrcblCompInstceAssy OriginalReplacedShopFloorItem
AssemblyShopFloorItem P_SpltSFITrcblCompInstceAssy AssemblyShopFloorItem
AssembledShopFloorItem P_SpltSFITrcblCompInstceAssy AssembledShopFloorItem
Batch P_SpltSFITrcblCompInstceAssy Batch Lot No.
Material P_SpltSFITrcblCompInstceAssy Material Vehicle Model
Plant P_SpltSFITrcblCompInstceAssy Plant Valuation Area
StorageLocation P_SpltSFITrcblCompInstceAssy StorageLocation StorageLocation
OriglDgtlMockUpCharcsUUID P_SpltSFITrcblCompInstceAssy OriglDgtlMockUpCharcsUUID DMU GUID
DgtlMockUpCharcsUUID P_SpltSFITrcblCompInstceAssy DgtlMockUpCharcsUUID DMU GUID
MfgRefStrucBOMLeafAssgmtUUID P_SpltSFITrcblCompInstceAssy MfgRefStrucBOMLeafAssgmtUUID Leaf Assignment UUID
MfgRefStructureItemDetailUUID P_SpltSFITrcblCompInstceAssy MfgRefStructureItemDetailUUID
MfgRefStrucItmDetIsContextual P_SpltSFITrcblCompInstceAssy MfgRefStrucItmDetIsContextual
RequiredQuantity P_SpltSFITrcblCompInstceAssy RequiredQuantity Requirement qty
MaterialComponentQuantity P_SpltSFITrcblCompInstceAssy MaterialComponentQuantity
QuantityInEntryUnit P_SpltSFITrcblCompInstceAssy QuantityInEntryUnit Quantity in Unit of Entry
MaterialBaseUnit P_SpltSFITrcblCompInstceAssy MaterialBaseUnit Valuation Unit
EntryUnit P_SpltSFITrcblCompInstceAssy EntryUnit Unit of Entry
DebitCreditCode P_SpltSFITrcblCompInstceAssy DebitCreditCode Single-Character Flag
InventoryUsabilityCode P_SpltSFITrcblCompInstceAssy InventoryUsabilityCode Stock Type
_Material P_SpltSFITrcblCompInstceAssy _Material
_Plant P_SpltSFITrcblCompInstceAssy _Plant
AssemblyDocumentasAssemblyDocument
KEY AssemblyDocumentItem SpltSFITrcblUnplndCompAssy AssemblyDocumentItem
Reservation SpltSFITrcblUnplndCompAssy Reservation Reservation
ReservationItem SpltSFITrcblUnplndCompAssy ReservationItem Reservation Item
RecordType SpltSFITrcblUnplndCompAssy RecordType Reservation Record Type
OpActyNtwkInstance SpltSFITrcblUnplndCompAssy OpActyNtwkInstance Instance ID
OpActyNtwkElement SpltSFITrcblUnplndCompAssy OpActyNtwkElement Element Number
ActiveReplaceShopFloorItem SpltSFITrcblUnplndCompAssy ActiveReplaceShopFloorItem
OriginalReplacedShopFloorItem SpltSFITrcblUnplndCompAssy OriginalReplacedShopFloorItem
AssemblyShopFloorItem SpltSFITrcblUnplndCompAssy AssemblyShopFloorItem
AssembledShopFloorItem SpltSFITrcblUnplndCompAssy AssembledShopFloorItem
Batch SpltSFITrcblUnplndCompAssy Batch Lot No.
Material SpltSFITrcblUnplndCompAssy Material Vehicle Model
Plant SpltSFITrcblUnplndCompAssy Plant Valuation Area
StorageLocation SpltSFITrcblUnplndCompAssy StorageLocation StorageLocation
OriglDgtlMockUpCharcsUUID DMU GUID
DgtlMockUpCharcsUUID DMU GUID
MfgRefStrucBOMLeafAssgmtUUID Leaf Assignment UUID
MfgRefStructureItemDetailUUID
MfgRefStrucItmDetIsContextual
RequiredQuantity SpltSFITrcblUnplndCompAssy RequiredQuantity Requirement qty
MaterialComponentQuantity SpltSFITrcblUnplndCompAssy MaterialComponentQuantity
QuantityInEntryUnit SpltSFITrcblUnplndCompAssy QuantityInEntryUnit Quantity in Unit of Entry
MaterialBaseUnit SpltSFITrcblUnplndCompAssy MaterialBaseUnit Valuation Unit
EntryUnit SpltSFITrcblUnplndCompAssy EntryUnit Unit of Entry
DebitCreditCode SpltSFITrcblUnplndCompAssy DebitCreditCode Single-Character Flag
InventoryUsabilityCode SpltSFITrcblUnplndCompAssy InventoryUsabilityCode Stock Type
_Material SpltSFITrcblUnplndCompAssy _Material
_Plant SpltSFITrcblUnplndCompAssy _Plant
_ProductPlantBasic SpltSFITrcblUnplndCompAssy _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_SpltSFITrcblCompAssembly.
-- 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_SpltSFITrcblCompAssembly AS
SELECT
  Assembly.AssemblyDocument AS AssemblyDocument,
  Assembly.AssemblyDocumentItem AS AssemblyDocumentItem,
  Assembly.Reservation AS Reservation,
  Assembly.ReservationItem AS ReservationItem,
  Assembly.RecordType AS RecordType,
  Assembly.OpActyNtwkInstance AS OpActyNtwkInstance,
  Assembly.OpActyNtwkElement AS OpActyNtwkElement,
  Assembly.ActiveReplaceShopFloorItem AS ActiveReplaceShopFloorItem,
  Assembly.OriginalReplacedShopFloorItem AS OriginalReplacedShopFloorItem,
  Assembly.AssemblyShopFloorItem AS AssemblyShopFloorItem,
  Assembly.AssembledShopFloorItem AS AssembledShopFloorItem,
  Assembly.Batch AS Batch,
  Assembly.Material AS Material,
  Assembly.Plant AS Plant,
  Assembly.StorageLocation AS StorageLocation,
  Assembly.OriglDgtlMockUpCharcsUUID AS OriglDgtlMockUpCharcsUUID,
  Assembly.DgtlMockUpCharcsUUID AS DgtlMockUpCharcsUUID,
  Assembly.MfgRefStrucBOMLeafAssgmtUUID AS MfgRefStrucBOMLeafAssgmtUUID,
  Assembly.MfgRefStructureItemDetailUUID AS MfgRefStructureItemDetailUUID,
  Assembly.MfgRefStrucItmDetIsContextual AS MfgRefStrucItmDetIsContextual,
  Assembly.RequiredQuantity AS RequiredQuantity,
  Assembly.MaterialComponentQuantity AS MaterialComponentQuantity,
  Assembly.QuantityInEntryUnit AS QuantityInEntryUnit,
  Assembly.MaterialBaseUnit AS MaterialBaseUnit,
  Assembly.EntryUnit AS EntryUnit,
  Assembly.DebitCreditCode AS DebitCreditCode,
  Assembly.InventoryUsabilityCode AS InventoryUsabilityCode,
  Assembly._Material AS _Material,
  Assembly._Plant AS _Plant,
  Assembly._ProductPlantBasic AS AssemblyDocumentasAssemblyDocument,
  SpltSFITrcblUnplndCompAssy._ProductPlantBasic AS _ProductPlantBasic
FROM P_SpltSFITrcblCompInstceAssy AS Assembly
;

Learn More