P_UnspltSFITrcblCompAssembly

DDL: P_UNSPLTSFITRCBLCOMPASSEMBLY Type: view_entity CONSUMPTION
85 Fields 1 Data Sources

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

Data Sources (1)

SourceAliasJoin Type
P_UnspltSFITrcblCompInstceAssy Assembly from

Annotations (7)

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

Fields (85)

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

Learn More