I_RESOURCETRANSP

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.

-- Transportation Resource
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_RESOURCETRANSP (
    RESOURCEADDITIONALUUID,
    ATTACHEDEQUIPMENTPROFILE,
    COMPARTMENTPRFLISRSCESPECIFIC,
    EQUIPMENTGROUP,
    EQUIPMENTSUPPLIER,
    EQUIPMENTTYPE,
    ISMULTIRESOURCE,
    NUMBEROFAXLES,
    NUMBEROFRESOURCES,
    RESOURCEAXLEGROUP1DISTANCEUNIT,
    RESOURCEAXLEGROUP1TYPE,
    RESOURCEAXLEGROUP2DISTANCEUNIT,
    RESOURCEAXLEGROUP2TYPE,
    RESOURCEAXLEGROUP3DISTANCEUNIT,
    RESOURCEAXLEGROUP3TYPE,
    RESOURCEAXLESPACEDISTANCE,
    RESOURCEAXLESPACEDISTANCEUNIT,
    RESOURCEBUILDDATE,
    RESOURCECAPACITY,
    RESOURCECAPACITYUNIT,
    RESOURCECARGOBODYDISTANCE,
    RESOURCECLASS,
    RESOURCECONDITION,
    RESOURCECONNECTORDISTANCE,
    RESOURCECONNECTORMAXWEIGHT,
    RESOURCECOUPLERSTYLE,
    RESOURCECTRLTEMPERATUREUNIT,
    RESOURCEDEFAULTDRIVER,
    RESOURCEDEFAULTDRIVERUUID,
    RESOURCEDEFAULTTRAILER,
    RESOURCEDEFAULTTRAILERUUID,
    RESOURCEDRAFTGEARTYPE,
    RESOURCEENTITLEDUSER,
    RESOURCEENTITLEDUSERUUID,
    RESOURCEID,
    RESOURCEINSERVICEDATE,
    RESOURCEINTERIORHEIGHT,
    RESOURCEINTERIORLENGTH,
    RESOURCEINTERIORLENGTHUNIT,
    RESOURCEINTERIORWIDTH,
    RESOURCEISCOMBINATIONRESOURCE,
    RESOURCEISRELEVANTFOREVTMGMT,
    RESOURCEISSHIPPEROWNED,
    RESOURCEISTEMPERATURECTRLD,
    RESOURCEISUSABLEFORFOOD,
    RESOURCEISVENTILATED,
    RESOURCEKINGPINDISTANCE,
    RESOURCEKINGPINMAXWEIGHT,
    RESOURCELEASECONTRACTREF,
    RESOURCELOADWEIGHTUNIT,
    RESOURCEMAXAXLEWEIGHT,
    RESOURCEMAXAXLEWEIGHTUNIT,
    RESOURCEMAXCTRLTEMPERATURE,
    RESOURCEMAXIMUMGROSSWEIGHT,
    RESOURCEMAXIMUMGROSSWEIGHTUNIT,
    RESOURCEMAXIMUMHEIGHT,
    RESOURCEMAXIMUMLENGTH,
    RESOURCEMAXIMUMLENGTHUNIT,
    RESOURCEMAXIMUMLOADWEIGHT,
    RESOURCEMAXIMUMLOADWEIGHTUNIT,
    RESOURCEMAXIMUMWIDTH,
    RESOURCEMINCTRLTEMPERATURE,
    RESOURCEMINNUMBEROFRQDSEALS,
    RESOURCEORGANIZATIONALCENTER,
    RESOURCEOWNER,
    RESOURCEOWNERSHIP,
    RESOURCEOWNERUUID,
    RESOURCEPLATFORMHEIGHT,
    RESOURCEPLATFORMHEIGHTUNIT,
    RESOURCESPECIALINSTRUCTION,
    RESOURCESPLITDECKDISTANCE,
    RESOURCESPLITDECKMAXWEIGHT,
    RESOURCETAREVOLUME,
    RESOURCETAREVOLUMEUNIT,
    RESOURCETAREWEIGHT,
    RESOURCETAREWEIGHTUNIT,
    RESOURCETECHNICALDISTANCEUNIT,
    RESOURCETOPDECKHEIGHT,
    RESOURCETOPDECKHEIGHTUNIT,
    RESOURCETYPE,
    RESOURCETYPECLASSIFICATION,
    RESOURCEUUID,
    RESOURCEVALIDITYENDDATETIME,
    RESOURCEVALIDITYSTARTDATETIME,
    RESOURCEWHEELBEARINGTYPE,
    RESOURCEWHEELDIAMETER,
    RESOURCEWHEELDIAMETERUNIT,
    RSCEADDLCAPALTVNMBROFUNITS,
    RSCEADDLCAPALTVNMBROFUNITSUNIT,
    RSCEADDLCAPNMBROFUNITS,
    RSCEADDLCAPNMBROFUNITSUNIT,
    RSCEAXLEGROUP1DISTANCE,
    RSCEAXLEGROUP1EMPTYWEIGHT,
    RSCEAXLEGROUP1ISDRIVINGAXLE,
    RSCEAXLEGROUP1ISSTEERINGAXLE,
    RSCEAXLEGROUP1MAXIMUMWEIGHT,
    RSCEAXLEGROUP1SPACEDISTANCE,
    RSCEAXLEGROUP1WEIGHTUNIT,
    RSCEAXLEGROUP2DISTANCE,
    RSCEAXLEGROUP2EMPTYWEIGHT,
    RSCEAXLEGROUP2ISDRIVINGAXLE,
    RSCEAXLEGROUP2ISSTEERINGAXLE,
    RSCEAXLEGROUP2MAXIMUMWEIGHT,
    RSCEAXLEGROUP2SPACEDISTANCE,
    RSCEAXLEGROUP2WEIGHTUNIT,
    RSCEAXLEGROUP3DISTANCE,
    RSCEAXLEGROUP3EMPTYWEIGHT,
    RSCEAXLEGROUP3ISDRIVINGAXLE,
    RSCEAXLEGROUP3ISSTEERINGAXLE,
    RSCEAXLEGROUP3MAXIMUMWEIGHT,
    RSCEAXLEGROUP3SPACEDISTANCE,
    RSCEAXLEGROUP3WEIGHTUNIT,
    RSCECNTRYSPCFCREGNNUMBER,
    RSCEISDNGRSGDSPTSLIMITRLVT,
    RSCEMAXTRAILINGLOADWEIGHT,
    RSCEMAXTRAILINGLOADWEIGHTUNIT,
    RSCEPLANNINGBLOCKREASON,
    RSCEREGISTRATIONNUMBER,
    RSCEREGISTRATIONNUMBERCOUNTRY,
    VEHICLELOADINGPROFILE,
    PRIMARY KEY (RESOURCEADDITIONALUUID)
);