Deprecated
This CDS view is deprecated in S/4HANA. Use C_SFIAssldTraceableComponent instead. View all deprecated CDS views →

C_ShopFloorItemComponent

DDL: C_SHOPFLOORITEMCOMPONENT Type: view_entity CONSUMPTION
63 Fields 1 Data Sources 1 Associations

SFI Manual and Backflushed Component per SFI and Batch

C_ShopFloorItemComponent is a Consumption CDS View that provides data about "SFI Manual and Backflushed Component per SFI and Batch" in SAP S/4HANA. It reads from 1 data source (P_ShopFloorItemComponent2) and exposes 63 fields with key fields Reservation, ReservationItem, RecordType, OpActyNtwkInstance, OpActyNtwkElement. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
P_ShopFloorItemComponent2 P_ShopFloorItemComponent2 from

Associations (1)

CardinalityTargetAliasCondition
[0..1] E_BillOfMaterialItemTP _BillOfMaterialItemExtension $projection.BillOfMaterialCategory = _BillOfMaterialItemExtension.BillOfMaterialCategory and $projection.BillOfMaterialInternalID = _BillOfMaterialItemExtension.BillOfMaterial and $projection.BOMItem = _BillOfMaterialItemExtension.BillOfMaterialItemNodeNumber and $projection.BOMItemInternalChangeCount = _BillOfMaterialItemExtension.BOMItemInternalChangeCount

Annotations (10)

NameValueLevelField
Metadata.allowExtensions true view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
VDM.lifecycle.status #DEPRECATED view
VDM.lifecycle.successor C_SFIAssldTraceableComponent view
VDM.viewType #CONSUMPTION view
EndUserText.label SFI Manual and Backflushed Component per SFI and Batch view

Fields (63)

KeyFieldSource TableSource FieldDescription
KEY Reservation Reservation Reservation
KEY ReservationItem ReservationItem Reservation Item
KEY RecordType RecordType Reservation Record Type
KEY OpActyNtwkInstance OpActyNtwkInstance Instance ID
KEY OpActyNtwkElement OpActyNtwkElement Element Number
KEY AssemblyShopFloorItem AssemblyShopFloorItem
KEY ShopFloorItem ShopFloorItem Serial.Mat. ID
KEY Batch Batch Lot No.
KEY Material Material Vehicle Model
KEY Plant Plant Valuation Area
KEY DgtlMockUpCharcsUUID DgtlMockUpCharcsUUID DMU GUID
BillOfMaterialCategory BillOfMaterialCategory BOM category
BillOfMaterialInternalID BillOfMaterialInternalID
BOMItem BOMItem
BOMItemInternalChangeCount BOMItemInternalChangeCount Counter
BillOfMaterialVariant BillOfMaterialVariant AlternativeBOM
BillOfMaterialVersion BillOfMaterialVersion BOM Version
MfgBOMItemIsPhantomChild MfgBOMItemIsPhantomChild
OriginalReplacedShopFloorItem OriginalReplacedShopFloorItem
MaterialName MaterialName Material Description
RequiredQuantity RequiredQuantity Requirement qty
RequiredQuantityInBaseUnit RequiredQuantityInBaseUnit
MaterialComponentQuantity MaterialComponentQuantity
ResvnItmWithdrawnQtyInBaseUnit ResvnItmWithdrawnQtyInBaseUnit Withdrawal Qty
ResvnItmTotalWithdrawnQty ResvnItmTotalWithdrawnQty Withdrawal Qty
MaterialBaseUnit MaterialBaseUnit Valuation Unit
EntryUnit EntryUnit Unit of Entry
OrderInternalID OrderInternalID Plan No.f.Oper.
OrderOperationInternalID OrderOperationInternalID
SerialNumber SerialNumber Serial Number
ManufacturerSerialNumber ManufacturerSerialNumber Mnf.serial no.
BatchBySupplier BatchBySupplier Supplier Batch
ReferenceDesignatorName ReferenceDesignatorName
MaterialCompIsVariableSized MaterialCompIsVariableSized Var-Sized Item
FormulaKey FormulaKey VSI Formula
VariableSizeDimension1 VariableSizeDimension1 Size 1
VariableSizeDimension2 VariableSizeDimension2 Size 2
VariableSizeDimension3 VariableSizeDimension3 Size 3
VariableSizeDimensionUnit VariableSizeDimensionUnit Size unit
VarblSizeCompFrmtdFormulaVal VarblSizeCompFrmtdFormulaVal
VariableSizeComponentQuantity VariableSizeComponentQuantity VSI Quantity
VariableSizeComponentUnit VariableSizeComponentUnit VSI UoM
MfgRefStrucItmDetIsContextual MfgRefStrucItmDetIsContextual
ManufacturingOrder ManufacturingOrder Order
ManufacturingOrderOperation ManufacturingOrderOperation Activity
MfgOrderOperationText MfgOrderOperationText
OpActyNtwkElementExternalID OpActyNtwkElementExternalID Op. Activity
OperationActivityName OperationActivityName
ComponentAssemblyCriticality ComponentAssemblyCriticality
MatlCompAssembleControl MatlCompAssembleControl
MatlCompAssembleControlName MatlCompAssembleControlName
BOMItemCategory BOMItemCategory Item Category
BillOfMaterialItemCategoryDesc BillOfMaterialItemCategoryDesc Item Category
EffectivityParameterVariant EffectivityParameterVariant
Assembly Assembly Pegged Reqmt
MfgRefStrucBOMLeafAssgmtUUID MfgRefStrucBOMLeafAssgmtUUID Leaf Assignment UUID
MfgRefStructureItemDetailUUID MfgRefStructureItemDetailUUID
MfgRefStrucItmRefDsgntrName MfgRefStrucItmRefDsgntrName MRS Designator
BillOfMaterialVariantUsage BillOfMaterialVariantUsage Usage
_Material _Material
_OpActyNtwkInstance _OpActyNtwkInstance
_OperationActivityInstance _OperationActivityInstance
_Plant _Plant

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 C_ShopFloorItemComponent.
-- 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 C_ShopFloorItemComponent AS
SELECT
  Reservation,
  ReservationItem,
  RecordType,
  OpActyNtwkInstance,
  OpActyNtwkElement,
  AssemblyShopFloorItem,
  ShopFloorItem,
  Batch,
  Material,
  Plant,
  DgtlMockUpCharcsUUID,
  BillOfMaterialCategory,
  BillOfMaterialInternalID,
  BOMItem,
  BOMItemInternalChangeCount,
  BillOfMaterialVariant,
  BillOfMaterialVersion,
  MfgBOMItemIsPhantomChild,
  OriginalReplacedShopFloorItem,
  MaterialName,
  RequiredQuantity,
  RequiredQuantityInBaseUnit,
  MaterialComponentQuantity,
  ResvnItmWithdrawnQtyInBaseUnit,
  ResvnItmTotalWithdrawnQty,
  MaterialBaseUnit,
  EntryUnit,
  OrderInternalID,
  OrderOperationInternalID,
  SerialNumber,
  ManufacturerSerialNumber,
  BatchBySupplier,
  ReferenceDesignatorName,
  MaterialCompIsVariableSized,
  FormulaKey,
  VariableSizeDimension1,
  VariableSizeDimension2,
  VariableSizeDimension3,
  VariableSizeDimensionUnit,
  VarblSizeCompFrmtdFormulaVal,
  VariableSizeComponentQuantity,
  VariableSizeComponentUnit,
  MfgRefStrucItmDetIsContextual,
  ManufacturingOrder,
  ManufacturingOrderOperation,
  MfgOrderOperationText,
  OpActyNtwkElementExternalID,
  OperationActivityName,
  ComponentAssemblyCriticality,
  MatlCompAssembleControl,
  MatlCompAssembleControlName,
  BOMItemCategory,
  BillOfMaterialItemCategoryDesc,
  EffectivityParameterVariant,
  Assembly,
  MfgRefStrucBOMLeafAssgmtUUID,
  MfgRefStructureItemDetailUUID,
  MfgRefStrucItmRefDsgntrName,
  BillOfMaterialVariantUsage
FROM P_ShopFloorItemComponent2
LEFT OUTER JOIN E_BillOfMaterialItemTP AS _BillOfMaterialItemExtension ON BillOfMaterialCategory = _BillOfMaterialItemExtension.BillOfMaterialCategory AND BillOfMaterialInternalID = _BillOfMaterialItemExtension.BillOfMaterial AND BOMItem = _BillOfMaterialItemExtension.BillOfMaterialItemNodeNumber AND BOMItemInternalChangeCount = _BillOfMaterialItemExtension.BOMItemInternalChangeCount  -- association [0..1]
;

Learn More