P_SFIASSEMBLEDCOMPONENT2

CDS View
48 Fields 1 CDS Views

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

CDS Views using this table (1)

ViewTypeJoinVDMDescription
C_SFIAssembledComponent view from CONSUMPTION Component Assembled into a SFI (Manual and Backflushed)

Fields (48)

KeyField CDS FieldsUsed in Views
KEY AssemblyShopFloorItem AssemblyShopFloorItem 1
KEY Material Material 1
KEY Plant Plant 1
KEY RecordType RecordType 1
KEY Reservation Reservation 1
KEY ReservationItem ReservationItem 1
_AssemblyShopFloorItem _AssemblyShopFloorItem 1
_Material _Material 1
_Plant _Plant 1
_Reservation _Reservation 1
_StorageLocation _StorageLocation 1
BillOfMaterialCategory BillOfMaterialCategory 1
BillOfMaterialInternalID BillOfMaterialInternalID 1
BillOfMaterialVariant BillOfMaterialVariant 1
BillOfMaterialVersion BillOfMaterialVersion 1
BOMItem BOMItem 1
BOMItemCategory BOMItemCategory 1
BOMItemInternalChangeCount BOMItemInternalChangeCount 1
BOOOpBOMItemInternalID BOOOpBOMItemInternalID 1
EntryUnit EntryUnit 1
FormulaKey FormulaKey 1
GoodsMovementIsAllowed GoodsMovementIsAllowed 1
InheritedBOMItemNode InheritedBOMItemNode 1
IsBatchManagementRequired IsBatchManagementRequired 1
LogicalComponent LogicalComponent 1
MaterialBaseUnit MaterialBaseUnit 1
MaterialComponentQuantity MaterialComponentQuantity 1
MatlCompAssembleControl MatlCompAssembleControl 1
MatlCompInstceAssyIsRequired MatlCompInstceAssyIsRequired 1
MatlCompIsMarkedForBackflush MatlCompIsMarkedForBackflush 1
MfgRefStrucBOMLeafAssgmtUUID MfgRefStrucBOMLeafAssgmtUUID 1
MfgRefStrucItmDetIsContextual MfgRefStrucItmDetIsContextual 1
MfgRefStructureItemDetailUUID MfgRefStructureItemDetailUUID 1
OrderInternalID OrderInternalID 1
OrderOperationInternalID OrderOperationInternalID 1
QuantityInEntryUnit QuantityInEntryUnit 1
RequiredQuantity RequiredQuantity 1
RequiredQuantityInBaseUnit RequiredQuantityInBaseUnit 1
ResvnItmWithdrawnQtyInBaseUnit ResvnItmWithdrawnQtyInBaseUnit 1
SerialNumberIsRqdForAssembly SerialNumberIsRqdForAssembly 1
StockCheckMessageType StockCheckMessageType 1
StorageLocation StorageLocation 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_SFIASSEMBLEDCOMPONENT2 (
    ASSEMBLYSHOPFLOORITEM,
    MATERIAL,
    PLANT,
    RECORDTYPE,
    RESERVATION,
    RESERVATIONITEM,
    _ASSEMBLYSHOPFLOORITEM,
    _MATERIAL,
    _PLANT,
    _RESERVATION,
    _STORAGELOCATION,
    BILLOFMATERIALCATEGORY,
    BILLOFMATERIALINTERNALID,
    BILLOFMATERIALVARIANT,
    BILLOFMATERIALVERSION,
    BOMITEM,
    BOMITEMCATEGORY,
    BOMITEMINTERNALCHANGECOUNT,
    BOOOPBOMITEMINTERNALID,
    ENTRYUNIT,
    FORMULAKEY,
    GOODSMOVEMENTISALLOWED,
    INHERITEDBOMITEMNODE,
    ISBATCHMANAGEMENTREQUIRED,
    LOGICALCOMPONENT,
    MATERIALBASEUNIT,
    MATERIALCOMPONENTQUANTITY,
    MATLCOMPASSEMBLECONTROL,
    MATLCOMPINSTCEASSYISREQUIRED,
    MATLCOMPISMARKEDFORBACKFLUSH,
    MFGREFSTRUCBOMLEAFASSGMTUUID,
    MFGREFSTRUCITMDETISCONTEXTUAL,
    MFGREFSTRUCTUREITEMDETAILUUID,
    ORDERINTERNALID,
    ORDEROPERATIONINTERNALID,
    QUANTITYINENTRYUNIT,
    REQUIREDQUANTITY,
    REQUIREDQUANTITYINBASEUNIT,
    RESVNITMWITHDRAWNQTYINBASEUNIT,
    SERIALNUMBERISRQDFORASSEMBLY,
    STOCKCHECKMESSAGETYPE,
    STORAGELOCATION,
    VARIABLESIZECOMPONENTQUANTITY,
    VARIABLESIZECOMPONENTUNIT,
    VARIABLESIZEDIMENSION1,
    VARIABLESIZEDIMENSION2,
    VARIABLESIZEDIMENSION3,
    VARIABLESIZEDIMENSIONUNIT,
    PRIMARY KEY (ASSEMBLYSHOPFLOORITEM, MATERIAL, PLANT, RECORDTYPE, RESERVATION, RESERVATIONITEM)
);

Learn More