P_SpltSFITrcblCompInstceAssy

DDL: P_SPLTSFITRCBLCOMPINSTCEASSY Type: view_entity CONSUMPTION
89 Fields 1 Data Sources

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

Data Sources (1)

SourceAliasJoin Type
P_SpltSFITrcblPlndCompAssyIn 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 (89)

KeyFieldSource TableSource FieldDescription
KEY AssemblyDocument P_SpltSFITrcblPlndCompAssyIn AssemblyDocument
KEY AssemblyDocumentItem P_SpltSFITrcblPlndCompAssyIn AssemblyDocumentItem
Reservation P_SpltSFITrcblPlndCompAssyIn Reservation
ReservationItem P_SpltSFITrcblPlndCompAssyIn ReservationItem
RecordType P_SpltSFITrcblPlndCompAssyIn RecordType
OpActyNtwkInstance P_SpltSFITrcblPlndCompAssyIn OpActyNtwkInstance
OpActyNtwkElement P_SpltSFITrcblPlndCompAssyIn OpActyNtwkElement
OriginalReplacedShopFloorItem P_SpltSFITrcblPlndCompAssyIn OriginalReplacedShopFloorItem
ActiveReplaceShopFloorItem P_SpltSFITrcblPlndCompAssyIn ActiveReplaceShopFloorItem Serial.Mat. ID
AssemblyShopFloorItem P_SpltSFITrcblPlndCompAssyIn AssemblyShopFloorItem
AssembledShopFloorItem P_SpltSFITrcblPlndCompAssyIn AssembledShopFloorItem Serial.Mat. ID
Batch P_SpltSFITrcblPlndCompAssyIn Batch Lot No.
Material P_SpltSFITrcblPlndCompAssyIn Material Vehicle Model
Plant P_SpltSFITrcblPlndCompAssyIn Plant Valuation Area
StorageLocation P_SpltSFITrcblPlndCompAssyIn StorageLocation StorageLocation
OriglDgtlMockUpCharcsUUID P_SpltSFITrcblPlndCompAssyIn OriglDgtlMockUpCharcsUUID DMU GUID
DgtlMockUpCharcsUUID P_SpltSFITrcblPlndCompAssyIn DgtlMockUpCharcsUUID DMU GUID
MfgRefStrucBOMLeafAssgmtUUID P_SpltSFITrcblPlndCompAssyIn MfgRefStrucBOMLeafAssgmtUUID Leaf Assignment UUID
MfgRefStructureItemDetailUUID P_SpltSFITrcblPlndCompAssyIn MfgRefStructureItemDetailUUID
MfgRefStrucItmDetIsContextual P_SpltSFITrcblPlndCompAssyIn MfgRefStrucItmDetIsContextual
RequiredQuantity P_SpltSFITrcblPlndCompAssyIn RequiredQuantity Requirement qty
MaterialComponentQuantity P_SpltSFITrcblPlndCompAssyIn MaterialComponentQuantity
QuantityInEntryUnit P_SpltSFITrcblPlndCompAssyIn QuantityInEntryUnit Quantity in Unit of Entry
MaterialBaseUnit P_SpltSFITrcblPlndCompAssyIn MaterialBaseUnit Valuation Unit
EntryUnit P_SpltSFITrcblPlndCompAssyIn EntryUnit Unit of Entry
DebitCreditCode P_SpltSFITrcblPlndCompAssyIn DebitCreditCode Single-Character Flag
InventoryUsabilityCode P_SpltSFITrcblPlndCompAssyIn InventoryUsabilityCode Stock Type
ComponentAssemblyType P_SpltSFITrcblPlndCompAssyIn ComponentAssemblyType
_Material P_SpltSFITrcblPlndCompAssyIn _Material
_Plant P_SpltSFITrcblPlndCompAssyIn _Plant
AssemblyDocumentasAssemblyDocument
KEY AssemblyDocumentItem P_SpltSFITrcblPlndCompAssyIn AssemblyDocumentItem
Reservation P_SpltSFITrcblPlndCompAssyIn LeadingReservation
ReservationItem P_SpltSFITrcblPlndCompAssyIn LeadingReservationItem
RecordType P_SpltSFITrcblPlndCompAssyIn LeadingReservationRecordType
OpActyNtwkInstance P_SpltSFITrcblPlndCompAssyIn LeadingOpActyNtwkInstance
OpActyNtwkElement P_SpltSFITrcblPlndCompAssyIn LeadingOpActyNtwkElement
OriginalReplacedShopFloorItem P_SpltSFITrcblPlndCompAssyIn OriginalReplacedShopFloorItem
ActiveReplaceShopFloorItem P_SpltSFITrcblPlndCompAssyIn ActiveReplaceShopFloorItem Serial.Mat. ID
AssemblyShopFloorItem P_SpltSFITrcblPlndCompAssyIn AssemblyShopFloorItem
AssembledShopFloorItem P_SpltSFITrcblPlndCompAssyIn AssembledShopFloorItem Serial.Mat. ID
Batch P_SpltSFITrcblPlndCompAssyIn Batch Lot No.
Material P_SpltSFITrcblPlndCompAssyIn Material Vehicle Model
Plant P_SpltSFITrcblPlndCompAssyIn Plant Valuation Area
StorageLocation P_SpltSFITrcblPlndCompAssyIn StorageLocation StorageLocation
OriglDgtlMockUpCharcsUUID ParentOpActyCompInstceAssgmt OriglDgtlMockUpCharcsUUID DMU GUID
DgtlMockUpCharcsUUID P_SpltSFITrcblPlndCompAssyIn DgtlMockUpCharcsUUID DMU GUID
MfgRefStrucBOMLeafAssgmtUUID P_SpltSFITrcblPlndCompAssyIn MfgRefStrucBOMLeafAssgmtUUID Leaf Assignment UUID
MfgRefStructureItemDetailUUID P_SpltSFITrcblPlndCompAssyIn MfgRefStructureItemDetailUUID
MfgRefStrucItmDetIsContextual P_SpltSFITrcblPlndCompAssyIn MfgRefStrucItmDetIsContextual
RequiredQuantity P_SpltSFITrcblPlndCompAssyIn RequiredQuantity Requirement qty
QuantityInEntryUnit Quantity in Unit of Entry
MaterialBaseUnit P_SpltSFITrcblPlndCompAssyIn MaterialBaseUnit Valuation Unit
EntryUnit P_SpltSFITrcblPlndCompAssyIn EntryUnit Unit of Entry
DebitCreditCode P_SpltSFITrcblPlndCompAssyIn DebitCreditCode Single-Character Flag
InventoryUsabilityCode P_SpltSFITrcblPlndCompAssyIn InventoryUsabilityCode Stock Type
ComponentAssemblyType P_SpltSFITrcblPlndCompAssyIn ComponentAssemblyType
_Material P_SpltSFITrcblPlndCompAssyIn _Material
_Plant P_SpltSFITrcblPlndCompAssyIn _Plant
AssemblyDocumentasAssemblyDocument
KEY AssemblyDocumentItem P_SpltSFITrcblPlndCompAssyIn AssemblyDocumentItem
Reservation P_SpltSFITrcblPlndCompAssyIn LeadingReservation
ReservationItem P_SpltSFITrcblPlndCompAssyIn LeadingReservationItem
RecordType P_SpltSFITrcblPlndCompAssyIn LeadingReservationRecordType
OpActyNtwkInstance P_SpltSFITrcblPlndCompAssyIn LeadingOpActyNtwkInstance
OpActyNtwkElement P_SpltSFITrcblPlndCompAssyIn LeadingOpActyNtwkElement
OriginalReplacedShopFloorItem P_SpltSFITrcblPlndCompAssyIn OriginalReplacedShopFloorItem
ActiveReplaceShopFloorItem P_SpltSFITrcblPlndCompAssyIn ActiveReplaceShopFloorItem Serial.Mat. ID
AssemblyShopFloorItem P_SpltSFITrcblPlndCompAssyIn AssemblyShopFloorItem
AssembledShopFloorItem P_SpltSFITrcblPlndCompAssyIn AssembledShopFloorItem Serial.Mat. ID
Batch P_SpltSFITrcblPlndCompAssyIn Batch Lot No.
Material P_SpltSFITrcblPlndCompAssyIn Material Vehicle Model
Plant P_SpltSFITrcblPlndCompAssyIn Plant Valuation Area
StorageLocation P_SpltSFITrcblPlndCompAssyIn StorageLocation StorageLocation
OriglDgtlMockUpCharcsUUID LeadingOpActyCompInstceAssgmt OriglDgtlMockUpCharcsUUID DMU GUID
DgtlMockUpCharcsUUID P_SpltSFITrcblPlndCompAssyIn DgtlMockUpCharcsUUID DMU GUID
MfgRefStructureItemDetailUUID P_SpltSFITrcblPlndCompAssyIn MfgRefStructureItemDetailUUID
MfgRefStrucItmDetIsContextual P_SpltSFITrcblPlndCompAssyIn MfgRefStrucItmDetIsContextual
RequiredQuantity P_SpltSFITrcblPlndCompAssyIn RequiredQuantity Requirement qty
MaterialComponentQuantity P_SpltSFITrcblPlndCompAssyIn MaterialComponentQuantity
QuantityInEntryUnit P_SpltSFITrcblPlndCompAssyIn QuantityInEntryUnit Quantity in Unit of Entry
MaterialBaseUnit P_SpltSFITrcblPlndCompAssyIn MaterialBaseUnit Valuation Unit
EntryUnit P_SpltSFITrcblPlndCompAssyIn EntryUnit Unit of Entry
DebitCreditCode P_SpltSFITrcblPlndCompAssyIn DebitCreditCode Single-Character Flag
InventoryUsabilityCode P_SpltSFITrcblPlndCompAssyIn InventoryUsabilityCode Stock Type
ComponentAssemblyType P_SpltSFITrcblPlndCompAssyIn ComponentAssemblyType
_Material P_SpltSFITrcblPlndCompAssyIn _Material
_Plant P_SpltSFITrcblPlndCompAssyIn _Plant
_ProductPlantBasic P_SpltSFITrcblPlndCompAssyIn _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_SpltSFITrcblCompInstceAssy.
-- 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_SpltSFITrcblCompInstceAssy 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.OriginalReplacedShopFloorItem AS OriginalReplacedShopFloorItem,
  Assembly.ActiveReplaceShopFloorItem AS ActiveReplaceShopFloorItem,
  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.ComponentAssemblyType AS ComponentAssemblyType,
  Assembly._Material AS _Material,
  Assembly._Plant AS _Plant,
  Assembly._ProductPlantBasic AS AssemblyDocumentasAssemblyDocument,
  Assembly._ProductPlantBasic AS _ProductPlantBasic
FROM P_SpltSFITrcblPlndCompAssyIn AS Assembly
;

Learn More