I_EQUIPMENTPRODNRSCETOOL

CDS View
30 Fields 1 CDS Views

Equipment Production Resource Tool

I_EQUIPMENTPRODNRSCETOOL is a CDS View in S/4HANA. Equipment Production Resource Tool. It contains 30 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
A_EquipProductionResourceTool view_entity from COMPOSITE Equipment Production Resource Tool

Fields (30)

KeyField CDS FieldsUsed in Views
KEY Equipment Equipment 1
ChangeNumber ChangeNumber 1
CreatedByUser CreatedByUser 1
CreationDate CreationDate 1
EndDateOffsetDuration EndDateOffsetDuration 1
EndDateOffsetDurationUnit EndDateOffsetDurationUnit 1
EndDateOffsetDurnIsReferenced EndDateOffsetDurnIsReferenced 1
EndDateOffsetReferenceCode EndDateOffsetReferenceCode 1
EndDteOffstRefCodeIsReferenced EndDteOffstRefCodeIsReferenced 1
LastChangeDate LastChangeDate 1
LastChangedByUser LastChangedByUser 1
ProdnRsceToolControlProfile ProdnRsceToolControlProfile 1
ProdnRsceToolStandardTextCode ProdnRsceToolStandardTextCode 1
ProdnRsceToolTotQtyCalcFormula ProdnRsceToolTotQtyCalcFormula 1
ProdnRsceToolUsageQtyCalcFmla ProdnRsceToolUsageQtyCalcFmla 1
ProdPRTLoadRecordsAreCreated ProdPRTLoadRecordsAreCreated 1
ProductionResourceInternalID ProductionResourceInternalID 1
ProductionResourceToolGroup1 ProductionResourceToolGroup1 1
ProductionResourceToolGroup2 ProductionResourceToolGroup2 1
ProductionResourceType ProductionResourceType 1
ProductionResourceUsage ProductionResourceUsage 1
PRTControlProfileIsReferenced PRTControlProfileIsReferenced 1
PRTStdTextCodeIsReferenced PRTStdTextCodeIsReferenced 1
PRTTotQtyCalcFmlaIsReferenced PRTTotQtyCalcFmlaIsReferenced 1
PRTUsgeQtyCalcFmlaIsReferenced PRTUsgeQtyCalcFmlaIsReferenced 1
StartDateOffsetDuration StartDateOffsetDuration 1
StartDateOffsetDurationUnit StartDateOffsetDurationUnit 1
StartDateOffsetRefCodeIsRefcd StartDateOffsetRefCodeIsRefcd 1
StartDateOffsetReferenceCode StartDateOffsetReferenceCode 1
StartDateOffstDurnIsReferenced StartDateOffstDurnIsReferenced 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.

-- Equipment Production Resource Tool
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_EQUIPMENTPRODNRSCETOOL (
    EQUIPMENT,
    CHANGENUMBER,
    CREATEDBYUSER,
    CREATIONDATE,
    ENDDATEOFFSETDURATION,
    ENDDATEOFFSETDURATIONUNIT,
    ENDDATEOFFSETDURNISREFERENCED,
    ENDDATEOFFSETREFERENCECODE,
    ENDDTEOFFSTREFCODEISREFERENCED,
    LASTCHANGEDATE,
    LASTCHANGEDBYUSER,
    PRODNRSCETOOLCONTROLPROFILE,
    PRODNRSCETOOLSTANDARDTEXTCODE,
    PRODNRSCETOOLTOTQTYCALCFORMULA,
    PRODNRSCETOOLUSAGEQTYCALCFMLA,
    PRODPRTLOADRECORDSARECREATED,
    PRODUCTIONRESOURCEINTERNALID,
    PRODUCTIONRESOURCETOOLGROUP1,
    PRODUCTIONRESOURCETOOLGROUP2,
    PRODUCTIONRESOURCETYPE,
    PRODUCTIONRESOURCEUSAGE,
    PRTCONTROLPROFILEISREFERENCED,
    PRTSTDTEXTCODEISREFERENCED,
    PRTTOTQTYCALCFMLAISREFERENCED,
    PRTUSGEQTYCALCFMLAISREFERENCED,
    STARTDATEOFFSETDURATION,
    STARTDATEOFFSETDURATIONUNIT,
    STARTDATEOFFSETREFCODEISREFCD,
    STARTDATEOFFSETREFERENCECODE,
    STARTDATEOFFSTDURNISREFERENCED,
    PRIMARY KEY (EQUIPMENT)
);

Learn More