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

C_SFORetdTraceableMaterial

DDL: C_SFORETDTRACEABLEMATERIAL Type: view_entity CONSUMPTION
57 Fields 1 Data Sources 4 Associations

Obsolete SFI returned traceable material

C_SFORetdTraceableMaterial is a Consumption CDS View that provides data about "Obsolete SFI returned traceable material" in SAP S/4HANA. It reads from 1 data source (P_SFOTraceableAssldComp) and exposes 57 fields with key fields Reservation, ReservationItem, RecordType, OpActyNtwkInstance, OpActyNtwkElement. It has 4 associations to related views.

Data Sources (1)

SourceAliasJoin Type
P_SFOTraceableAssldComp ass from

Associations (4)

CardinalityTargetAliasCondition
[0..1] I_Plant _Plant $projection.Plant = _Plant.Plant
[1..1] I_OpActyNtwkInstance _OpActyNtwkInstance $projection.OpActyNtwkInstance = _OpActyNtwkInstance.OpActyNtwkInstance
[1..1] I_OperationActivityInstance _OperationActivityInstance $projection.OpActyNtwkInstance = _OperationActivityInstance.OpActyNtwkInstance and $projection.OpActyNtwkElement = _OperationActivityInstance.OpActyNtwkElement ----Extension
[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 (14)

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.viewType #CONSUMPTION view
VDM.lifecycle.status #DEPRECATED view
VDM.lifecycle.successor C_SFODsassldTrcblComponent view
UI.headerInfo.typeName Returned Traceable Material view
UI.headerInfo.typeNamePlural Returned Traceable Materials view
UI.headerInfo.title.label Returned Traceable Material view
UI.textArrangement #TEXT_LAST view
EndUserText.label Obsolete SFI returned traceable material view

Fields (57)

KeyFieldSource TableSource FieldDescription
KEY Reservation P_SFOTraceableAssldComp Reservation Reservation
KEY ReservationItem P_SFOTraceableAssldComp ReservationItem Reservation Item
KEY RecordType P_SFOTraceableAssldComp RecordType Reservation Record Type
KEY OpActyNtwkInstance P_SFOTraceableAssldComp OpActyNtwkInstance Instance ID
KEY OpActyNtwkElement P_SFOTraceableAssldComp OpActyNtwkElement Element Number
KEY ShopFloorItem P_SFOTraceableAssldComp ShopFloorItem Serial.Mat. ID
Batch
Material
KEY Plant P_SFOTraceableAssldComp Plant Valuation Area
KEY DgtlMockUpCharcsUUID P_SFOTraceableAssldComp DgtlMockUpCharcsUUID DMU GUID
BillOfMaterialItemNumber P_SFOTraceableAssldComp BillOfMaterialItemNumber Item
BillOfMaterialCategory P_SFOTraceableAssldComp BillOfMaterialCategory BOM category
BillOfMaterialInternalID P_SFOTraceableAssldComp BillOfMaterialInternalID
BOMItem P_SFOTraceableAssldComp BOMItem
BOMItemInternalChangeCount P_SFOTraceableAssldComp BOMItemInternalChangeCount Counter
BillOfMaterialVariant P_SFOTraceableAssldComp BillOfMaterialVariant AlternativeBOM
BillOfMaterialVersion P_SFOTraceableAssldComp BillOfMaterialVersion BOM Version
InheritedNodeNumberForBOMItem P_SFOTraceableAssldComp InheritedNodeNumberForBOMItem Nodes
InheritedNodeNumberVersionBOM P_SFOTraceableAssldComp InheritedNodeNumberVersionBOM Item node
Assembly P_SFOTraceableAssldComp Assembly Pegged Reqmt
MaterialName
RequiredQuantity
RequiredQuantityInBaseUnit P_SFOTraceableAssldComp RequiredQuantityInBaseUnit
ResvnItmWithdrawnQtyInBaseUnit
ResvnItmTotalWithdrawnQty P_SFOTraceableAssldComp ResvnItmTotalWithdrawnQty
MaterialBaseUnit P_SFOTraceableAssldComp MaterialBaseUnit Valuation Unit
EntryUnit P_SFOTraceableAssldComp EntryUnit Unit of Entry
OrderInternalID P_SFOTraceableAssldComp OrderInternalID Plan No.f.Oper.
OrderOperationInternalID P_SFOTraceableAssldComp OrderOperationInternalID
SerialNumber
ManufacturerSerialNumber P_SFOTraceableAssldComp ManufacturerSerialNumber Mnf.serial no.
BatchBySupplier
ReferenceDesignatorValue P_SFOTraceableAssldComp ReferenceDesignatorValue Ref. Designator
MaterialCompIsVariableSized
FormulaKey P_SFOTraceableAssldComp FormulaKey VSI Formula
VariableSizeDimension1 P_SFOTraceableAssldComp VariableSizeDimension1 Size 1
VariableSizeDimension2 P_SFOTraceableAssldComp VariableSizeDimension2 Size 2
VariableSizeDimension3 P_SFOTraceableAssldComp VariableSizeDimension3 Size 3
VariableSizeDimensionUnit P_SFOTraceableAssldComp VariableSizeDimensionUnit Size unit
VarblSizeCompFrmtdFormulaVal
VariableSizeComponentQuantity P_SFOTraceableAssldComp VariableSizeComponentQuantity VSI Quantity
VariableSizeComponentUnit P_SFOTraceableAssldComp VariableSizeComponentUnit VSI UoM
MfgRefStrucItmDetIsContextual P_SFOTraceableAssldComp MfgRefStrucItmDetIsContextual
ManufacturingOrder P_SFOTraceableAssldComp ManufacturingOrder Order
MfgOrderOperationText P_SFOTraceableAssldComp OperationText Description
OperationActivityName
MatlCompAssembleControl P_SFOTraceableAssldComp MatlCompAssembleControl
StorageLocationName
BOMItemCategory P_SFOTraceableAssldComp BOMItemCategory Item Category
BillOfMaterialItemCategoryDesc
EffectivityParameterVariant P_SFOTraceableAssldComp EffectivityParameterVariant
MfgRefStrucBOMLeafAssgmtUUID
MfgRefStructureItemDetailUUID P_SFOTraceableAssldComp MfgRefStructureItemDetailUUID
_Material
_Plant _Plant
_OpActyNtwkInstance _OpActyNtwkInstance
_OperationActivityInstance _OperationActivityInstance

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_SFORetdTraceableMaterial.
-- 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_SFORetdTraceableMaterial AS
SELECT
  ass.Reservation AS Reservation,
  ass.ReservationItem AS ReservationItem,
  ass.RecordType AS RecordType,
  ass.OpActyNtwkInstance AS OpActyNtwkInstance,
  ass.OpActyNtwkElement AS OpActyNtwkElement,
  ass.ShopFloorItem AS ShopFloorItem,
  ass.Plant AS Plant,
  ass.DgtlMockUpCharcsUUID AS DgtlMockUpCharcsUUID,
  ass.BillOfMaterialItemNumber AS BillOfMaterialItemNumber,
  ass.BillOfMaterialCategory AS BillOfMaterialCategory,
  ass.BillOfMaterialInternalID AS BillOfMaterialInternalID,
  ass.BOMItem AS BOMItem,
  ass.BOMItemInternalChangeCount AS BOMItemInternalChangeCount,
  ass.BillOfMaterialVariant AS BillOfMaterialVariant,
  ass.BillOfMaterialVersion AS BillOfMaterialVersion,
  ass.InheritedNodeNumberForBOMItem AS InheritedNodeNumberForBOMItem,
  ass.InheritedNodeNumberVersionBOM AS InheritedNodeNumberVersionBOM,
  ass.Assembly AS Assembly,
  ass._Material._Text[1: Language=$session.system_language].MaterialName AS MaterialName,
  ass.RequiredQuantityInBaseUnit AS RequiredQuantityInBaseUnit,
  cast(ass.ResvnItmWithdrawnQtyInBaseUnit as mpe_returned_qty_in_base_unit preserving type ) AS ResvnItmWithdrawnQtyInBaseUnit,
  ass.ResvnItmTotalWithdrawnQty AS ResvnItmTotalWithdrawnQty,
  ass.MaterialBaseUnit AS MaterialBaseUnit,
  ass.EntryUnit AS EntryUnit,
  ass.OrderInternalID AS OrderInternalID,
  ass.OrderOperationInternalID AS OrderOperationInternalID,
  ass.ManufacturerSerialNumber AS ManufacturerSerialNumber,
  cast(' ' as lichn preserving type ) AS BatchBySupplier,
  ass.ReferenceDesignatorValue AS ReferenceDesignatorValue,
  ass.FormulaKey AS FormulaKey,
  ass.VariableSizeDimension1 AS VariableSizeDimension1,
  ass.VariableSizeDimension2 AS VariableSizeDimension2,
  ass.VariableSizeDimension3 AS VariableSizeDimension3,
  ass.VariableSizeDimensionUnit AS VariableSizeDimensionUnit,
  cast('' as mpe_vsi_formatted_formula) AS VarblSizeCompFrmtdFormulaVal,
  ass.VariableSizeComponentQuantity AS VariableSizeComponentQuantity,
  ass.VariableSizeComponentUnit AS VariableSizeComponentUnit,
  ass.MfgRefStrucItmDetIsContextual AS MfgRefStrucItmDetIsContextual,
  ass.ManufacturingOrder AS ManufacturingOrder,
  ass.OperationText AS MfgOrderOperationText,
  OpActyNtwkElement._OperationActivityText[1: Language=$session.system_language].OperationActivityName AS OperationActivityName,
  ass.MatlCompAssembleControl AS MatlCompAssembleControl,
  cast('' as lgort_name) AS StorageLocationName,
  ass.BOMItemCategory AS BOMItemCategory,
  ass._BOMItemCategory._ItemCategoryT[1: Language=$session.system_language].BillOfMaterialItemCategoryDesc AS BillOfMaterialItemCategoryDesc,
  ass.EffectivityParameterVariant AS EffectivityParameterVariant,
  ass.MfgRefStructureItemDetailUUID AS MfgRefStructureItemDetailUUID
FROM P_SFOTraceableAssldComp AS ass
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [0..1]
LEFT OUTER JOIN I_OpActyNtwkInstance AS _OpActyNtwkInstance ON OpActyNtwkInstance = _OpActyNtwkInstance.OpActyNtwkInstance  -- association [1..1]
LEFT OUTER JOIN I_OperationActivityInstance AS _OperationActivityInstance ON OpActyNtwkInstance = _OperationActivityInstance.OpActyNtwkInstance AND OpActyNtwkElement = _OperationActivityInstance.OpActyNtwkElement  -- association [1..1]
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