P_SFOTRACEABLEASSLDCOMP

CDS View
43 Fields 2 CDS Views

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

CDS Views using this table (2)

ViewTypeJoinVDMDescription
C_SFOAssldTraceableComponent view_entity from CONSUMPTION Shop floor order assld traceable comp
C_SFORetdTraceableMaterial view_entity from CONSUMPTION Obsolete SFI returned traceable material

Fields (43)

KeyField CDS FieldsUsed in Views
KEY DgtlMockUpCharcsUUID DgtlMockUpCharcsUUID 2
KEY OpActyNtwkElement OpActyNtwkElement 2
KEY OpActyNtwkInstance OpActyNtwkInstance 2
KEY Plant Plant 2
KEY RecordType RecordType 2
KEY Reservation Reservation 2
KEY ReservationItem ReservationItem 2
KEY ShopFloorItem ShopFloorItem 2
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
InheritedNodeNumberForBOMItem InheritedNodeNumberForBOMItem 2
InheritedNodeNumberVersionBOM InheritedNodeNumberVersionBOM 2
ManufacturerSerialNumber ManufacturerSerialNumber 2
ManufacturingOrder ManufacturingOrder 2
MaterialBaseUnit MaterialBaseUnit 2
MatlCompAssembleControl MatlCompAssembleControl 2
MfgOrdCompAlternativeType MfgOrdCompAlternativeType 1
MfgRefStrucItmDetIsContextual MfgRefStrucItmDetIsContextual 2
MfgRefStructureItemDetailUUID MfgRefStructureItemDetailUUID 2
OperationText MfgOrderOperationText 2
OrderInternalID OrderInternalID 2
OrderOperationInternalID OrderOperationInternalID 2
ReferenceDesignatorValue 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_SFOTRACEABLEASSLDCOMP (
    DGTLMOCKUPCHARCSUUID,
    OPACTYNTWKELEMENT,
    OPACTYNTWKINSTANCE,
    PLANT,
    RECORDTYPE,
    RESERVATION,
    RESERVATIONITEM,
    SHOPFLOORITEM,
    ALTERNATIVEITEMGROUP,
    ASSEMBLY,
    BILLOFMATERIALCATEGORY,
    BILLOFMATERIALINTERNALID,
    BILLOFMATERIALITEMNUMBER,
    BILLOFMATERIALVARIANT,
    BILLOFMATERIALVERSION,
    BOMITEM,
    BOMITEMCATEGORY,
    BOMITEMINTERNALCHANGECOUNT,
    EFFECTIVITYPARAMETERVARIANT,
    ENTRYUNIT,
    FORMULAKEY,
    INHERITEDNODENUMBERFORBOMITEM,
    INHERITEDNODENUMBERVERSIONBOM,
    MANUFACTURERSERIALNUMBER,
    MANUFACTURINGORDER,
    MATERIALBASEUNIT,
    MATLCOMPASSEMBLECONTROL,
    MFGORDCOMPALTERNATIVETYPE,
    MFGREFSTRUCITMDETISCONTEXTUAL,
    MFGREFSTRUCTUREITEMDETAILUUID,
    OPERATIONTEXT,
    ORDERINTERNALID,
    ORDEROPERATIONINTERNALID,
    REFERENCEDESIGNATORVALUE,
    REQUIREDQUANTITYINBASEUNIT,
    RESVNITMTOTALWITHDRAWNQTY,
    RESVNITMWITHDRAWNQTYINBASEUNIT,
    VARIABLESIZECOMPONENTQUANTITY,
    VARIABLESIZECOMPONENTUNIT,
    VARIABLESIZEDIMENSION1,
    VARIABLESIZEDIMENSION2,
    VARIABLESIZEDIMENSION3,
    VARIABLESIZEDIMENSIONUNIT,
    PRIMARY KEY (DGTLMOCKUPCHARCSUUID, OPACTYNTWKELEMENT, OPACTYNTWKINSTANCE, PLANT, RECORDTYPE, RESERVATION, RESERVATIONITEM, SHOPFLOORITEM)
);

Learn More