PRTASSGMT

29 Fields

PRTASSGMT is an SAP database table in S/4HANA. It contains 29 fields.

Fields (29)

KeyField CDS FieldsUsed in Views
KEY BillOfOperationsGroup MasterRecipeGroup 4
KEY BillOfOperationsSequence BillOfOperationsSequence 4
KEY BillOfOperationsVariant MasterRecipe 4
KEY BOOOperationInternalID MasterRecipeOperationIntID 4
KEY BOOOperationPRTInternalID BOOOperationPRTInternalID 12
KEY BOOOperationPRTIntVersCounter BOOOperationPRTIntVersCounter 12
KEY ProductionRouting ProductionRouting 8
KEY ProductionRoutingGroup ProductionRoutingGroup 8
KEY ProductionRoutingOpIntID ProductionRoutingOpIntID 8
KEY ProductionRoutingSequence ProductionRoutingSequence 8
ChangeNumber ChangeNumber 12
CreatedByUser CreatedByUser 12
CreationDate CreationDate 12
LastChangeDate LastChangeDate 12
LastChangedByUser LastChangedByUser 12
ProdnRsceToolControlProfile ProdnRsceToolControlProfile 12
ProdnRsceToolItemNumber ProdnRsceToolItemNumber 12
ProdnRsceToolStandardTextCode ProdnRsceToolStandardTextCode 12
ProdnRsceToolStandardWorkQty ProdnRsceToolStandardWorkQty 12
ProdnRsceToolStdWorkQtyUnit ProdnRsceToolStdWorkQtyUnit 12
ProdnRsceToolText ProdnRsceToolText 12
ProdnRsceToolTotQtyCalcFormula ProdnRsceToolTotQtyCalcFormula 12
ProdnRsceToolUsageQtyCalcFmla ProdnRsceToolUsageQtyCalcFmla 12
ProdnRsceToolUsageQuantity ProdnRsceToolUsageQuantity 12
ProdnRsceToolUsageQuantityUnit ProdnRsceToolUsageQuantityUnit 12
ProductionResourceInternalID ProductionResourceInternalID 12
ProductionResourceType ProductionResourceType 12
ValidityEndDate ValidityEndDate 12
ValidityStartDate ValidityStartDate 12

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 PRTASSGMT (
    BILLOFOPERATIONSGROUP,
    BILLOFOPERATIONSSEQUENCE,
    BILLOFOPERATIONSVARIANT,
    BOOOPERATIONINTERNALID,
    BOOOPERATIONPRTINTERNALID,
    BOOOPERATIONPRTINTVERSCOUNTER,
    PRODUCTIONROUTING,
    PRODUCTIONROUTINGGROUP,
    PRODUCTIONROUTINGOPINTID,
    PRODUCTIONROUTINGSEQUENCE,
    CHANGENUMBER,
    CREATEDBYUSER,
    CREATIONDATE,
    LASTCHANGEDATE,
    LASTCHANGEDBYUSER,
    PRODNRSCETOOLCONTROLPROFILE,
    PRODNRSCETOOLITEMNUMBER,
    PRODNRSCETOOLSTANDARDTEXTCODE,
    PRODNRSCETOOLSTANDARDWORKQTY,
    PRODNRSCETOOLSTDWORKQTYUNIT,
    PRODNRSCETOOLTEXT,
    PRODNRSCETOOLTOTQTYCALCFORMULA,
    PRODNRSCETOOLUSAGEQTYCALCFMLA,
    PRODNRSCETOOLUSAGEQUANTITY,
    PRODNRSCETOOLUSAGEQUANTITYUNIT,
    PRODUCTIONRESOURCEINTERNALID,
    PRODUCTIONRESOURCETYPE,
    VALIDITYENDDATE,
    VALIDITYSTARTDATE,
    PRIMARY KEY (BILLOFOPERATIONSGROUP, BILLOFOPERATIONSSEQUENCE, BILLOFOPERATIONSVARIANT, BOOOPERATIONINTERNALID, BOOOPERATIONPRTINTERNALID, BOOOPERATIONPRTINTVERSCOUNTER, PRODUCTIONROUTING, PRODUCTIONROUTINGGROUP, PRODUCTIONROUTINGOPINTID, PRODUCTIONROUTINGSEQUENCE)
);

Learn More