_RESOURCE

11 Fields

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

Fields (11)

KeyField CDS FieldsUsed in Views
KEY CompanyCode CompanyCode 7
KEY CostCenter CostCenter 7
AuthorizationGroup AuthorizationGroup 4
CapacityCategory CapacityCategory 3
CapacityQuantityUnit CapacityQuantityUnit 1
EWMResource EWMResource 1
IsBusinessPurposeCompleted IsBusinessPurposeCompleted 4
Plant Plant 2
PMRPResourceName PMRPResourceName 2
WorkCenter WorkCenter 3
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,
    AUTHORIZATIONGROUP,
    CAPACITYCATEGORY,
    CAPACITYQUANTITYUNIT,
    EWMRESOURCE,
    ISBUSINESSPURPOSECOMPLETED,
    PLANT,
    PMRPRESOURCENAME,
    WORKCENTER,
    WORKCENTERINTERNALID,
    PRIMARY KEY (COMPANYCODE, COSTCENTER)
);

Learn More