A_JITControlCycle

DDL: A_JITCONTROLCYCLE SQL: AJITCONTROLCYCLE Type: view CONSUMPTION
84 Fields 1 Data Sources 3 Associations

API view for control cycle

A_JITControlCycle is a Consumption CDS View that provides data about "API view for control cycle" in SAP S/4HANA. It reads from 1 data source (I_JITControlCycleTP) and exposes 84 fields with key field JITControlCycle. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_JITControlCycleTP _JITControlCycleTP from

Associations (3)

CardinalityTargetAliasCondition
[0..*] A_JITOutbCallsBOM _JITOutbCallsBOM $projection.JITControlCycle = _JITOutbCallsBOM.JITControlCycle
[0..*] A_JITOutbSchedgAgrmt _JITOutbSchedgAgrmt $projection.JITControlCycle = _JITOutbSchedgAgrmt.JITControlCycle
[0..1] E_JITControlCycle _JITControlCycle $projection.JITControlCycle = _JITControlCycle.JITControlCycle

Annotations (19)

NameValueLevelField
AbapCatalog.sqlViewName AJITCONTROLCYCLE view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
VDM.viewType #CONSUMPTION view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.transactionalProcessingDelegated true view
ObjectModel.representativeKey JITControlCycle view
ObjectModel.compositionRoot true view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled true view
EndUserText.label API view for control cycle view

Fields (84)

KeyFieldSource TableSource FieldDescription
KEY JITControlCycle JITControlCycle Control Cycle
JITCtrlCycLifeCycSts JITCtrlCycLifeCycSts Control Cycle Status
JITCtrlCycLifeCycStsTxt JITCtrlCycLifeCycStsTxt Control Cycle Status Text
Plant Plant Plant
PlantName PlantName Plant Name
Material Material Material
ProductName ProductName Material Name
JITContainerQuantityInBsUnt JITContainerQuantityInBsUnt Quantity
QuantityUnit QuantityUnit Unit
ProductionSupplyArea ProductionSupplyArea Production Supply Area
ProductionSupplyAreaName ProductionSupplyAreaName Production Supply Area Name
Responsible Responsible Responsible
StorageLocation StorageLocation Storage Location
UnloadingPointName UnloadingPointName Unloading Point Name
ReplenishmentStrategy ReplenishmentStrategy Replenishment Strategy
ReplenishmentStrategyDesc ReplenishmentStrategyDesc Replenishment Strategy Name
StorageType StorageType Storage Type
StorageTypeName StorageTypeName Storage Type Name
WarehouseNumber WarehouseNumber Warehouse Number
Warehouse Warehouse Warehouse
WarehouseName WarehouseName Warehouse Name
StorageBin StorageBin Storage Bin
StoringPositionName StoringPositionName Storing Position Name
SourceStorageType SourceStorageType Source Storage Type
SourceStorageTypeName SourceStorageTypeName Source Storage Type Name
SourceProductionSupplyArea SourceProductionSupplyArea Source Production Supply Area
SourceSupplyAreaName SourceSupplyAreaName Source Production Supply Area Name
SourceStorageBin SourceStorageBin Source Storage Bin
EWMWarehouse EWMWarehouse EWM Wareshouse
JITCtrlCycleCreationDate JITCtrlCycleCreationDate Creation Date
JITCtrlCycleReleaseDate JITCtrlCycleReleaseDate Release Date
JITCtrlCycleReleaseTime JITCtrlCycleReleaseTime Release Time
LockDate LockDate Lock Date
JITCtrlCycleLockTime JITCtrlCycleLockTime Lock Time
LastChangedByUserName LastChangedByUserName Changed by
UserDescription UserDescription Description
LastChangeDateTime LastChangeDateTime Change Date Time
NumberOfLoadCarriers NumberOfLoadCarriers Number of Load Carriers
JITContainer JITContainer Conatiner
JITContainerDesc JITContainerDesc Container Description
IssuingOrReceivingStorageLoc IssuingOrReceivingStorageLoc Storage Location
StorageLocationName StorageLocationName Storage Location Name
JITCallProfile JITCallProfile Call Profile
RequestedDeliveryDateTime RequestedDeliveryDateTime Delivery Date/Time
JITActionCtrl JITActionCtrl Action Control
JITActionCtrlText JITActionCtrlText Action Control Name
Threshold Threshold Threshold
HundredInPercent HundredInPercent Hundred in Percent
UnitOfMeasureNumberOfDecimals UnitOfMeasureNumberOfDecimals Number of Decimals
MinimumQuantityMass MinimumQuantityMass Minimum Quanity
IsPartiallyDelivered IsPartiallyDelivered Partially Delivered
MaxNumberOfOpenJITCalls MaxNumberOfOpenJITCalls Maximum Open JIT Calls
NumberOfActiveJITCalls NumberOfActiveJITCalls Number of Active JIT Calls
DestinationStorageLocDesc DestinationStorageLocDesc Destination Storage Location Description
JITCallProfileDesc JITCallProfileDesc JIT Call Profile Description
ReplnmtLeadTimeInWorkdays ReplnmtLeadTimeInWorkdays Replenishment Lead Time in Days
ReplnmtLeadTimeInHours ReplnmtLeadTimeInHours Replenishment Lead Time in Hours
BufferLeadTime BufferLeadTime Lead Time
ReplnmtLeadTimeInMinutes ReplnmtLeadTimeInMinutes Lead Time in Minutes
PlannedDurationInMinutes PlannedDurationInMinutes Planned Duration in Minutes
ReplnmtLeadTimeInHoursAndMins ReplnmtLeadTimeInHoursAndMins Relenishment Lead Time in H/M
ReplenishmentLeadTime ReplenishmentLeadTime Replenishment Lead Time
JITControlCycleCategory JITControlCycleCategory Control Cycle Category
JITControlCycleCategoryText JITControlCycleCategoryText Control Cycle Category Text
ReplnmtPlanningProcedure ReplnmtPlanningProcedure Planning Procedure
JITPlanningProcedureText JITPlanningProcedureText Planning Procedure Text
PlanningHorizonInHoursAndMins PlanningHorizonInHoursAndMins Planning Horizon in H/M
PlanningHorizonTime PlanningHorizonTime Planning Horizon Time
MinimumStockQuantity MinimumStockQuantity Minimum Stock
ReplnmtSafetyTimeInDays ReplnmtSafetyTimeInDays Replenishment Safety Time
SafetyTimeInHoursAndMins SafetyTimeInHoursAndMins Safety Time in H/M
JITExternalReplenishment JITExternalReplenishment External Replenishment
JITOutbCommunicationGroup JITOutbCommunicationGroup Communication Group
JITOutbCommunicationGroupDesc JITOutbCommunicationGroupDesc Communication Group Description
Supplier Supplier Supplier
SupplierName SupplierName Supplier Name
ReplnmtSafetyTimeInMins ReplnmtSafetyTimeInMins Safety Time in Minutes
JITReqQtyUpperToleranceLvl JITReqQtyUpperToleranceLvl Requested Quantity Upper Tolerance (%)
JITReqQtyLowerToleranceLvl JITReqQtyLowerToleranceLvl Requested Quantity Lower Tolerance (%)
JITTransferTimeInDays JITTransferTimeInDays Transfer Time (In Days)
TransferTimeInHoursMinutes TransferTimeInHoursMinutes Transfer Time (hh:mm)
GoodsReceivingPoint GoodsReceivingPoint Receiving Point
_JITOutbCallsBOM _JITOutbCallsBOM
_JITOutbSchedgAgrmt _JITOutbSchedgAgrmt

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view A_JITControlCycle.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: AJITCONTROLCYCLE

CREATE VIEW A_JITControlCycle AS
SELECT
  JITControlCycle,
  JITCtrlCycLifeCycSts,
  JITCtrlCycLifeCycStsTxt,
  Plant,
  PlantName,
  Material,
  ProductName,
  JITContainerQuantityInBsUnt,
  QuantityUnit,
  ProductionSupplyArea,
  ProductionSupplyAreaName,
  Responsible,
  StorageLocation,
  UnloadingPointName,
  ReplenishmentStrategy,
  ReplenishmentStrategyDesc,
  StorageType,
  StorageTypeName,
  WarehouseNumber,
  Warehouse,
  WarehouseName,
  StorageBin,
  StoringPositionName,
  SourceStorageType,
  SourceStorageTypeName,
  SourceProductionSupplyArea,
  SourceSupplyAreaName,
  SourceStorageBin,
  EWMWarehouse,
  JITCtrlCycleCreationDate,
  JITCtrlCycleReleaseDate,
  JITCtrlCycleReleaseTime,
  LockDate,
  JITCtrlCycleLockTime,
  LastChangedByUserName,
  UserDescription,
  LastChangeDateTime,
  NumberOfLoadCarriers,
  JITContainer,
  JITContainerDesc,
  IssuingOrReceivingStorageLoc,
  StorageLocationName,
  JITCallProfile,
  RequestedDeliveryDateTime,
  JITActionCtrl,
  JITActionCtrlText,
  Threshold,
  HundredInPercent,
  UnitOfMeasureNumberOfDecimals,
  MinimumQuantityMass,
  IsPartiallyDelivered,
  MaxNumberOfOpenJITCalls,
  NumberOfActiveJITCalls,
  DestinationStorageLocDesc,
  JITCallProfileDesc,
  ReplnmtLeadTimeInWorkdays,
  ReplnmtLeadTimeInHours,
  BufferLeadTime,
  ReplnmtLeadTimeInMinutes,
  PlannedDurationInMinutes,
  ReplnmtLeadTimeInHoursAndMins,
  ReplenishmentLeadTime,
  JITControlCycleCategory,
  JITControlCycleCategoryText,
  ReplnmtPlanningProcedure,
  JITPlanningProcedureText,
  PlanningHorizonInHoursAndMins,
  PlanningHorizonTime,
  MinimumStockQuantity,
  ReplnmtSafetyTimeInDays,
  SafetyTimeInHoursAndMins,
  JITExternalReplenishment,
  JITOutbCommunicationGroup,
  JITOutbCommunicationGroupDesc,
  Supplier,
  SupplierName,
  ReplnmtSafetyTimeInMins,
  JITReqQtyUpperToleranceLvl,
  JITReqQtyLowerToleranceLvl,
  JITTransferTimeInDays,
  TransferTimeInHoursMinutes,
  GoodsReceivingPoint
FROM I_JITControlCycleTP AS _JITControlCycleTP
LEFT OUTER JOIN A_JITOutbCallsBOM AS _JITOutbCallsBOM ON JITControlCycle = _JITOutbCallsBOM.JITControlCycle  -- association [0..*]
LEFT OUTER JOIN A_JITOutbSchedgAgrmt AS _JITOutbSchedgAgrmt ON JITControlCycle = _JITOutbSchedgAgrmt.JITControlCycle  -- association [0..*]
LEFT OUTER JOIN E_JITControlCycle AS _JITControlCycle ON JITControlCycle = _JITControlCycle.JITControlCycle  -- association [0..1]
;

Learn More