I_RESOURCEBASIC

CDS View

APO Resource

I_RESOURCEBASIC is a CDS View in S/4HANA. APO Resource. It contains 15 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
/SCMTMS/CV_ResourceBasicEnh view from Enhanced APO Resource
I_FldLogsVehicleResourceRecord view_entity from COMPOSITE Vehicle resource
I_VehicleResourceVH view from COMPOSITE Search help for vehicle resource
R_PPDSMntrRcptResourceVH view_entity from COMPOSITE Resource

Fields (15)

KeyField CDS FieldsUsed in Views
KEY ResourceSimulationSessionUUID ResourceSimulationSessionUUID 2
KEY ResourceSimulationVersionUUID ResourceSimulationVersionUUID 2
KEY ResourceUUID ResourceUUID 2
_LocationBasic _LocationBasic 1
AuthorizationGroup AuthorizationGroup 1
ChangedDateTime ChangedDateTime 1
IsBusinessPurposeCompleted IsBusinessPurposeCompleted 1
LastChangedByUser LastChangedByUser 1
ResourceFactoryCalendar ResourceFactoryCalendar 1
ResourceHomeLocation ResourceHomeLocation 1
ResourceHomeLocationUUID ResourceHomeLocationUUID 2
ResourceID PPDSMntrRcptResource,ResourceID 2
ResourceTimeZone ResourceTimeZone 1
ResourceType ResourceType 2
TransportMeansType TransportMeansType 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.

-- APO Resource
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_RESOURCEBASIC (
    RESOURCESIMULATIONSESSIONUUID,
    RESOURCESIMULATIONVERSIONUUID,
    RESOURCEUUID,
    _LOCATIONBASIC,
    AUTHORIZATIONGROUP,
    CHANGEDDATETIME,
    ISBUSINESSPURPOSECOMPLETED,
    LASTCHANGEDBYUSER,
    RESOURCEFACTORYCALENDAR,
    RESOURCEHOMELOCATION,
    RESOURCEHOMELOCATIONUUID,
    RESOURCEID,
    RESOURCETIMEZONE,
    RESOURCETYPE,
    TRANSPORTMEANSTYPE,
    PRIMARY KEY (RESOURCESIMULATIONSESSIONUUID, RESOURCESIMULATIONVERSIONUUID, RESOURCEUUID)
);