C_KnbnCtrlCycleAnalysisQry

Kanban Control Cycle Analysis Query | view: CKNBNCTNSTSQRY | Extraction: Not supported | Component: Fiori UI for PP Kanban
Tables used: PKPS, PKHD, PVBE
Column Name Description
KanbanControlCycle Kanban Control Cycle
Column Name Description
Column Name Description
📏 Base Unit of Measure (BaseUnit):
ActualQuantityInBaseUnit null
RequestedQuantityInBaseUnit null
Column Name Description
ReleaseDate Release Date of Kanban Control Cycle
LockDate Control Cycle Lock Date
Column Name Description
KanbanControlCycleCategory Kanban Control Cycle Category Show values
KanbanReplenishmentStrgyType Replenishment Type Show values
KanbanCtrlCycleLifeCycleStatus Lifecycle Status of Kanban Control Cycle Show values
Column Name Description Domain name
StoringPositionName Storing Position TEXT25
SupplySourcePlant Plant of Supply Source WERKS
KanbanCtrlCycReplnmtTriggerGrp Trigger Group TRIGGR
PlanningWorkCenter Work Center for Consideration of Capacity ARBPL
SourceProductionSupplyArea Source Production Supply Area for Kanban Stock Transfers
MaxNumberOfEmptyCtnsIsExceeded Checkbox
NumberOfKanbanContainers null
NumberOfWaitingKanbanCtns null
NumberOfEmptyKanbanContainers null
NumberOfKanbanCtnsInProcess null
NumberOfKanbanCtnsInTransit null
NumberOfFullKanbanContainers null
NumberOfKanbanContainersInUse null
NumberOfKanbanCtnsWithError null
NumberOfLockedKanbanContainers null
NmbrOfCtnsWhereGoodsRcptIsMisg null
NmbrOfCtnsWhereGdsRcptIsAhead null
CtrlCycNextRcptInUTCDteTme Date and Time of Next Receipt
WaitingContainersInPercent null
EmptyContainersInPercent null
InProcessContainersInPercent null
InTransitContainersInPercent null
FullContainersInPercent null
InUseContainersInPercent null
ErrorContainersInPercent null
NmbrOfDaysSinceKnbnCtnsChgd Number of days since last change of a kanban container
Master Data Relations Join Conditions
Base Unit of Measure
  • Client
  • Base Unit of Measure
  • C_KNBNCTRLCYCLEANALYSISQRY.MANDT == T006.MANDT
  • C_KNBNCTRLCYCLEANALYSISQRY.BASEUNIT == T006.MSEHI
Replenishment Strategy for External Procurement
  • Client
  • Plant
  • Replenishment Strategy for External Procurement
  • C_KNBNCTRLCYCLEANALYSISQRY.MANDT == TPK02.MANDT
  • C_KNBNCTRLCYCLEANALYSISQRY.PLANT == TPK02.WERKS
  • C_KNBNCTRLCYCLEANALYSISQRY.EXTPROCUREMENTREPLNMTSTRGY == TPK02.PKSTF
Replenishment Strategy for In-House Production
  • Client
  • Replenishment Strategy for In-House Production
  • Plant
  • C_KNBNCTRLCYCLEANALYSISQRY.MANDT == TPK01.MANDT
  • C_KNBNCTRLCYCLEANALYSISQRY.INHOUSEPRODUCTIONREPLNMTSTRGY == TPK01.PKSTE
  • C_KNBNCTRLCYCLEANALYSISQRY.PLANT == TPK01.WERKS
Plant
  • Client
  • Plant
  • C_KNBNCTRLCYCLEANALYSISQRY.MANDT == T001W.MANDT
  • C_KNBNCTRLCYCLEANALYSISQRY.PLANT == T001W.WERKS
Material Number
  • Client
  • Product Number
  • C_KNBNCTRLCYCLEANALYSISQRY.MANDT == MARA.MANDT
  • C_KNBNCTRLCYCLEANALYSISQRY.PRODUCT == MARA.MATNR
Production Supply Area (PSA)
  • Client
  • Plant
  • Production Supply Area
  • C_KNBNCTRLCYCLEANALYSISQRY.MANDT == PVBE.MANDT
  • C_KNBNCTRLCYCLEANALYSISQRY.PLANT == PVBE.WERKS
  • C_KNBNCTRLCYCLEANALYSISQRY.PRODUCTIONSUPPLYAREA == PVBE.PRVBE
Purchasing Organization
  • Client
  • Purchasing Organization
  • C_KNBNCTRLCYCLEANALYSISQRY.MANDT == T024E.MANDT
  • C_KNBNCTRLCYCLEANALYSISQRY.PURCHASINGORGANIZATION == T024E.EKORG
Storage Location
  • ?
  • Client
  • Storage Location
  • C_KNBNCTRLCYCLEANALYSISQRY.[column in domain "WERKS_D"] == T001L.WERKS
  • C_KNBNCTRLCYCLEANALYSISQRY.MANDT == T001L.MANDT
  • C_KNBNCTRLCYCLEANALYSISQRY.SOURCESTORAGELOCATION == T001L.LGORT
Replenishment Strategy for Stock Transfer
  • Client
  • Plant
  • Replenishment Strategy for Stock Transfer
  • C_KNBNCTRLCYCLEANALYSISQRY.MANDT == TPK03.MANDT
  • C_KNBNCTRLCYCLEANALYSISQRY.PLANT == TPK03.WERKS
  • C_KNBNCTRLCYCLEANALYSISQRY.STOCKTRANSFERREPLNMTSTRATEGY == TPK03.PKSTU
Storage Location
  • Client
  • Plant
  • Storage Location
  • C_KNBNCTRLCYCLEANALYSISQRY.MANDT == T001L.MANDT
  • C_KNBNCTRLCYCLEANALYSISQRY.PLANT == T001L.WERKS
  • C_KNBNCTRLCYCLEANALYSISQRY.STORAGELOCATION == T001L.LGORT
Vendor's account number
  • Client
  • Vendor's account number
  • C_KNBNCTRLCYCLEANALYSISQRY.MANDT == LFA1.MANDT
  • C_KNBNCTRLCYCLEANALYSISQRY.SUPPLIER == LFA1.LIFNR