I_KANBANCONTAINER

CDS View

Kanban Container

I_KANBANCONTAINER is a CDS View in S/4HANA. Kanban Container. It contains 28 fields. 14 CDS views read from this table.

CDS Views using this table (14)

ViewTypeJoinVDMDescription
A_KanbanContainer view from COMPOSITE Kanban Containers
C_KanbanContainerMonitor view_entity from CONSUMPTION Monitor Kanban Container
C_ProductionSupplyItem view from CONSUMPTION CDS View Production Supply Item
C_ProductionSupplyItemDet view from CONSUMPTION CDS View Production Supply Item
I_Kanban view from BASIC Kanban
I_KanbanContainerDvtgData view inner BASIC Kanban Container Deviating Data
I_KanbanContainerStdVH view from COMPOSITE Kanban Container
I_KanbanContainerVH view from COMPOSITE Kanban Container Value Help
I_KanbanControlCycleItem view from COMPOSITE Kanban Control Cycle Item
I_KanbanCtnDetailedQty view inner COMPOSITE Kanban Container Detailed Quantities
I_KanbanOutput view from COMPOSITE Kanban Card
P_KnbnCtnBatchFieldControl view_entity from COMPOSITE Kanban Container Batch Field Control Calculation
P_KnbnCtnStatusAggregated view from CONSUMPTION Kanban Container Status Aggregated
R_KanbanContainerTP view_entity from TRANSACTIONAL Kanban Container - TP

Fields (28)

KeyField CDS FieldsUsed in Views
KEY KanbanContainer Kanban,KanbanContainer 4
KEY KanbanControlCycle KanbanControlCycle 4
_KanbanContainerStatus _KanbanContainerStatus 1
_KanbanControlCycle _KanbanControlCycle 1
_Plant _Plant 1
_ProductionSupplyArea _ProductionSupplyArea 1
_Supplier _Supplier 1
_SupplierCompanyByPlant _SupplierCompanyByPlant 1
ActualQuantityInBaseUnit ActualQuantityInBaseUnit 2
BaseUnit BaseUnit 1
IsLocked KanbanIsBlocked 1
KanbanContainerStatus KanbanContainerStatus,KanbanStatus 2
KanbanControlCycleItem KanbanControlCycleItem 2
LastChangeDate LastChangeDate 1
LastChangeTime LastChangeTime 1
MaterialDocument MaterialDocument 1
MaterialDocumentItem MaterialDocumentItem 1
OrderID OrderID 1
PlannedOrder PlannedOrder 1
Plant Plant 1
ProductionSupplyArea ProductionSupplyArea 1
RepetitiveMfgConfirmation RepetitiveMfgConfirmation 1
RequestedQuantityInBaseUnit RequestedQuantityInBaseUnit 1
Reservation Reservation 1
ReservationItem ReservationItem 1
SalesDocument SalesDocument 1
SalesDocumentItem SalesDocumentItem 1
Supplier Supplier 2

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Kanban Container
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_KANBANCONTAINER (
    KANBANCONTAINER,
    KANBANCONTROLCYCLE,
    _KANBANCONTAINERSTATUS,
    _KANBANCONTROLCYCLE,
    _PLANT,
    _PRODUCTIONSUPPLYAREA,
    _SUPPLIER,
    _SUPPLIERCOMPANYBYPLANT,
    ACTUALQUANTITYINBASEUNIT,
    BASEUNIT,
    ISLOCKED,
    KANBANCONTAINERSTATUS,
    KANBANCONTROLCYCLEITEM,
    LASTCHANGEDATE,
    LASTCHANGETIME,
    MATERIALDOCUMENT,
    MATERIALDOCUMENTITEM,
    ORDERID,
    PLANNEDORDER,
    PLANT,
    PRODUCTIONSUPPLYAREA,
    REPETITIVEMFGCONFIRMATION,
    REQUESTEDQUANTITYINBASEUNIT,
    RESERVATION,
    RESERVATIONITEM,
    SALESDOCUMENT,
    SALESDOCUMENTITEM,
    SUPPLIER,
    PRIMARY KEY (KANBANCONTAINER, KANBANCONTROLCYCLE)
);