P_SpltSFITrcblCompAssyNoInst

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

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

Data Sources (1)

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

Learn More