I_VEHSCHEDGACTIVITY
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)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| 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)
| Key | Field | CDS Fields | Used 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)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA