I_VEHSCHEDGACTIVITY

CDS View

Activity Net

I_VEHSCHEDGACTIVITY is a CDS View in S/4HANA. Activity Net. It contains 29 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
C_VehSchedgHandlingResource view from CONSUMPTION Vehicle Scheduling Handling Resource
I_VehSchedgActivitySolution view_entity from COMPOSITE Vehicle Scheduling Activity Solution
I_VehSchedgHndlgRsceSupplyCap view_entity from COMPOSITE Handling Resource Supply Capacity
I_VehSchedgHndlgRsceSupplyCap view_entity union COMPOSITE Handling Resource Supply Capacity

Fields (29)

KeyField CDS FieldsUsed in Views
KEY VehSchedgExplanationLogUUID VehSchedgExplanationLogUUID 3
KEY VehSchedgTranspActivity VehSchedgTranspActivity 3
AccptblEndOfActyEndDteTme AccptblEndOfActyEndDteTme 1
AccptblEndOfActyStrtDteTme AccptblEndOfActyStrtDteTme 1
AccptblStrtOfActyEndDteTme AccptblStrtOfActyEndDteTme 1
AccptblStrtOfActyStrtDteTme AccptblStrtOfActyStrtDteTme 1
DestinationLocation DestinationLocation 1
EarlyDeliveriesPenaltyCostVal EarlyDeliveriesPenaltyCostVal 1
FreightOrder FreightOrder 1
HandlingResourceBreakCal HandlingResourceBreakCal 1
LateDeliveriesPenaltyCostVal LateDeliveriesPenaltyCostVal 1
MaximumBreakDuration MaximumBreakDuration 1
RequestedActyEndDteTme RequestedActyEndDteTme 1
RequestedActyStrtDteTme RequestedActyStrtDteTme 1
ResourceBreakCalendar ResourceBreakCalendar 2
ResourceCapacityCalendar ResourceCapacityCalendar 1
ResourceConsumptionValue ResourceConsumptionValue 1
ResourceID ResourceID 1
SourceLocation SourceLocation 1
TranspOrdCapacityTranspOrdUUID TranspOrdCapacityTranspOrdUUID 1
TranspOrdNetDuration TranspOrdNetDuration 1
TransportationDriverUUID TransportationDriverUUID 1
TransportationOrderCategory TransportationOrderCategory 1
TransportationOrderUUID TransportationOrderUUID 1
TransportationUnitUUID TransportationUnitUUID 1
VehSchedgInternalReference VehSchedgInternalReference 1
VehSchedgTranspActivityUUID VehSchedgTranspActivityUUID 1
VehSchedgTranspActyCategory VehSchedgTranspActyCategory 1
VehSchedgTranspParentActivity VehSchedgTranspParentActivity 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.

-- Activity Net
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_VEHSCHEDGACTIVITY (
    VEHSCHEDGEXPLANATIONLOGUUID,
    VEHSCHEDGTRANSPACTIVITY,
    ACCPTBLENDOFACTYENDDTETME,
    ACCPTBLENDOFACTYSTRTDTETME,
    ACCPTBLSTRTOFACTYENDDTETME,
    ACCPTBLSTRTOFACTYSTRTDTETME,
    DESTINATIONLOCATION,
    EARLYDELIVERIESPENALTYCOSTVAL,
    FREIGHTORDER,
    HANDLINGRESOURCEBREAKCAL,
    LATEDELIVERIESPENALTYCOSTVAL,
    MAXIMUMBREAKDURATION,
    REQUESTEDACTYENDDTETME,
    REQUESTEDACTYSTRTDTETME,
    RESOURCEBREAKCALENDAR,
    RESOURCECAPACITYCALENDAR,
    RESOURCECONSUMPTIONVALUE,
    RESOURCEID,
    SOURCELOCATION,
    TRANSPORDCAPACITYTRANSPORDUUID,
    TRANSPORDNETDURATION,
    TRANSPORTATIONDRIVERUUID,
    TRANSPORTATIONORDERCATEGORY,
    TRANSPORTATIONORDERUUID,
    TRANSPORTATIONUNITUUID,
    VEHSCHEDGINTERNALREFERENCE,
    VEHSCHEDGTRANSPACTIVITYUUID,
    VEHSCHEDGTRANSPACTYCATEGORY,
    VEHSCHEDGTRANSPPARENTACTIVITY,
    PRIMARY KEY (VEHSCHEDGEXPLANATIONLOGUUID, VEHSCHEDGTRANSPACTIVITY)
);