Thursday, July 25, 2024

SAP Table AD01WIP_DTL – WIP Details

AD01WIP_DTL is a standard SAP table in SAP ECC (or) S/4HANA which stores WIP Details data. There are total 24 fields in AD01WIP_DTL table.This blog post provides key technical details of SAP table AD01WIP_DTL, including its availability across SAP S/4HANA versions and the list of CDS views for AD01WIP_DTL table in SAP.

SAP HANA Table Type Column Store
Buffering Permission Buffering not allowed
Buffering Type No buffering
Package DI Processor (Resource-Related Billing/Sales Pricing) (AD01)
Technical Component Revenues and Earnings (PS-REV)

SAP AD01WIP_DTL Table Fields

The following is the list of fields that are available in SAP AD01WIP_DTL table. The key fields of the table are highlighted in color.

Field Description Data Element Domain Check Table Data Type
MANDT Client MANDT MANDT T000 CLNT (3)
DLINR Number of the Dynamic Item AD01DLINR AD01DLINR AD01DLI NUMC (20)
RA_VERSN Results Analysis Version VERSN_ABGR VERSN_ABGR TKKAP CHAR (3)
BELNR Document Number CO_BELNR CO_BELNR CHAR (10)
TIMESTAMP UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TIMESTAMP TZNTSTMPS DEC (15)
HWAER Local Currency HWAER WAERS * CUKY (5)
KWAER Controlling area currency KWAER WAERS * CUKY (5)
RV_WAERS Currency code for WIP revenue AD01REV_WAERS WAERS * CUKY (5)
ABC_WTG Already billed costs (transaction currency) AD01ABC_WTG WERTV8 CURR (15)
ABC_WOG Already billed costs (company code currency) AD01ABC_WOG WERTV8 CURR (15)
ABC_WKG Already billed costs (CO Area currency) AD01ABC_WKG WERTV8 CURR (15)
ABC_MEG Already billed quantity AD01ABC_MEG MENGV8 QUAN (15)
NOC_WTG Already rejected costs (transaction currency) AD01NOC_WTG WERTV8 CURR (15)
NOC_WOG Already rejected costs (Company Code currency) AD01NOC_WOG WERTV8 CURR (15)
NOC_WKG Already rejected costs (CO Area currency) AD01NOC_WKG WERTV8 CURR (15)
NOC_MEG Already rejected quantity AD01NOC_MEG MENGV8 QUAN (15)
TBC_WTG Not yet billed costs (WIP costs) (transaction currency) AD01TBC_WTG WERTV8 CURR (15)
TBC_WOG Not yet billed costs (WIP costs) (Company Code currency) AD01TBC_WOG WERTV8 CURR (15)
TBC_WKG Not yet billed costs (WIP costs) (CO Area currency) AD01TBC_WKG WERTV8 CURR (15)
TBC_MEG Not yet billed quantity (WIP quantity) AD01TBC_MEG MENGV8 QUAN (15)
TBR_WTG Revenue to be billed (revenue currency) AD01REV_WTG WERTV8 CURR (15)
TBR_WOG Revenue to be billed (Company Code currency) AD01REV_WOG WERTV8 CURR (15)
TBR_WKG Revenue to be billed (CO Area currency) AD01REV_WKG WERTV8 CURR (15)
FBUDA Date on which services are rendered FBUDA DATUM DATS (8)

Availability

The SAP table AD01WIP_DTL is available within SAP S/4HANA On-premise and SAP S/4HANA Cloud systems depending on the version and release level.

SAP S/4HANA Version Available?
1909 Yes
2020 Yes
2021 Yes
2022 Yes
2023 Yes

CDS Views for AD01WIP_DTL table

The following is the list of AD01WIP_DTL CDS views, which can also be used instead of AD01WIP_DTL table based on your business requirements.

CDS View CDS View Type Description
I_WORKINPROCESSDETAIL BASIC Detail WIP from DIP data
P_PROJECTWIPREVDETLBASIC BASIC Project WIP with revenue from DIP
P_WIPDETAILBASIC BASIC Detail WIP from DIP data
P_WIPDETAILBASIC1 BASIC Detail WIP from DIP data
I_ALERTWORKINPROGRESS COMPOSITE Master Project Alert for High Risk
I_HIERCOSTERP COMPOSITE Hierarchical Cost status: ERP scenario
I_HIERCOSTSTATUSACTUAL COMPOSITE Fetch Actuals for Hierarchical Cost stauts report
I_MASTERPROJECTACTUALSKPI COMPOSITE Get Actuals KPI for master project
I_MPUNBILLEDREVENU COMPOSITE Master Project Unbilled Revenu
I_MSTRPROJACTLCALMNTHCOSTQTY COMPOSITE Commercial Proj Actual Cost Qty by Month
I_MSTRPROJACTLCOSTQTY COMPOSITE Commercial Project Actual Input Cost Qty
I_MSTRPROJCOSTQTY COMPOSITE Commercial Project Actual Cost and Qty
I_MSTRPROJCOSTQTYWTHTOTCOST COMPOSITE Commercial Project Actual Cost Status
I_MSTRPROJKPIERP COMPOSITE KPI for ERP scenario
I_MSTRPROJWORKINPROGRESS COMPOSITE Master Project Work in Progress
I_PROJECTWIPDETAIL COMPOSITE WIP Detail view for projects
P_ERPACTUALWIP COMPOSITE ERP acenario Actuals and WIP
P_MASTERPROJECTACTUALS COMPOSITE Union of total actuals and actuals till month
P_MSTRPROJACTLCOSTQTY COMPOSITE Actuals for Master Project
P_MSTRPROJACTUALWIP COMPOSITE Master Project Actuals with WIP
P_MSTRPROJACTUALWIPCOST COMPOSITE Actual cost with work in progress
P_MSTRPROJKPIERP COMPOSITE Plan and actual cost: ERP scenario
P_MSTRPROJPLANACTUAL COMPOSITE Master Project Plan Actual
P_MSTRPROJPLANCOST COMPOSITE Plan Cost
P_MSTRPROJWIP COMPOSITE Master Project WIP
P_MSTRPROJWIPCNTROBJ COMPOSITE WIP at Controlling object
P_MSTRPROJWIPINPROJCRCY COMPOSITE Master Proj WIP in Project Currency
P_PROJECTWIPDETAILBASIC COMPOSITE WIP Detail for WBS elements
C_MSTRPROJACTLCALMNTHCOSTQTY CONSUMPTION Commercial Proj Actual Cost Qty by Month
C_PROJECTWIPDETAIL CONSUMPTION WIP Detail View for projects
P_PROJECTWIPDETAIL1 CONSUMPTION WIP Detail view for projects