C_KanbanControlCycleOutput

DDL: C_KANBANCONTROLCYCLEOUTPUT SQL: CKANBANCC Type: view CONSUMPTION
44 Fields 1 Data Sources 7 Associations

Kanban Control Cycle Output

C_KanbanControlCycleOutput (Consumption)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.

Manufacturing

C_KanbanControlCycleOutput is a Consumption CDS View that provides data about "Kanban Control Cycle Output" in SAP S/4HANA. It reads from 1 data source (I_KanbanControlCycle) and exposes 44 fields with key field KanbanControlCycle. It has 7 associations to related views.

SAP Help Documentation

CategoryCDS Views for Kanban Control Cycle
StatusLifecycle status of the kanban control cycle
Purpose
This CDS view forms the basis for the predelivered Output Management form template Kanban Control Cycle ( PP_KANBAN_CONTROLCYCLE ) and its data source FDP_PP_KANBAN_CONTROLCYCLE_SRV . This CDS view provides the data to answer the following business questions: Which fields are included in the form data provider for Kanban Control Cycle Output Management? To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views .

Prerequisites
Authorizations Users who want to use this CDS view must have a role with the following restriction types set to read access: WERKS (Plant) You can use the Display Restriction Types app to find out in which business catalogs these restriction types are included.

Structure
Important Fields Important fields in this view include the following: Field Name Description KanbanControlCycle Identifier of the kanban control cycle Product Product that is supplied with this control cycle Plant Plant where the production supply area and therefore also this kanban control cycle reside ProductionSupplyArea Production supply area to which the kanban control cycle is assigned KanbanCtrlCycleLifeCycleStatus Lifecycle status of the kanban control cycle NumberOfKanbanContainers Number of kanban containers in this control cycle InHouseProductionReplnmtStrgy Replenishment strategy for in-house production ExtProcurementReplnmtStrgy Replenishment strategy for external procurement StockTransferReplnmtStrategy Replenishment strategy for external procurement

View on SAP Help Portal →

SAP API Hub

StateC1
Line of BusinessManufacturing
Application ComponentPP-KAB
CapabilitiesOutput: Form Data Provider
PackageManufacturing for SAP S/4HANA Cloud Private Edition

Documentation

Data Sources (1)

SourceAliasJoin Type
I_KanbanControlCycle I_KanbanControlCycle from

Associations (7)

CardinalityTargetAliasCondition
[0..1] I_Plant _SupplySourcePlant $projection.SupplySourcePlant = _SupplySourcePlant.Plant
[0..1] I_ProductText _ProductText $projection.Product = _ProductText.Product and _ProductText.Language = $session.system_language
[0..1] I_ProductionSupplyAreaText _ProductionSupplyAreaText $projection.ProductionSupplyArea = _ProductionSupplyAreaText.ProductionSupplyArea and $projection.Plant = _ProductionSupplyAreaText.Plant and _ProductionSupplyAreaText.Language = $session.system_language
[0..1] I_KnbnCtrlCycLifeCycStsTxt _KnbnCtrlCycLifeCycStsTxt $projection.KanbanCtrlCycleLifeCycleStatus = _KnbnCtrlCycLifeCycStsTxt.KanbanCtrlCycleLifeCycleStatus and _KnbnCtrlCycLifeCycStsTxt.Language = $session.system_language
[1..1] I_KanbanControlCycle _KanbanControlCycle $projection.KanbanControlCycle = _KanbanControlCycle.KanbanControlCycle
[1..1] I_KnbnCtrlCycProdMstrDta _KnbnCtrlCycProdMstrDta $projection.KanbanControlCycle = _KnbnCtrlCycProdMstrDta.KanbanControlCycle
[0..1] E_KanbanControlCycle _KanbanControlCycleExtension $projection.KanbanControlCycle = _KanbanControlCycleExtension.KanbanControlCycle

Annotations (16)

NameValueLevelField
AbapCatalog.sqlViewName CKANBANCC view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Kanban Control Cycle Output view
AccessControl.personalData.blocking #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.representativeKey KanbanControlCycle view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.compositionRoot true view
ObjectModel.modelingPattern #OUTPUT_FORM_DATA_PROVIDER view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
VDM.viewType #CONSUMPTION view

Fields (44)

KeyFieldSource TableSource FieldDescription
KEY KanbanControlCycle KanbanControlCycle Kanban Control Cycle
Product Product Product Number
ProductName _ProductText ProductName Product Description
Plant Plant Valuation Area
PlantName _Plant PlantName Plant Name
ProductionSupplyArea ProductionSupplyArea Production Supply Area
ProductionSupplyAreaName _ProductionSupplyAreaText ProductionSupplyAreaName Production Supply Area Name
StoringPositionName StoringPositionName Storing Position
Warehouse Warehouse Warehouse No.
StorageType StorageType Storage Type
StorageBin StorageBin Storage Bin
DestinationStorageBin DestinationStorageBin Destination Storage Bin
KanbanCtrlCycleLifeCycleStatus KanbanCtrlCycleLifeCycleStatus Lifecycle Status of Kanban Control Cycle
KnbnCtrlCycLifeCycStsName _KnbnCtrlCycLifeCycStsTxt KnbnCtrlCycLifeCycStsText Kanban Control Cycle Life Cycle Status Text
NumberOfKanbanContainers NumberOfKanbanContainers Number of Kanban Containers
MaxNrOfEmptyKanbanContainers MaxNrOfEmptyKanbanContainers Maximum Number of Empty Kanban Containers
KanbanContainerQuantityInBsUnt KanbanContainerQuantityInBsUnt Kanban Container Quantity
BaseUnit BaseUnit Base Unit of Measure
NumberOfLoadCarriers NumberOfLoadCarriers Number of Load Carriers
KanbanContainerPackggProduct KanbanContainerPackggProduct Packaging Product for Kanban Container
PackageInstructionInternalID PackingInstruction Instructions for Packer
InHouseProductionReplnmtStrgy InHouseProductionReplnmtStrgy Replenishment Strategy for In-House Production
ExtProcurementReplnmtStrgy ExtProcurementReplnmtStrgy Replenishment Strategy for External Procurement
StockTransferReplnmtStrategy StockTransferReplnmtStrategy Replenishment Strategy for Stock Transfer
PurchasingOrganization PurchasingOrganization Purchasing Organization
PurchasingOrganizationName _PurchasingOrganization PurchasingOrganizationName Purchasing Organization Name
Supplier Supplier Supplier's Account Number
SupplierName _Supplier OrganizationBPName1 Name 1
SupplySourcePlant SupplySourcePlant Plant of Supply Source
SupplySourcePlantName _SupplySourcePlant PlantName Plant Name
PurchaseOutlineAgreement PurchaseOutlineAgreement Agreement Number
PurchaseOutlineAgreementItem PurchaseOutlineAgreementItem Agreement Item
StorageLocation StorageLocation Storage Location
StorageLocationName _StorageLocation StorageLocationName Storage Location Name
SourceStorageBin SourceStorageBin Source Storage Bin
WarehouseProcessType WarehouseProcessType Warehouse Process Type
SupplySourceResponsiblePerson SupplySourceResponsiblePerson Person Responsible for Supply Source
SupSrceRespPersnName _ResponsiblePerson MRPControllerName MRP Controller Name
ProductionVersion ProductionVersion Production Version
ProductionVersionText _ProductionVersion ProductionVersionText Short Text for Production Version
_Supplier _Supplier
_SupplierCompanyByPlant _SupplierCompanyByPlant
_KanbanControlCycle _KanbanControlCycle
_KnbnCtrlCycProdMstrDta _KnbnCtrlCycProdMstrDta

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 C_KanbanControlCycleOutput.
-- 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: CKANBANCC

CREATE VIEW C_KanbanControlCycleOutput AS
SELECT
  KanbanControlCycle,
  Product,
  _ProductText.ProductName AS ProductName,
  Plant,
  _Plant.PlantName AS PlantName,
  ProductionSupplyArea,
  _ProductionSupplyAreaText.ProductionSupplyAreaName AS ProductionSupplyAreaName,
  StoringPositionName,
  Warehouse,
  StorageType,
  StorageBin,
  DestinationStorageBin,
  KanbanCtrlCycleLifeCycleStatus,
  _KnbnCtrlCycLifeCycStsTxt.KnbnCtrlCycLifeCycStsText AS KnbnCtrlCycLifeCycStsName,
  NumberOfKanbanContainers,
  MaxNrOfEmptyKanbanContainers,
  KanbanContainerQuantityInBsUnt,
  BaseUnit,
  NumberOfLoadCarriers,
  KanbanContainerPackggProduct,
  PackingInstruction AS PackageInstructionInternalID,
  InHouseProductionReplnmtStrgy,
  ExtProcurementReplnmtStrgy,
  StockTransferReplnmtStrategy,
  PurchasingOrganization,
  _PurchasingOrganization.PurchasingOrganizationName AS PurchasingOrganizationName,
  Supplier,
  _Supplier.OrganizationBPName1 AS SupplierName,
  SupplySourcePlant,
  _SupplySourcePlant.PlantName AS SupplySourcePlantName,
  PurchaseOutlineAgreement,
  PurchaseOutlineAgreementItem,
  StorageLocation,
  _StorageLocation.StorageLocationName AS StorageLocationName,
  SourceStorageBin,
  WarehouseProcessType,
  SupplySourceResponsiblePerson,
  _ResponsiblePerson.MRPControllerName AS SupSrceRespPersnName,
  ProductionVersion,
  _ProductionVersion.ProductionVersionText AS ProductionVersionText
FROM I_KanbanControlCycle
LEFT OUTER JOIN I_Plant AS _SupplySourcePlant ON SupplySourcePlant = _SupplySourcePlant.Plant  -- association [0..1]
LEFT OUTER JOIN I_ProductText AS _ProductText ON Product = _ProductText.Product AND _ProductText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_ProductionSupplyAreaText AS _ProductionSupplyAreaText ON ProductionSupplyArea = _ProductionSupplyAreaText.ProductionSupplyArea AND Plant = _ProductionSupplyAreaText.Plant AND _ProductionSupplyAreaText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_KnbnCtrlCycLifeCycStsTxt AS _KnbnCtrlCycLifeCycStsTxt ON KanbanCtrlCycleLifeCycleStatus = _KnbnCtrlCycLifeCycStsTxt.KanbanCtrlCycleLifeCycleStatus AND _KnbnCtrlCycLifeCycStsTxt.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_KanbanControlCycle AS _KanbanControlCycle ON KanbanControlCycle = _KanbanControlCycle.KanbanControlCycle  -- association [1..1]
LEFT OUTER JOIN I_KnbnCtrlCycProdMstrDta AS _KnbnCtrlCycProdMstrDta ON KanbanControlCycle = _KnbnCtrlCycProdMstrDta.KanbanControlCycle  -- association [1..1]
LEFT OUTER JOIN E_KanbanControlCycle AS _KanbanControlCycleExtension ON KanbanControlCycle = _KanbanControlCycleExtension.KanbanControlCycle  -- association [0..1]
;

Learn More