_RESOURCE

25 Fields

_RESOURCE is an SAP database table in S/4HANA. It contains 25 fields.

Fields (25)

KeyField CDS FieldsUsed in Views
KEY CompanyCode CompanyCode 7
KEY CostCenter CostCenter 7
KEY LocationUUID AdvncdPlngLocationID,LocationUUID 7
AdvncdPlngResourceName AdvncdPlngResourceName 11
AdvncdPlngRsceUoM AdvncdPlngRsceUoM 3
AuthorizationGroup AuthorizationGroup 4
CapacityCategory CapacityCategory 4
CapacityQuantityUnit CapacityQuantityUnit 1
EWMResource EWMResource 1
IsBusinessPurposeCompleted IsBusinessPurposeCompleted 4
LocationType LocationType 7
PlannerName PlannerName,ResourcePlannerName 11
Plant Plant 3
PMRPResourceInternalID PMRPResourceInternalID 1
PMRPResourceName PMRPResourceName 2
ResourceCategory ResourceCategory 11
ResourceFinitenessLevelValue ResourceFinitenessLevelValue 5
ResourceGroup ResourceGroup 11
ResourceHomeLocation Location 7
ResourceIsBottleNeck ResourceIsBottleNeck 5
ResourcePlanner ResourcePlanner 11
ResourceSortText ResourceSortText 5
ResourceType ResourceType 11
WorkCenter WorkCenter 4
WorkCenterInternalID WorkCenterInternalID 2

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 _RESOURCE (
    COMPANYCODE,
    COSTCENTER,
    LOCATIONUUID,
    ADVNCDPLNGRESOURCENAME,
    ADVNCDPLNGRSCEUOM,
    AUTHORIZATIONGROUP,
    CAPACITYCATEGORY,
    CAPACITYQUANTITYUNIT,
    EWMRESOURCE,
    ISBUSINESSPURPOSECOMPLETED,
    LOCATIONTYPE,
    PLANNERNAME,
    PLANT,
    PMRPRESOURCEINTERNALID,
    PMRPRESOURCENAME,
    RESOURCECATEGORY,
    RESOURCEFINITENESSLEVELVALUE,
    RESOURCEGROUP,
    RESOURCEHOMELOCATION,
    RESOURCEISBOTTLENECK,
    RESOURCEPLANNER,
    RESOURCESORTTEXT,
    RESOURCETYPE,
    WORKCENTER,
    WORKCENTERINTERNALID,
    PRIMARY KEY (COMPANYCODE, COSTCENTER, LOCATIONUUID)
);

Learn More