I_KanbanContainerTP

DDL: I_KANBANCONTAINERTP Type: view_entity TRANSACTIONAL Package: MD05_KCC_BO_INTF
48 Fields 1 Data Sources

Kanban Container - TP

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

Data Sources (1)

SourceAliasJoin Type
R_KanbanContainerTP R_KanbanContainerTP projection

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Kanban Container - TP 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 #TRANSACTIONAL view
ObjectModel.modelingPattern #TRANSACTIONAL_INTERFACE view
Metadata.ignorePropagatedAnnotations true 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
LastChangeDateTime LastChangeDateTime Timestamp
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 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
_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 I_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 I_KanbanContainerTP AS
SELECT
  KanbanContainer,
  KanbanControlCycle,
  KanbanControlCycleItem,
  KanbanContainerStatus,
  LastChangeDate,
  LastChangeTime,
  PreviousKanbanContainerStatus,
  PreviousLastChangeDate,
  PreviousLastChangeTime,
  IsLocked,
  IsDeleted,
  ChangedPackgInstrnDataIsAvail,
  LastChangeDateTime,
  BaseUnit,
  ActualQuantityInBaseUnit,
  RequestedQuantityInBaseUnit,
  PlannedReceiptDateTime,
  Plant,
  Supplier,
  PlannedOrder,
  OrderID,
  PurchasingDocumentCategory,
  PurchasingDocument,
  PurchasingDocumentItem,
  SequentialNmbrOfSuplrConf,
  SalesDocument,
  SalesDocumentItem,
  Reservation,
  ReservationItem,
  TransferRequirementNumber,
  TransferRequirementItem,
  JITCallNumber,
  JITCallItemNumber,
  BackflushReportingPoint,
  Warehouse,
  EWMWarehouse,
  WarehouseTask,
  EWMWarehouseRequest,
  EWMWarehouseRequestItem,
  MaterialDocument,
  MaterialDocumentYear,
  MaterialDocumentItem,
  WhseGoodsMovementDocument,
  WhseGoodsMovementDocumentItem,
  RepetitiveMfgConfirmation
FROM R_KanbanContainerTP
;

Learn More