R_KanbanContainerTP

DDL: R_KANBANCONTAINERTP Type: view_entity TRANSACTIONAL Package: MD05_KCC_BO_RAP
48 Fields 1 Data Sources 1 Associations

Kanban Container - TP

R_KanbanContainerTP is a Transactional CDS View that provides data about "Kanban Container - TP" in SAP S/4HANA. It reads from 1 data source (I_KanbanContainer) and exposes 48 fields with key field KanbanContainer. It has 1 association to related views. Part of development package MD05_KCC_BO_RAP.

Data Sources (1)

SourceAliasJoin Type
I_KanbanContainer I_KanbanContainer from

Associations (1)

CardinalityTargetAliasCondition
[0..1] E_KanbanContainer _KanbanContainerExtension $projection.KanbanContainer = _KanbanContainerExtension.KanbanContainer

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Kanban Container - TP view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
VDM.viewType #TRANSACTIONAL view

Fields (48)

KeyFieldSource TableSource FieldDescription
KEY KanbanContainer KanbanContainer
KanbanControlCycle KanbanControlCycle
KanbanControlCycleItem KanbanControlCycleItem
KanbanContainerStatus KanbanContainerStatus
LastChangeDate LastChangeDate Time Stamp
LastChangeTime LastChangeTime Time changed
PreviousKanbanContainerStatus PreviousKanbanContainerStatus
PreviousLastChangeDate PreviousLastChangeDate
PreviousLastChangeTime PreviousLastChangeTime
IsLocked IsLocked
IsDeleted IsDeleted TRUE
ChangedPackgInstrnDataIsAvail ChangedPackgInstrnDataIsAvail
BaseUnit BaseUnit Unit of Measure
ActualQuantityInBaseUnit ActualQuantityInBaseUnit
RequestedQuantityInBaseUnit RequestedQuantityInBaseUnit Requested Qty
PlannedReceiptDateTime PlannedReceiptDateTime
Plant Plant Valuation Area
Supplier Supplier Supplier
PlannedOrder PlannedOrder
OrderID OrderID Order ID
PurchasingDocumentCategory PurchasingDocumentCategory Doc. Category
PurchasingDocument PurchasingDocument Purchasing Document
PurchasingDocumentItem PurchasingDocumentItem Purchasing Doc. Item
SequentialNmbrOfSuplrConf SequentialNmbrOfSuplrConf
SalesDocument SalesDocument SD Document
SalesDocumentItem SalesDocumentItem Sales Document Item
Reservation Reservation Reservation
ReservationItem ReservationItem Reservation Item
TransferRequirementNumber TransferRequirementNumber
TransferRequirementItem TransferRequirementItem
JITCallNumber JITCallNumber
JITCallItemNumber JITCallItemNumber Call Item Number
BackflushReportingPoint
Warehouse Warehouse Warehouse No.
EWMWarehouse EWMWarehouse Warehouse No.
WarehouseTask WarehouseTask Warehouse Task
EWMWarehouseRequest EWMWarehouseRequest
EWMWarehouseRequestItem EWMWarehouseRequestItem
MaterialDocument MaterialDocument Material Doc.
MaterialDocumentYear MaterialDocumentYear Material Document Year
MaterialDocumentItem MaterialDocumentItem Material Document Item
WhseGoodsMovementDocument WhseGoodsMovementDocument
WhseGoodsMovementDocumentItem WhseGoodsMovementDocumentItem
RepetitiveMfgConfirmation RepetitiveMfgConfirmation
_KanbanControlCycle _KanbanControlCycle
_Plant _Plant
_Supplier _Supplier
_SupplierCompanyByPlant _SupplierCompanyByPlant

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 R_KanbanContainerTP.
-- 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.

CREATE VIEW R_KanbanContainerTP AS
SELECT
  KanbanContainer,
  KanbanControlCycle,
  KanbanControlCycleItem,
  KanbanContainerStatus,
  LastChangeDate,
  LastChangeTime,
  PreviousKanbanContainerStatus,
  PreviousLastChangeDate,
  PreviousLastChangeTime,
  IsLocked,
  IsDeleted,
  ChangedPackgInstrnDataIsAvail,
  BaseUnit,
  ActualQuantityInBaseUnit,
  RequestedQuantityInBaseUnit,
  PlannedReceiptDateTime,
  Plant,
  Supplier,
  PlannedOrder,
  OrderID,
  PurchasingDocumentCategory,
  PurchasingDocument,
  PurchasingDocumentItem,
  SequentialNmbrOfSuplrConf,
  SalesDocument,
  SalesDocumentItem,
  Reservation,
  ReservationItem,
  TransferRequirementNumber,
  TransferRequirementItem,
  JITCallNumber,
  JITCallItemNumber,
  cast(BackflushReportingPoint as vdm_zpunkt) AS BackflushReportingPoint,
  Warehouse,
  EWMWarehouse,
  WarehouseTask,
  EWMWarehouseRequest,
  EWMWarehouseRequestItem,
  MaterialDocument,
  MaterialDocumentYear,
  MaterialDocumentItem,
  WhseGoodsMovementDocument,
  WhseGoodsMovementDocumentItem,
  RepetitiveMfgConfirmation
FROM I_KanbanContainer
LEFT OUTER JOIN E_KanbanContainer AS _KanbanContainerExtension ON KanbanContainer = _KanbanContainerExtension.KanbanContainer  -- association [0..1]
;

Learn More