P_SFIOPERATIONACTIVITYPLNDPRT

CDS View
38 Fields 1 CDS Views

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

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_SFIOperationActivityPRTUnion view_entity from CONSUMPTION

Fields (38)

KeyField CDS FieldsUsed in Views
KEY Equipment Equipment 1
KEY MfgOrderOpProdnRsceToolIntID MfgOrderOpProdnRsceToolIntID 1
KEY OpActyNtwkElement OpActyNtwkElement 1
KEY OpActyNtwkInstance OpActyNtwkInstance 1
KEY OrderInternalID OrderInternalID 1
KEY ProductionResourceInternalID ProductionResourceInternalID 1
KEY ProductionResourceType ProductionResourceType 1
KEY ShopFloorItem ShopFloorItem 1
_Equipment _Equipment 1
_Material _Material 1
_MfgOrderCategory _MfgOrderCategory 1
_MfgOrderType _MfgOrderType 1
_OperationActivityInstance _OperationActivityInstance 1
_OrdInternalBillOfOperations _OrdInternalBillOfOperations 1
BaseUnit BaseUnit 1
BOOOperationPRTInternalID BOOOperationPRTInternalID 1
DocumentInfoRecord DocumentInfoRecord 1
DocumentPart DocumentPart 1
DocumentType DocumentType 1
DocumentVersion DocumentVersion 1
ManufacturingOrderCategory ManufacturingOrderCategory 1
ManufacturingOrderType ManufacturingOrderType 1
Material Material 1
MiscProductionResourceTool MiscProductionResourceTool 1
NumberOfActvEquipRegistrations NumberOfActvEquipRegistrations 1
OrderProdnRsceToolText OrderProdnRsceToolText 1
PlannedProdnRsceToolQtyUnit PlannedProdnRsceToolQtyUnit 1
PlannedTotalProdnRsceToolQty PlannedTotalProdnRsceToolQty 1
ProdnRsceToolCategory ProdnRsceToolCategory 1
ProdnRsceToolItemNumber ProdnRsceToolItemNumber 1
ProdnRsceToolRegnIsAllowed ProdnRsceToolRegnIsAllowed 1
ProdnRsceToolStandardWorkQty ProdnRsceToolStandardWorkQty 1
ProdnRsceToolStdWorkQtyUnit ProdnRsceToolStdWorkQtyUnit 1
ProductionPlant ProductionPlant 1
PRTIsUsedAsTestEquipment PRTIsUsedAsTestEquipment 1
PRTRegistrationControl PRTRegistrationControl 1
RegisteredPRTQtyInBaseUnit RegisteredPRTQtyInBaseUnit 1
ShopFloorRtgPRTIsRegistrable ShopFloorRtgPRTIsRegistrable 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_SFIOPERATIONACTIVITYPLNDPRT (
    EQUIPMENT,
    MFGORDEROPPRODNRSCETOOLINTID,
    OPACTYNTWKELEMENT,
    OPACTYNTWKINSTANCE,
    ORDERINTERNALID,
    PRODUCTIONRESOURCEINTERNALID,
    PRODUCTIONRESOURCETYPE,
    SHOPFLOORITEM,
    _EQUIPMENT,
    _MATERIAL,
    _MFGORDERCATEGORY,
    _MFGORDERTYPE,
    _OPERATIONACTIVITYINSTANCE,
    _ORDINTERNALBILLOFOPERATIONS,
    BASEUNIT,
    BOOOPERATIONPRTINTERNALID,
    DOCUMENTINFORECORD,
    DOCUMENTPART,
    DOCUMENTTYPE,
    DOCUMENTVERSION,
    MANUFACTURINGORDERCATEGORY,
    MANUFACTURINGORDERTYPE,
    MATERIAL,
    MISCPRODUCTIONRESOURCETOOL,
    NUMBEROFACTVEQUIPREGISTRATIONS,
    ORDERPRODNRSCETOOLTEXT,
    PLANNEDPRODNRSCETOOLQTYUNIT,
    PLANNEDTOTALPRODNRSCETOOLQTY,
    PRODNRSCETOOLCATEGORY,
    PRODNRSCETOOLITEMNUMBER,
    PRODNRSCETOOLREGNISALLOWED,
    PRODNRSCETOOLSTANDARDWORKQTY,
    PRODNRSCETOOLSTDWORKQTYUNIT,
    PRODUCTIONPLANT,
    PRTISUSEDASTESTEQUIPMENT,
    PRTREGISTRATIONCONTROL,
    REGISTEREDPRTQTYINBASEUNIT,
    SHOPFLOORRTGPRTISREGISTRABLE,
    PRIMARY KEY (EQUIPMENT, MFGORDEROPPRODNRSCETOOLINTID, OPACTYNTWKELEMENT, OPACTYNTWKINSTANCE, ORDERINTERNALID, PRODUCTIONRESOURCEINTERNALID, PRODUCTIONRESOURCETYPE, SHOPFLOORITEM)
);

Learn More