P_SFIASSEMBLEDCOMPONENT

CDS View
40 Fields 1 CDS Views

P_SFIASSEMBLEDCOMPONENT is a CDS View in S/4HANA. It contains 40 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_SFIAssembledComponent2 view from CONSUMPTION

Fields (40)

KeyField CDS FieldsUsed in Views
KEY AssemblyShopFloorItem AssemblyShopFloorItem 1
KEY Material Material 1
KEY OpActyNtwkElement OpActyNtwkElement 1
KEY OpActyNtwkInstance OpActyNtwkInstance 1
KEY Plant Plant 1
KEY RecordType RecordType 1
KEY Reservation Reservation 1
KEY ReservationItem ReservationItem 1
_BOMItemCategory _BOMItemCategory 1
_Material _Material 1
_OpActyNtwkInstance _OpActyNtwkInstance 1
_OperationActivityInstance _OperationActivityInstance 1
_Plant _Plant 1
_ProductPlant _ProductPlant 1
BOMItem BOMItem 1
BOMItemCategory BOMItemCategory 1
BOMItemInternalChangeCount BOMItemInternalChangeCount 1
BOOOpBOMItemInternalID BOOOpBOMItemInternalID 1
EntryUnit EntryUnit 1
FormulaKey FormulaKey 1
GoodsMovementIsAllowed GoodsMovementIsAllowed 1
LogicalComponent LogicalComponent 1
MaterialBaseUnit MaterialBaseUnit 1
MatlCompInstceAssyIsRequired MatlCompInstceAssyIsRequired 1
MatlCompIsMarkedForBackflush MatlCompIsMarkedForBackflush 1
MfgOrderComponentUsageNetQty MfgOrderComponentUsageNetQty 1
MfgRefStrucBOMLeafAssgmtUUID MfgRefStrucBOMLeafAssgmtUUID 1
MfgRefStrucItmDetIsContextual MfgRefStrucItmDetIsContextual 1
MfgRefStructureItemDetailUUID MfgRefStructureItemDetailUUID 1
OpActyNtwkVersionCounter OpActyNtwkVersionCounter 1
OperationActivityNetwork OperationActivityNetwork 1
OrderInternalID OrderInternalID 1
OrderOperationInternalID OrderOperationInternalID 1
QuantityInEntryUnit QuantityInEntryUnit 1
VariableSizeComponentQuantity VariableSizeComponentQuantity 1
VariableSizeComponentUnit VariableSizeComponentUnit 1
VariableSizeDimension1 VariableSizeDimension1 1
VariableSizeDimension2 VariableSizeDimension2 1
VariableSizeDimension3 VariableSizeDimension3 1
VariableSizeDimensionUnit VariableSizeDimensionUnit 1

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_SFIASSEMBLEDCOMPONENT (
    ASSEMBLYSHOPFLOORITEM,
    MATERIAL,
    OPACTYNTWKELEMENT,
    OPACTYNTWKINSTANCE,
    PLANT,
    RECORDTYPE,
    RESERVATION,
    RESERVATIONITEM,
    _BOMITEMCATEGORY,
    _MATERIAL,
    _OPACTYNTWKINSTANCE,
    _OPERATIONACTIVITYINSTANCE,
    _PLANT,
    _PRODUCTPLANT,
    BOMITEM,
    BOMITEMCATEGORY,
    BOMITEMINTERNALCHANGECOUNT,
    BOOOPBOMITEMINTERNALID,
    ENTRYUNIT,
    FORMULAKEY,
    GOODSMOVEMENTISALLOWED,
    LOGICALCOMPONENT,
    MATERIALBASEUNIT,
    MATLCOMPINSTCEASSYISREQUIRED,
    MATLCOMPISMARKEDFORBACKFLUSH,
    MFGORDERCOMPONENTUSAGENETQTY,
    MFGREFSTRUCBOMLEAFASSGMTUUID,
    MFGREFSTRUCITMDETISCONTEXTUAL,
    MFGREFSTRUCTUREITEMDETAILUUID,
    OPACTYNTWKVERSIONCOUNTER,
    OPERATIONACTIVITYNETWORK,
    ORDERINTERNALID,
    ORDEROPERATIONINTERNALID,
    QUANTITYINENTRYUNIT,
    VARIABLESIZECOMPONENTQUANTITY,
    VARIABLESIZECOMPONENTUNIT,
    VARIABLESIZEDIMENSION1,
    VARIABLESIZEDIMENSION2,
    VARIABLESIZEDIMENSION3,
    VARIABLESIZEDIMENSIONUNIT,
    PRIMARY KEY (ASSEMBLYSHOPFLOORITEM, MATERIAL, OPACTYNTWKELEMENT, OPACTYNTWKINSTANCE, PLANT, RECORDTYPE, RESERVATION, RESERVATIONITEM)
);

Learn More