P_SFONONTRCBLCOMPONENTASSEMBLY

CDS View
38 Fields 3 CDS Views

SFI non-traceable Component by Leading RESB

P_SFONONTRCBLCOMPONENTASSEMBLY is a CDS View in S/4HANA. SFI non-traceable Component by Leading RESB. It contains 38 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
C_SFOAssldNonTrcblComponent view_entity from CONSUMPTION SFO assembled non traceable component
C_SFODsassldNonTrcblComponent view_entity from CONSUMPTION SFO disassembled non traceable component
C_SFORetdNonTraceableMaterial view_entity from CONSUMPTION SFO returned non traceable material

Fields (38)

KeyField CDS FieldsUsed in Views
KEY OpActyNtwkElement OpActyNtwkElement 3
KEY OpActyNtwkInstance OpActyNtwkInstance 3
KEY RecordType RecordType 3
KEY Reservation Reservation 3
KEY ReservationItem ReservationItem 3
_Batch _Batch 3
_Material _Material 3
_StorageLocation _StorageLocation 1
Assembly Assembly 3
BillOfMaterialCategory BillOfMaterialCategory 3
BillOfMaterialInternalID BillOfMaterialInternalID 3
BillOfMaterialItemNumber BillOfMaterialItemNumber 3
BillOfMaterialVariant BillOfMaterialVariant 3
BillOfMaterialVersion BillOfMaterialVersion 3
BOMItem BOMItem 3
BOMItemCategory BOMItemCategory 3
BOMItemInternalChangeCount BOMItemInternalChangeCount 3
EffectivityParameterVariant EffectivityParameterVariant 3
EntryUnit EntryUnit 3
FormulaKey FormulaKey 3
InheritedNodeNumberForBOMItem InheritedNodeNumberForBOMItem 3
InheritedNodeNumberVersionBOM InheritedNodeNumberVersionBOM 3
MaterialBaseUnit MaterialBaseUnit 3
MaterialComponentQuantity MaterialComponentQuantity 1
MatlCompAssembleControl MatlCompAssembleControl 3
MfgOrderOperationText MfgOrderOperationText 3
OrderInternalID OrderInternalID 3
OrderOperationInternalID OrderOperationInternalID 3
Plant Plant 3
RequiredQuantityInBaseUnit RequiredQuantityInBaseUnit 2
ResvnItmWithdrawnQtyInBaseUnit ResvnItmWithdrawnQtyInBaseUnit 1
StorageLocation StorageLocation 1
VariableSizeComponentQuantity VariableSizeComponentQuantity 3
VariableSizeComponentUnit VariableSizeComponentUnit 3
VariableSizeDimension1 VariableSizeDimension1 3
VariableSizeDimension2 VariableSizeDimension2 3
VariableSizeDimension3 VariableSizeDimension3 3
VariableSizeDimensionUnit VariableSizeDimensionUnit 3

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.

-- SFI non-traceable Component by Leading RESB
-- 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,
    MATERIALCOMPONENTQUANTITY,
    MATLCOMPASSEMBLECONTROL,
    MFGORDEROPERATIONTEXT,
    ORDERINTERNALID,
    ORDEROPERATIONINTERNALID,
    PLANT,
    REQUIREDQUANTITYINBASEUNIT,
    RESVNITMWITHDRAWNQTYINBASEUNIT,
    STORAGELOCATION,
    VARIABLESIZECOMPONENTQUANTITY,
    VARIABLESIZECOMPONENTUNIT,
    VARIABLESIZEDIMENSION1,
    VARIABLESIZEDIMENSION2,
    VARIABLESIZEDIMENSION3,
    VARIABLESIZEDIMENSIONUNIT,
    PRIMARY KEY (OPACTYNTWKELEMENT, OPACTYNTWKINSTANCE, RECORDTYPE, RESERVATION, RESERVATIONITEM)
);

Learn More