Kanban - Interoperation Times and Stock Analysis

DataSource Transactional Data: 2LIS_04_PKKANBAN

Prerequisites: Activation of the DataSource.

This DataSource is used to extract data from the ODS object 0KB_DS01. When a user requests for data extraction, the data is extracted using a data communicator. The extracted data is then sent to the ODS object which is then transferred to the datasource. The updated data is sent to the infosource, 2LIS_04_PKKANBAN.

Technical Data

Application Component	Production Planning (PP)
Available as of Release	SAP ECC 6.0
Shipment	SAP NetWeaver 7.0 BI Content Addon-On 3 SP06
Content Versions	1
RemoteCube-Capable	No
Delta-Capable	Yes
Extraction from Archives	No
Verifiable	Yes

Data Modeling

Delta Update

AIM

Fields of Origin for the Extract Structure
Fields in the Extract Structure	Description of the Field in the Extract Structure	Table of Origin	Field in the Table of Origin
`ROCANCEL`	Indicator: Cancel Data Record	`–`	`—`
`.INCLUDE`	Extraction PP-BW: Kanban view from MCKANB
`ACPTD`	Actual Consumption Time in Days	`PKPS`	`PKBST, SADT2, SAUZ2`
`ACPTH`	Actual Consumption Time in Hours	`PKPS`	`PKBST, SADT2, SAUZ2`
`ACQTY`	Total Actual Container Quantity
`ACRTD`	Actual Kanban Correction Time in Days	`PKPS`	`PKBST, SAEDT, SAEUZ`
`ACRTH`	Actual Kanban Correction Time in Hours	`PKPS`	`PKBST, SAEDT, SAEUZ`
`AIPTD`	Actual In Process/In Transit Time in Days	`PKPS`	`PKBST, SAEDT, SAEUZ`
`AIPTH`	Actual In Process/In Transit Time in Hours	`PKPS`	`PKBST, SAEDT, SAEUZ`
`ARFTD`	Actual Refill Time in Days	`PKPS`	`PKBST, SADT2, SAUZ2`
`ARFTH`	Actual Refill Time in Hours	`PKPS`	`PKBST, SADT2, SAUZ2`
`ARLTD`	Actual Replenishment Lead Time in Days	`PKPS`	`PKBST, SADT2, SAUZ2`
`ARLTH`	Actual Replenishment Lead Time in Hours	`PKPS`	`PKBST, SADT2, SAUZ2`
`AWTTD`	Actual Wait Time in Days	`PKPS`	`PKBST, SAEDT, SAEUZ`
`AWTTH`	Actual Wait Time in Hours	`PKPS`	`PKBST, SAEDT, SAEUZ`
`BAMME`	Base Unit of Measure	`PKHD`	`MEINS`
`BEHAZ`	Number of Kanban Containers	`PKHD`	`MEINS`
`EMTYBX`	Number of Kanbans with Status "Empty"	`PKPS`	`PKBST`
`ERLTD`	Expected Replenishment Lead Time in Days	`PKHD`	`KWBZD`
`ERLTH`	Expected Replenishment Lead Time in Hours	`PKHD`	`KWBZM`
`ERRNM`	Number of Kanbans with Status "Error"	`PKPS`	`PKBST`
`FULLBX`	Number of Kanbans with Status "Full"	`PKPS`	`PKBST`
`LGORT`	Storage Location	`PVBE`	`LGORT`
`LIFNR`	Vendor Account Number	`PKHD`	`LIFNR`
`MATNR`	Material Number	`PKHD`	`MATNR`
`PROCMD`	Replenishment Type	`PKHD`	`PKSTE, PKSTF and PKSTU`
`PRVBE`	Supply Area	`PKHD`	`PRVBE`
`REPSTE`	Control Cycle Replenishment Strategy for External Replenish.	`PKHD`	`PKSTF`
`REPSTI`	Control Cycle Replenishment Strategy for In-House Production	`PKHD`	`PKSTE`
`REPSTS`	Control Cycle Replenishment Strategy for Stock Transfer	`PKHD`	`PKSTU`
`RGVRQ`	Person responsible for one or more supply areas	`PKHD`	`RGVER`
`RGVRV`	Person responsible for one or more supply areas	`PVBE`	`RGVER`
`SAEDT`	Last Changed On	`PKPS`	`SAEDT`
`SAEUZ`	Time of Last Status Change	`PKPS`	`SAEUZ`
`SIGAZ`	Maximum Number of Empty Containers	`PKHD`	`SIGAZ`
`SSLOC`	Storage Location	`PKHD`	`UMLGO`
`TOTSTCK`	Total Stock	`PKPS`	`PKIMG`
`TRQTY`	Total Target Container Quantity
`TRXHR`	Transaction Hour (Format HH)	`PKPS`	`SAEUZ`
`WERKS`	Plant	`PKHD`	`WERKS`

Verification of Key Figures

Key figures would be validated against LIS table S029 in SAP ECC 6.0

Kanban - Interoperation Times and Stock Analysis

Technical Data

Data Modeling

Delta Update

Verification of Key Figures

Unsychronized Backup Recovery in BI System