P_SFINONTRCBLCOMPONENTASSEMBLY

CDS View
39 Fields 3 CDS Views

Shop floor item assembled non-traceable component

P_SFINONTRCBLCOMPONENTASSEMBLY is a CDS View in S/4HANA. Shop floor item assembled non-traceable component. It contains 39 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
C_SFIAssldNonTrcblComponent view_entity from CONSUMPTION SFI assembled non traceable component
C_SFIDsassldNonTrcblComponent view_entity from CONSUMPTION SFI disassembled non traceable component
C_SFIRetdNonTraceableMaterial view_entity from CONSUMPTION SFI returned non traceable material

Fields (39)

KeyField CDS FieldsUsed in Views
KEY AssemblyShopFloorItem AssemblyShopFloorItem 3
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
OriginalReplacedShopFloorItem OriginalReplacedShopFloorItem 3
Plant Plant 3
ResvnItmWithdrawnQtyInBaseUnit ResvnItmWithdrawnQtyInBaseUnit 2
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.

-- Shop floor item assembled non-traceable component
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_SFINONTRCBLCOMPONENTASSEMBLY (
    ASSEMBLYSHOPFLOORITEM,
    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,
    ORIGINALREPLACEDSHOPFLOORITEM,
    PLANT,
    RESVNITMWITHDRAWNQTYINBASEUNIT,
    STORAGELOCATION,
    VARIABLESIZECOMPONENTQUANTITY,
    VARIABLESIZECOMPONENTUNIT,
    VARIABLESIZEDIMENSION1,
    VARIABLESIZEDIMENSION2,
    VARIABLESIZEDIMENSION3,
    VARIABLESIZEDIMENSIONUNIT,
    PRIMARY KEY (ASSEMBLYSHOPFLOORITEM, OPACTYNTWKELEMENT, OPACTYNTWKINSTANCE, RECORDTYPE, RESERVATION, RESERVATIONITEM)
);

Learn More