P_SFITRACEABLEASSLDCOMP

CDS View
51 Fields 2 CDS Views

P_SFITRACEABLEASSLDCOMP is a CDS View in S/4HANA. It contains 51 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
C_SFIAssldTraceableComponent view_entity from CONSUMPTION Shop floor item assembled traceable component
C_SFIRetdTraceableMaterial view_entity from CONSUMPTION Obsolete SFI returned traceable material

Fields (51)

KeyField CDS FieldsUsed in Views
KEY AssemblyShopFloorItem AssemblyShopFloorItem 2
KEY DgtlMockUpCharcsUUID DgtlMockUpCharcsUUID 2
KEY OpActyNtwkElement OpActyNtwkElement 2
KEY OpActyNtwkInstance OpActyNtwkInstance 2
KEY OriglDgtlMockUpCharcsUUID OriglDgtlMockUpCharcsUUID 1
KEY Plant Plant 2
KEY RecordType RecordType 2
KEY Reservation Reservation 2
KEY ReservationItem ReservationItem 2
KEY ShopFloorItem ShopFloorItem 2
_Material _Material 2
_MatlCompAssembleControl _MatlCompAssembleControl 2
ActiveReplaceShopFloorItem ActiveReplaceShopFloorItem 1
AlternativeItemGroup AlternativeItemGroup 1
Assembly Assembly 2
BillOfMaterialCategory BillOfMaterialCategory 2
BillOfMaterialInternalID BillOfMaterialInternalID 2
BillOfMaterialItemNumber BillOfMaterialItemNumber 2
BillOfMaterialVariant BillOfMaterialVariant 2
BillOfMaterialVersion BillOfMaterialVersion 2
BOMItem BOMItem 2
BOMItemCategory BOMItemCategory 2
BOMItemInternalChangeCount BOMItemInternalChangeCount 2
EffectivityParameterVariant EffectivityParameterVariant 2
EntryUnit EntryUnit 2
FormulaKey FormulaKey 2
InheritedBOMItemNode InheritedBOMItemNode 1
InheritedNodeNumberForBOMItem InheritedNodeNumberForBOMItem 2
InheritedNodeNumberVersionBOM InheritedNodeNumberVersionBOM 2
ManufacturerSerialNumber ManufacturerSerialNumber 2
MaterialBaseUnit MaterialBaseUnit 2
MatlCompAssembleControl MatlCompAssembleControl 2
MfgOrdCompAlternativeType MfgOrdCompAlternativeType 1
MfgOrderOperationText MfgOrderOperationText 2
MfgRefStrucItmDetIsContextual MfgRefStrucItmDetIsContextual 2
MfgRefStructureItemDetailUUID MfgRefStructureItemDetailUUID 2
OrderInternalID OrderInternalID 2
OrderOperationInternalID OrderOperationInternalID 2
OriginalReplacedShopFloorItem OriginalReplacedShopFloorItem 2
OriginalReservation OriginalReservation 1
OriginalReservationItem OriginalReservationItem 1
ReferenceDesignatorValue ReferenceDesignatorName,ReferenceDesignatorValue 2
RequiredQuantityInBaseUnit RequiredQuantityInBaseUnit 2
ResvnItmTotalWithdrawnQty ResvnItmTotalWithdrawnQty 2
ResvnItmWithdrawnQtyInBaseUnit ResvnItmWithdrawnQtyInBaseUnit 1
VariableSizeComponentQuantity VariableSizeComponentQuantity 2
VariableSizeComponentUnit VariableSizeComponentUnit 2
VariableSizeDimension1 VariableSizeDimension1 2
VariableSizeDimension2 VariableSizeDimension2 2
VariableSizeDimension3 VariableSizeDimension3 2
VariableSizeDimensionUnit VariableSizeDimensionUnit 2

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_SFITRACEABLEASSLDCOMP (
    ASSEMBLYSHOPFLOORITEM,
    DGTLMOCKUPCHARCSUUID,
    OPACTYNTWKELEMENT,
    OPACTYNTWKINSTANCE,
    ORIGLDGTLMOCKUPCHARCSUUID,
    PLANT,
    RECORDTYPE,
    RESERVATION,
    RESERVATIONITEM,
    SHOPFLOORITEM,
    _MATERIAL,
    _MATLCOMPASSEMBLECONTROL,
    ACTIVEREPLACESHOPFLOORITEM,
    ALTERNATIVEITEMGROUP,
    ASSEMBLY,
    BILLOFMATERIALCATEGORY,
    BILLOFMATERIALINTERNALID,
    BILLOFMATERIALITEMNUMBER,
    BILLOFMATERIALVARIANT,
    BILLOFMATERIALVERSION,
    BOMITEM,
    BOMITEMCATEGORY,
    BOMITEMINTERNALCHANGECOUNT,
    EFFECTIVITYPARAMETERVARIANT,
    ENTRYUNIT,
    FORMULAKEY,
    INHERITEDBOMITEMNODE,
    INHERITEDNODENUMBERFORBOMITEM,
    INHERITEDNODENUMBERVERSIONBOM,
    MANUFACTURERSERIALNUMBER,
    MATERIALBASEUNIT,
    MATLCOMPASSEMBLECONTROL,
    MFGORDCOMPALTERNATIVETYPE,
    MFGORDEROPERATIONTEXT,
    MFGREFSTRUCITMDETISCONTEXTUAL,
    MFGREFSTRUCTUREITEMDETAILUUID,
    ORDERINTERNALID,
    ORDEROPERATIONINTERNALID,
    ORIGINALREPLACEDSHOPFLOORITEM,
    ORIGINALRESERVATION,
    ORIGINALRESERVATIONITEM,
    REFERENCEDESIGNATORVALUE,
    REQUIREDQUANTITYINBASEUNIT,
    RESVNITMTOTALWITHDRAWNQTY,
    RESVNITMWITHDRAWNQTYINBASEUNIT,
    VARIABLESIZECOMPONENTQUANTITY,
    VARIABLESIZECOMPONENTUNIT,
    VARIABLESIZEDIMENSION1,
    VARIABLESIZEDIMENSION2,
    VARIABLESIZEDIMENSION3,
    VARIABLESIZEDIMENSIONUNIT,
    PRIMARY KEY (ASSEMBLYSHOPFLOORITEM, DGTLMOCKUPCHARCSUUID, OPACTYNTWKELEMENT, OPACTYNTWKINSTANCE, ORIGLDGTLMOCKUPCHARCSUUID, PLANT, RECORDTYPE, RESERVATION, RESERVATIONITEM, SHOPFLOORITEM)
);

Learn More