P_MFGORDERPRTASSGMTDETAIL

CDS View
37 Fields 6 CDS Views

P_MFGORDERPRTASSGMTDETAIL is a CDS View in S/4HANA. It contains 37 fields. 6 CDS views read from this table.

CDS Views using this table (6)

ViewTypeJoinVDMDescription
C_OpActyInstcePlndPRTNoDoc view_entity inner CONSUMPTION Planned SFI at OA excluding Documents
I_MfgOrderPRTAssignmentDetail view_entity from COMPOSITE Mfg Order PRT Assignment Details
I_SFIOpActyNonTrcblUsedPRT view_entity inner COMPOSITE SFI used non traceable PRT
I_SFOOpActyNonTrcblUsedPRT view_entity inner COMPOSITE Shop floor order used non traceable PRT
P_OperationActyPlannedPRT view_entity inner CONSUMPTION
P_SFIOperationActivityPlndPRT view_entity inner CONSUMPTION

Fields (37)

KeyField CDS FieldsUsed in Views
KEY MfgOrderOpProdnRsceToolIntID MfgOrderOpProdnRsceToolIntID 1
KEY OrderInternalID OrderInternalID 1
_Equipment _Equipment 3
_LogisticsOrder _LogisticsOrder 1
_Material _Material 6
_MfgOrderCategory _MfgOrderCategory 4
_MfgOrderType _MfgOrderType 4
_MiscProdnRsceToolText _MiscProdnRsceToolText 3
_ProdnRsceToolCategory _ProdnRsceToolCategory 4
_ProductionPlant _ProductionPlant 2
_ProductionResourceType _ProductionResourceType 2
_PRTRegistrationControl _PRTRegistrationControl 3
BOOOperationPRTInternalID BOOOperationPRTInternalID 4
DocumentInfoRecord DocumentInfoRecord 5
DocumentPart DocumentPart 5
DocumentType DocumentType 5
DocumentVersion DocumentVersion 5
Equipment Equipment 4
ManufacturingOrder ManufacturingOrder 2
ManufacturingOrderCategory ManufacturingOrderCategory 4
ManufacturingOrderType ManufacturingOrderType 4
Material Material 6
MiscProductionResourceTool MiscProductionResourceTool 6
OrderProdnRsceToolText OrderProdnRsceToolText 5
PlannedProdnRsceToolQtyUnit PlannedProdnRsceToolQtyUnit 6
PlannedTotalProdnRsceToolQty PlannedTotalProdnRsceToolQty 6
ProdnRsceToolCategory ProdnRsceToolCategory 5
ProdnRsceToolItemNumber ProdnRsceToolItemNumber 6
ProdnRsceToolRegnIsAllowed ProdnRsceToolRegnIsAllowed 4
ProdnRsceToolStandardWorkQty ProdnRsceToolStandardWorkQty 3
ProdnRsceToolStdWorkQtyUnit ProdnRsceToolStdWorkQtyUnit 3
ProductionPlant Plant,ProductionPlant 6
ProductionResourceInternalID ProductionResourceInternalID 6
ProductionResourceType ProductionResourceType 6
PRTRegistrationControl PRTRegistrationControl 4
SerialNumberUsageInAssignment SerialNumberUsageInAssignment 1
ShopFloorRtgPRTIsRegistrable ShopFloorRtgPRTIsRegistrable 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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_MFGORDERPRTASSGMTDETAIL (
    MFGORDEROPPRODNRSCETOOLINTID,
    ORDERINTERNALID,
    _EQUIPMENT,
    _LOGISTICSORDER,
    _MATERIAL,
    _MFGORDERCATEGORY,
    _MFGORDERTYPE,
    _MISCPRODNRSCETOOLTEXT,
    _PRODNRSCETOOLCATEGORY,
    _PRODUCTIONPLANT,
    _PRODUCTIONRESOURCETYPE,
    _PRTREGISTRATIONCONTROL,
    BOOOPERATIONPRTINTERNALID,
    DOCUMENTINFORECORD,
    DOCUMENTPART,
    DOCUMENTTYPE,
    DOCUMENTVERSION,
    EQUIPMENT,
    MANUFACTURINGORDER,
    MANUFACTURINGORDERCATEGORY,
    MANUFACTURINGORDERTYPE,
    MATERIAL,
    MISCPRODUCTIONRESOURCETOOL,
    ORDERPRODNRSCETOOLTEXT,
    PLANNEDPRODNRSCETOOLQTYUNIT,
    PLANNEDTOTALPRODNRSCETOOLQTY,
    PRODNRSCETOOLCATEGORY,
    PRODNRSCETOOLITEMNUMBER,
    PRODNRSCETOOLREGNISALLOWED,
    PRODNRSCETOOLSTANDARDWORKQTY,
    PRODNRSCETOOLSTDWORKQTYUNIT,
    PRODUCTIONPLANT,
    PRODUCTIONRESOURCEINTERNALID,
    PRODUCTIONRESOURCETYPE,
    PRTREGISTRATIONCONTROL,
    SERIALNUMBERUSAGEINASSIGNMENT,
    SHOPFLOORRTGPRTISREGISTRABLE,
    PRIMARY KEY (MFGORDEROPPRODNRSCETOOLINTID, ORDERINTERNALID)
);

Learn More