P_SFIATOPACTYPLNDMATLRET

CDS View
45 Fields 1 CDS Views

Shop Floor Item At OA Planned Material Return

P_SFIATOPACTYPLNDMATLRET is a CDS View in S/4HANA. Shop Floor Item At OA Planned Material Return. It contains 45 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
C_SFIAtOpActyPlndMatlRet view from CONSUMPTION Shop Floor Item At OA Planned Material Return

Fields (45)

KeyField CDS FieldsUsed in Views
KEY ShopFloorItem ShopFloorItem 1
AssemblySequenceNumber AssemblySequenceNumber 1
BaseUnit BaseUnit 1
BillOfMaterial BillOfMaterial 1
BillOfMaterialInternalID BillOfMaterialInternalID 1
BillOfMaterialVariant BillOfMaterialVariant 1
BillOfMaterialVersion BillOfMaterialVersion 1
BOMItem BOMItem 1
BOMItemCategory BOMItemCategory 1
BOMItemInternalChangeCount BOMItemInternalChangeCount 1
BOOOpBOMItemInternalID BOOOpBOMItemInternalID 1
CompDisassemblyPermanence CompDisassemblyPermanence 1
FormulaKey FormulaKey 1
GoodsMovementIsAllowed GoodsMovementIsAllowed 1
InheritedBOMItemNode InheritedBOMItemNode 1
IsBatchManagementRequired IsBatchManagementRequired 1
IsBulkMaterialComponent IsBulkMaterialComponent 1
LeadingOpActyNtwkElement LeadingOpActyNtwkElement 1
LeadingOpActyNtwkInstance LeadingOpActyNtwkInstance 1
LeadingReservation LeadingReservation 1
LeadingReservationItem LeadingReservationItem 1
LeadingReservationRecordType LeadingReservationRecordType 1
LogicalComponent LogicalComponent 1
MatlCompAssembleControl MatlCompAssembleControl 1
MatlCompDiscontinuationType MatlCompDiscontinuationType 1
MatlCompInstceAssyIsRequired MatlCompInstceAssyIsRequired 1
MfgOrderComponentUsageQuantity MfgOrderComponentUsageQuantity 1
MfgRefStrucBOMLeafAssgmtUUID MfgRefStrucBOMLeafAssgmtUUID 1
MfgRefStrucItmDetIsContextual MfgRefStrucItmDetIsContextual 1
MfgRefStructureItemDetailUUID MfgRefStructureItemDetailUUID 1
PlannedInventoryUsabilityCode PlannedInventoryUsabilityCode 1
ProductionPlant ProductionPlant 1
RelatedOpActyNtwkElement RelatedOpActyNtwkElement 1
RelatedOpActyNtwkInstance RelatedOpActyNtwkInstance 1
RelatedRecordType RelatedRecordType 1
RelatedReservationItem RelatedReservationItem 1
SerialNumberProfile SerialNumberProfile 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.

-- Shop Floor Item At OA Planned Material Return
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_SFIATOPACTYPLNDMATLRET (
    SHOPFLOORITEM,
    ASSEMBLYSEQUENCENUMBER,
    BASEUNIT,
    BILLOFMATERIAL,
    BILLOFMATERIALINTERNALID,
    BILLOFMATERIALVARIANT,
    BILLOFMATERIALVERSION,
    BOMITEM,
    BOMITEMCATEGORY,
    BOMITEMINTERNALCHANGECOUNT,
    BOOOPBOMITEMINTERNALID,
    COMPDISASSEMBLYPERMANENCE,
    FORMULAKEY,
    GOODSMOVEMENTISALLOWED,
    INHERITEDBOMITEMNODE,
    ISBATCHMANAGEMENTREQUIRED,
    ISBULKMATERIALCOMPONENT,
    LEADINGOPACTYNTWKELEMENT,
    LEADINGOPACTYNTWKINSTANCE,
    LEADINGRESERVATION,
    LEADINGRESERVATIONITEM,
    LEADINGRESERVATIONRECORDTYPE,
    LOGICALCOMPONENT,
    MATLCOMPASSEMBLECONTROL,
    MATLCOMPDISCONTINUATIONTYPE,
    MATLCOMPINSTCEASSYISREQUIRED,
    MFGORDERCOMPONENTUSAGEQUANTITY,
    MFGREFSTRUCBOMLEAFASSGMTUUID,
    MFGREFSTRUCITMDETISCONTEXTUAL,
    MFGREFSTRUCTUREITEMDETAILUUID,
    PLANNEDINVENTORYUSABILITYCODE,
    PRODUCTIONPLANT,
    RELATEDOPACTYNTWKELEMENT,
    RELATEDOPACTYNTWKINSTANCE,
    RELATEDRECORDTYPE,
    RELATEDRESERVATIONITEM,
    SERIALNUMBERPROFILE,
    STOCKCHECKMESSAGETYPE,
    STORAGELOCATION,
    VARIABLESIZECOMPONENTQUANTITY,
    VARIABLESIZECOMPONENTUNIT,
    VARIABLESIZEDIMENSION1,
    VARIABLESIZEDIMENSION2,
    VARIABLESIZEDIMENSION3,
    VARIABLESIZEDIMENSIONUNIT,
    PRIMARY KEY (SHOPFLOORITEM)
);

Learn More