I_KanbanControlCycleItem

DDL: I_KANBANCONTROLCYCLEITEM SQL: IPPKANBANCCITEM Type: view COMPOSITE
42 Fields 1 Data Sources 1 Associations

Kanban Control Cycle Item

I_KanbanControlCycleItem is a Composite CDS View that provides data about "Kanban Control Cycle Item" in SAP S/4HANA. It reads from 1 data source (I_KanbanContainer) and exposes 42 fields with key field KanbanControlCycle. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_KanbanContainer I_KanbanContainer from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_KanbanContainer _KanbanContainer $projection.KanbanContainer = _KanbanContainer.KanbanContainer

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName IPPKANBANCCITEM view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.modelingPattern #NONE view
ObjectModel.representativeKey KanbanControlCycleItem view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
VDM.viewType #COMPOSITE view
EndUserText.label Kanban Control Cycle Item view

Fields (42)

KeyFieldSource TableSource FieldDescription
KEY KanbanControlCycle KanbanControlCycle
KanbanContainer KanbanContainer
KanbanContainerStatus KanbanContainerStatus
IsLocked IsLocked
LastChangeDate LastChangeDate Time Stamp
LastChangeTime LastChangeTime Time changed
PreviousLastChangeDate PreviousLastChangeDate
PreviousLastChangeTime PreviousLastChangeTime
Plant Plant Valuation Area
ProductionSupplyArea ProductionSupplyArea Supply Area
PlannedOrder PlannedOrder
OrderID OrderID Order ID
PurchasingDocument
PurchasingDocumentItem
SalesDocument SalesDocument SD Document
SalesDocumentItem SalesDocumentItem Sales Document Item
RepetitiveMfgConfirmation RepetitiveMfgConfirmation
Reservation Reservation Reservation
ReservationItem ReservationItem Reservation Item
MaterialDocument MaterialDocument Material Doc.
MaterialDocumentItem MaterialDocumentItem Material Document Item
BaseUnit BaseUnit Unit of Measure
ActualQuantityInBaseUnit ActualQuantityInBaseUnit
RequestedQuantityInBaseUnit RequestedQuantityInBaseUnit Requested Qty
Supplier Supplier Supplier
_Supplier _Supplier
_SupplierCompanyByPlant _SupplierCompanyByPlant
_KanbanControlCycle _KanbanControlCycle
_KanbanControlCycleItem _KanbanControlCycleItem
_KanbanContainer _KanbanContainer
_KanbanContainerStatus _KanbanContainerStatus
_Plant _Plant
_ProductionSupplyArea _ProductionSupplyArea
_BaseUnit _BaseUnit
_PlannedOrder _PlannedOrder
_Order _Order
_PurchasingDocument _PurchasingDocument
_PurchasingDocumentItem _PurchasingDocumentItem
_SalesDocument _SalesDocument
_SalesDocumentItem _SalesDocumentItem
_RepetitiveMfgConfirmation _RepetitiveMfgConfirmation
_Reservation _Reservation

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 I_KanbanControlCycleItem.
-- 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: IPPKANBANCCITEM

CREATE VIEW I_KanbanControlCycleItem AS
SELECT
  KanbanControlCycle,
  KanbanContainer,
  KanbanContainerStatus,
  IsLocked,
  LastChangeDate,
  LastChangeTime,
  PreviousLastChangeDate,
  PreviousLastChangeTime,
  Plant,
  ProductionSupplyArea,
  PlannedOrder,
  OrderID,
  SalesDocument,
  SalesDocumentItem,
  RepetitiveMfgConfirmation,
  Reservation,
  ReservationItem,
  MaterialDocument,
  MaterialDocumentItem,
  BaseUnit,
  ActualQuantityInBaseUnit,
  RequestedQuantityInBaseUnit,
  Supplier
FROM I_KanbanContainer
LEFT OUTER JOIN I_KanbanContainer AS _KanbanContainer ON KanbanContainer = _KanbanContainer.KanbanContainer  -- association [1..1]
;

Learn More