I_KANBANCONTAINER
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)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| 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)
| Key | Field | CDS Fields | Used 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)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA