S029

KANBAN | #transactional | Component: Data Collection
Column Name Description
MANDT FK Client
SSOUR Statistic(s) origin
VRSIO Version number in the information structure
SPMON Period to analyze - month
SPTAG Period to analyze - current date
SPWOC Period to analyze - week
SPBUP Period to analyze - posting period
WERKS FK Plant
PRVBE FK Production Supply Area
LGORT FK Storage location
MATNR FK Material Number
RGVRV FK Person responsible for one or more supply areas
Column Name Description
Column Name Description
📏 Base Unit of Measure (BASME):
BEHMG Container Quantity
SMIST Total container quantity; actual
SMSOL Total container quantity; target
Column Name Description
SPTAG Period to analyze - current date
Column Name Description
Column Name Description Domain name
VWDAT Pointer to administrative data VWDAT
AZBFF Number of external replenishment operations ANZWB
AZ1N2 Number of signals from status 1 to 2 ANZWB
AZBFE Number of in-house production operations ANZWB
AZFEH Number of errors in container processing ANZWB
AZLIG Number of wait operations, status 5 to 1 or 2 ANZWB
AZ4N5 Number of transfer operations, status 4 to 5 ANZWB
AZBFU Number of replenishment operations for stock transfer ANZWB
AZ2N4 Number of refill operations: status 2 to 4 ANZWB
AZWIB Number of replenishment operations from status 2 to 5 ANZWB
AZWB0 Number of replenishment operations on the same day ANZWB
BEHAZ Number of Kanban Containers BEHAZ
D1N2Z Total trigger times from status 1 to 2 PKSUZ
DFEHZ Sum of the times in error status 9 PKSUZ
DLIGZ Sum of the wait times from status 5 to 1 or 2 PKSUZ
D4N5Z Total of the times from status 4 to 5 PKSUZ
D2N4Z Sum of the refill times from status 2 to 4 PKSUZ
DWIBZ Sum of the total replenishment lead time from status 2 to 5 PKSUZ
Master Data Relations Join Conditions
Storage location
  • Storage location
  • Client
  • Plant
  • S029.LGORT == T001L.LGORT
  • S029.MANDT == T001L.MANDT
  • S029.WERKS == T001L.WERKS
Client S029.MANDT == T000.MANDT
Material Number
  • Material Number
  • Client
  • S029.MATNR == MARA.MATNR
  • S029.MANDT == MARA.MANDT
Fiscal Year Variant
  • Fiscal Year Variant
  • Client
  • S029.PERIV == T009.PERIV
  • S029.MANDT == T009.MANDT
Production Supply Area
  • Production Supply Area
  • Plant
  • Client
  • S029.PRVBE == PVBE.PRVBE
  • S029.WERKS == PVBE.WERKS
  • S029.MANDT == PVBE.MANDT
Person responsible for one or more supply areas
  • Plant
  • Person responsible for one or more supply areas
  • Client
  • S029.WERKS == T024D.WERKS
  • S029.RGVRV == T024D.DISPO
  • S029.MANDT == T024D.MANDT
Plant
  • S029.MANDT == T001W.MANDT
  • S029.WERKS == T001W.WERKS