P_SFONONTRCBLCOMPONENTASSEMBLY

CDS View
37 Fields 2 CDS Views

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

CDS Views using this table (2)

ViewTypeJoinVDMDescription
C_SFOAssldNonTrcblComponent view_entity from CONSUMPTION SFO assembled non traceable component
C_SFORetdNonTraceableMaterial view_entity from CONSUMPTION Obsolete SFO returned non traceable mat

Fields (37)

KeyField CDS FieldsUsed in Views
KEY OpActyNtwkElement OpActyNtwkElement 2
KEY OpActyNtwkInstance OpActyNtwkInstance 2
KEY RecordType RecordType 2
KEY Reservation Reservation 2
KEY ReservationItem ReservationItem 2
_Batch _Batch 2
_Material _Material 2
_StorageLocation _StorageLocation 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
MaterialBaseUnit MaterialBaseUnit 2
MatlCompAssembleControl MatlCompAssembleControl 2
MfgOrderOperationText MfgOrderOperationText 2
OrderInternalID OrderInternalID 2
OrderOperationInternalID OrderOperationInternalID 2
Plant Plant 2
RequiredQuantityInBaseUnit RequiredQuantityInBaseUnit 1
ResvnItmWithdrawnQtyInBaseUnit ResvnItmTotalWithdrawnQty,ResvnItmWithdrawnQtyInBaseUnit 1
StorageLocation StorageLocation 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_SFONONTRCBLCOMPONENTASSEMBLY (
    OPACTYNTWKELEMENT,
    OPACTYNTWKINSTANCE,
    RECORDTYPE,
    RESERVATION,
    RESERVATIONITEM,
    _BATCH,
    _MATERIAL,
    _STORAGELOCATION,
    ASSEMBLY,
    BILLOFMATERIALCATEGORY,
    BILLOFMATERIALINTERNALID,
    BILLOFMATERIALITEMNUMBER,
    BILLOFMATERIALVARIANT,
    BILLOFMATERIALVERSION,
    BOMITEM,
    BOMITEMCATEGORY,
    BOMITEMINTERNALCHANGECOUNT,
    EFFECTIVITYPARAMETERVARIANT,
    ENTRYUNIT,
    FORMULAKEY,
    INHERITEDNODENUMBERFORBOMITEM,
    INHERITEDNODENUMBERVERSIONBOM,
    MATERIALBASEUNIT,
    MATLCOMPASSEMBLECONTROL,
    MFGORDEROPERATIONTEXT,
    ORDERINTERNALID,
    ORDEROPERATIONINTERNALID,
    PLANT,
    REQUIREDQUANTITYINBASEUNIT,
    RESVNITMWITHDRAWNQTYINBASEUNIT,
    STORAGELOCATION,
    VARIABLESIZECOMPONENTQUANTITY,
    VARIABLESIZECOMPONENTUNIT,
    VARIABLESIZEDIMENSION1,
    VARIABLESIZEDIMENSION2,
    VARIABLESIZEDIMENSION3,
    VARIABLESIZEDIMENSIONUNIT,
    PRIMARY KEY (OPACTYNTWKELEMENT, OPACTYNTWKINSTANCE, RECORDTYPE, RESERVATION, RESERVATIONITEM)
);

Learn More