I_KnbnExtProcmtReplnmtStrgy

DDL: I_KNBNEXTPROCMTREPLNMTSTRGY SQL: IPPKNBNPROCSTRAT Type: view BASIC

Kanban Control Cycle External Procurement Strategy

I_KnbnExtProcmtReplnmtStrgy (Basic)

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

External Procurement Replenishment Strategy · Manufacturing

I_KnbnExtProcmtReplnmtStrgy is a Basic CDS View (Dimension) that provides data about "Kanban Control Cycle External Procurement Strategy" in SAP S/4HANA. It reads from 1 data source (tpk02) and exposes 18 fields with key fields Plant, ExtProcurementReplnmtStrgy. It has 2 associations to related views. It is exposed through 1 OData service (UI_KANBANCONTAINER_MONITOR).

SAP API Hub

StateC1
Line of BusinessManufacturing
Application ComponentPP-KAB-VDM
CapabilitiesData Source in SQL Select, Association Target for Defining CDS Entities, Data Source for Defining CDS Entities, Data Source for Data Extraction, Analytical Dimension
PackageManufacturing for SAP S/4HANA Cloud Private Edition
Description <p>This CDS view provides access to Kanban external procurement replenishment strategies.</p> <p>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.</p>

Documentation

Data Sources (1)

SourceAliasJoin Type
tpk02 tpk02 from

Associations (2)

CardinalityTargetAliasCondition
[0..*] I_KnbnExtProcmtReplnmtStrgyTxt _Text $projection.ExtProcurementReplnmtStrgy = _Text.ExtProcurementReplnmtStrgy and $projection.Plant = _Text.Plant
[0..1] I_Plant _Plant $projection.Plant = _Plant.Plant

Annotations (21)

NameValueLevelField
AbapCatalog.sqlViewName IPPKNBNPROCSTRAT view
AbapCatalog.preserveKey true view
EndUserText.label Kanban Control Cycle External Procurement Strategy view
AbapCatalog.buffering.status #ACTIVE view
AbapCatalog.buffering.type #FULL view
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.modelingPattern #ANALYTICAL_DIMENSION view
ObjectModel.sapObjectNodeType.name ExtProcurementReplnmtStrgy view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
ObjectModel.representativeKey ExtProcurementReplnmtStrgy view
Analytics.dataCategory #DIMENSION view
Analytics.dataExtraction.enabled true view
Metadata.ignorePropagatedAnnotations true view
AbapCatalog.compiler.compareFilter true view
Analytics.internalName #LOCAL view
Metadata.allowExtensions true view

OData Services (1)

ServiceBindingVersionContractRelease
UI_KANBANCONTAINER_MONITOR UI_KANBANCONTAINER_MONITOR V4 C1 NOT_RELEASED

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY Plant werks Receiving Plant
KEY ExtProcurementReplnmtStrgy pkstf Replenishment Strategy of Control Cycle - Ext. Procurement
KnbnCtrlCycExtProcmtCtrlType pksaf Control Type
GoodsReceiptMovementType bwawe Movement Type for Goods Receipt
SignalLockingTimeInMinutes aussp Signal Locking Time in Minutes
PurchasingOrderType bsart Order Type (Purchasing)
PostCnsmpnToCostCtrExtProcmt cnscc Post consumption to cost center - external procurement
PostCnsmpnToCostCtrMvtType bwacc Movement type: post consumption to cost center
SubDaySchedulingIsConsdrd uttrm Exact-to-the-Min. Forw. Scheduling f. Kanban Summ. JIT Calls
UsageOfPackingInstructions vpack Use of Packing Instructions in the Kanban Control Cycle
CostCenterAcctAsgtCategory knttp Cost Center Account Assignment Category
KanbanCtrlCycPrintFormTemplate cc_print_form Form Template
KanbanCtnPrintFormTemplate kbform Form Template
GoodsMvtIsPostedSynchronously post_sync_ewm_im Indicator if goods movements are posted synchronously
SchedulingIsBasedOnCalcProfile kzakb Scheduling According to Calculation Profile
KnbnSDSchedgAgrmtDelivCrtnType sddkz Indicator for Kanban with SD scheduling agreement
_Text _Text
_Plant _Plant

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_KnbnExtProcmtReplnmtStrgy.
-- 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: IPPKNBNPROCSTRAT

CREATE VIEW I_KnbnExtProcmtReplnmtStrgy AS
SELECT
  werks AS Plant,
  pkstf AS ExtProcurementReplnmtStrgy,
  pksaf AS KnbnCtrlCycExtProcmtCtrlType,
  bwawe AS GoodsReceiptMovementType,
  aussp AS SignalLockingTimeInMinutes,
  bsart AS PurchasingOrderType,
  cnscc AS PostCnsmpnToCostCtrExtProcmt,
  bwacc AS PostCnsmpnToCostCtrMvtType,
  uttrm AS SubDaySchedulingIsConsdrd,
  vpack AS UsageOfPackingInstructions,
  knttp AS CostCenterAcctAsgtCategory,
  cc_print_form AS KanbanCtrlCycPrintFormTemplate,
  kbform AS KanbanCtnPrintFormTemplate,
  post_sync_ewm_im AS GoodsMvtIsPostedSynchronously,
  kzakb AS SchedulingIsBasedOnCalcProfile,
  sddkz AS KnbnSDSchedgAgrmtDelivCrtnType
FROM tpk02
LEFT OUTER JOIN I_KnbnExtProcmtReplnmtStrgyTxt AS _Text ON ExtProcurementReplnmtStrgy = _Text.ExtProcurementReplnmtStrgy AND Plant = _Text.Plant  -- association [0..*]
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [0..1]
;