AD01WIP_DTL_RPT SAP (Results analysis: Basic structure for detailed WIP reporting) Structure details
Description: Results analysis: Basic structure for detailed WIP reporting
Related tables to AD01WIP_DTL_RPT
Access table AD01WIP_DTL_RPT
Structure field list including key, data, relationships and ABAP select examples
AD01WIP_DTL_RPT is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Results analysis: Basic structure for detailed WIP reporting" Information within sap ABAP programs.
This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.
i.e. DATA: wa_AD01WIP_DTL_RPT TYPE AD01WIP_DTL_RPT.
The AD01WIP_DTL_RPT table consists of various fields, each holding specific information or linking keys about Results analysis: Basic structure for detailed WIP reporting data available in SAP. These include RA_VERSN (Results Analysis Version), LINE_TYPE (Line type), OBJNR (Object number), POPER (Posting period).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class:Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP AD01WIP_DTL_RPT structure fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
DLINR | Number of the Dynamic Item | AD01DLINR | NUMC | 20 | Assigned to domain | AD01DLINR | |||
RA_VERSN | Results Analysis Version | VERSN_ABGR | CHAR | 3 | Assigned to domain | ALPHA | VERSN_ABGR | ACV | |
LINE_TYPE | Line type | AD01WIP_LINE_TYPE | CHAR | 1 | AD01WIP_LINE_TYPE | ||||
OBJNR | Object number | J_OBJNR | CHAR | 22 | ONR00 | J_OBJNR | ONR | ||
POPER | Posting period | AD01PERIOD | NUMC | 7 | PERI7 | JAHRPER | |||
TWAER | Transaction Currency | TWAER | CUKY | 5 | TCURC | WAERS | FWS | ||
MEINH | Unit of Measure | CO_MEINH | UNIT | 3 | T006 | CUNIT | MEINS | ||
MANUAL | Checkbox | XFELD | CHAR | 1 | XFELD | ||||
KSTAR | Cost Element | KSTAR | CHAR | 10 | Assigned to domain | ALPHA | KSTAR | KAT | |
KOSTL | Cost Center | KOSTL | CHAR | 10 | CSKS | ALPHA | KOSTL | KOS | |
LSTAR | Activity Type | LSTAR | CHAR | 6 | CSLA | LSTAR | LAR | LART_EMPTY | |
MATNR | Material Number | MATNR | CHAR | 18 | Assigned to domain | MATN1 | MATNR | MAT | S_MAT1 |
STAGR | Statistical key figure | STAGR | CHAR | 6 | TKA03 | STAGR | STA | ||
FIPOS | Commitment Item | FIPOS | CHAR | 14 | FMFPO | FIPOS | FIP | ||
WRTTP | Value Type | CO_WRTTP | CHAR | 2 | CO_WRTTP | ||||
VERSN | Version | VERSN | CHAR | 3 | TKVS | ALPHA | COVERSI | KVS | |
WERKS | Plant | WERKS_D | CHAR | 4 | T001W | WERKS | WRK | H_T001W_C | |
PRODU | Product number | PRODN | CHAR | 18 | MARA | MATN1 | MATNR | ||
FAKTF | Billing form | FAKTF | CHAR | 2 | FAKTF | ||||
BEMOT | Accounting Indicator | BEMOT | CHAR | 2 | TBMOT | BEMOT | |||
BELNR | Document Number | CO_BELNR | CHAR | 10 | Assigned to domain | ALPHA | CO_BELNR | BLN | |
BUZEI | Posting row | CO_BUZEI | NUMC | 3 | BUZEI | ||||
ARBPL | Work center | ARBPL | CHAR | 8 | ARBPL | AGR | |||
AWERK | Plant of Work Center | AD01AWERK | CHAR | 4 | T001W | WERKS | H_T001W | ||
PRZNR | Business Process | CO_PRZNR | CHAR | 12 | CBPR | ALPHA | CO_PRZNR | KWP | |
ASNUM | Activity Number | ASNUM | CHAR | 18 | ASMD | ALPHA | ASNUM | ASN | |
PERNR | Personnel Number | HR_PERNR | NUMC | 8 | PERNR | PER | |||
Z_OBJNR2 | 0 | Assigned to domain | |||||||
Z_PRS_OFFSHORE | 0 | ||||||||
Z_PRS_BILL_FLAG | 0 | ||||||||
Z_PRS_COUNTRY | Country Key | LAND1 | CHAR | 3 | Assigned to domain | LAND1 | LND | ||
Z_PRS_CHARGELEVL | 0 | ||||||||
.INCLU--AP | 0 | ||||||||
/CBAD/ORIG_OBJNR | CBAD Original Object Number | /CBAD/ORIG_OBJNR | CHAR | 22 | Assigned to domain | J_OBJNR | |||
/CBAD/BILL_WBS | CBAD WBS Element | /CBAD/PS_POSNR | NUMC | 8 | Assigned to domain | ABPSP | PS_POSNR | ||
.INCLU--AP | 0 | ||||||||
PRS_WORK_PERIOD | Work Period (Internal Representation) | PRS_WORK_PERIOD | NUMC | 7 | PRSWP | PRS_WORK_PERIOD | |||
.INCLU--AP | 0 | ||||||||
GSBER | Business Area | GSBER | CHAR | 4 | Assigned to domain | GSBER | GSB | ||
PARGB | Trading partner's business area | PARGB | CHAR | 4 | Assigned to domain | GSBER | GSB | ||
PRCTR | Profit Center | PRCTR | CHAR | 10 | Assigned to domain | ALPHA | PRCTR | PRC | PRCTR_EMPTY |
PPRCTR | Partner Profit Center | PPRCTR | CHAR | 10 | Assigned to domain | ALPHA | PRCTR | PPC | |
.INCLU--AP | 0 | ||||||||
WTY_IND | Warranty indicator | WTYSC_WTY_INDICATOR | CHAR | 1 | WTYSC_WTY_INDICATOR | ||||
ORDERED_PROD | Product Name Entered | CRMT_ORDERED_PROD_DB | CHAR | 54 | CRM_ORDERED_PROD | ||||
CATEGORY_ID | Category ID | COMT_CATEGORY_ID | CHAR | 20 | COM_CATEGORY_ID | COM_CATEGORY_ID | COM_CAT_HIER | ||
AWSYS | Logical system of source document | AWSYS | CHAR | 10 | Assigned to domain | ALPHA | LOGSYS | ||
SERV_AGENT_ID | Business Partner Number | BU_PARTNER | CHAR | 10 | Assigned to domain | ALPHA | BU_PARTNER | BPA | BUPA |
REF_OBJECT_ID | Transaction Number | CRMT_OBJECT_ID_DB | CHAR | 10 | ALPHA | CRM_OBJECT_ID | |||
REF_OBJECT_ITEM | Item Number in Document | CRMT_ITEM_NO | NUMC | 10 | CRM_ITEM_NO | ||||
.INCLU--AP | 0 | ||||||||
CPD_DLIID | Billing ID for Commercial Project Management | /CPD/PWS_BILLING_DLIID | NUMC | 10 | /CPD/PWS_BILLING_DLIID | ||||
.INCLU--AP | 0 | ||||||||
ORIG_OBJNR | Object Number of Original Object | DPICB_OBJNR | CHAR | 22 | Assigned to domain | J_OBJNR | |||
.INCLU--AP | 0 | ||||||||
FAREA | Functional Area | FM_FAREA | CHAR | 16 | Assigned to domain | FKBER | FBE | ||
RGRANT_NBR | Grant | GM_GRANT_NBR | CHAR | 20 | ALPHA | GM_GRANT_NBR | GM_GRANT_NBR | GRANTS_GENERIC | |
WBS_ELEMENT | WBS Element | PS_POSNR | NUMC | 8 | Assigned to domain | ABPSP | PS_POSNR | ||
ORDERID | Order Number | AUFNR | CHAR | 12 | Assigned to domain | ALPHA | AUFNR | ANR | |
FUNDS_CTR | Funds Center | FISTL | CHAR | 16 | Assigned to domain | FISTL | FIS | ||
FUND | Fund | BP_GEBER | CHAR | 10 | Assigned to domain | BP_GEBER | FIC | ||
SPONSORED_PROG | Sponsored Program | GM_SPONSORED_PROG | CHAR | 20 | Assigned to domain | GM_SPONSORED_PROG | GM_SPONSORED_PROG | ||
SPONSORED_CLASS | Sponsored Class | GM_SPONSORED_CLASS | CHAR | 20 | Assigned to domain | GM_SPONSORED_CLASS | GM_SPONSORED_CLASS | ||
GL_SIRID | Record number of the line item record | GU_RECID | CHAR | 18 | OBJNR | OBN | |||
REFDOCNR | Reference document number of an accounting document | REFBELNR | CHAR | 10 | ALPHA | BELNR | BLN | ||
REFDOCLN | Six-digit number of the reference posting line | REFBUZEI6 | NUMC | 6 | BUZEI6 | BUZ | |||
SGTXT | Item Text | SGTXT | CHAR | 50 | TEXT50 | ||||
GM_VALUETYPE | GM Value Type | GM_VALUETYPE | CHAR | 2 | GM_VALUETYPE | GMVALUETYPE | |||
ASSETMAINO | Main Asset Number | BF_ANLN1 | CHAR | 12 | ALPHA | BF_ANLN1 | AN1 | ||
ASSETSUBNO | Asset Subnumber | BF_ANLN2 | CHAR | 4 | ALPHA | BF_ANLN2 | AN2 | ||
BUDGET_PD | FM: Budget Period | FM_BUDGET_PERIOD | CHAR | 10 | Assigned to domain | FM_BUDGET_PERIOD | BUDPER | ||
DLISRC | Dynamic Item Source | AD01DLISRC | CHAR | 4 | AD01SRC | AD01DLISRC | |||
PROFNR | Dynamic Item Processor Profile | AD01PROFNR | CHAR | 8 | AD01C_PROF | AD01PROFNR | AD0 | DIP_PROFILE | |
HWAER | Local Currency | HWAER | CUKY | 5 | Assigned to domain | WAERS | |||
KWAER | Controlling area currency | KWAER | CUKY | 5 | Assigned to domain | WAERS | KWS | ||
RV_WAERS | Currency code for WIP revenue | AD01REV_WAERS | CUKY | 5 | Assigned to domain | WAERS | |||
ABC_WTG | Already billed costs (transaction currency) | AD01ABC_WTG | CURR | 15(2) | WERTV8 | ||||
ABC_WOG | Already billed costs (company code currency) | AD01ABC_WOG | CURR | 15(2) | WERTV8 | ||||
ABC_WKG | Already billed costs (CO Area currency) | AD01ABC_WKG | CURR | 15(2) | WERTV8 | ||||
ABC_MEG | Already billed quantity | AD01ABC_MEG | QUAN | 15(3) | MENGV8 | ||||
NOC_WTG | Already rejected costs (transaction currency) | AD01NOC_WTG | CURR | 15(2) | WERTV8 | ||||
NOC_WOG | Already rejected costs (Company Code currency) | AD01NOC_WOG | CURR | 15(2) | WERTV8 | ||||
NOC_WKG | Already rejected costs (CO Area currency) | AD01NOC_WKG | CURR | 15(2) | WERTV8 | ||||
NOC_MEG | Already rejected quantity | AD01NOC_MEG | QUAN | 15(3) | MENGV8 | ||||
TBC_WTG | Not yet billed costs (WIP costs) (transaction currency) | AD01TBC_WTG | CURR | 15(2) | WERTV8 | ||||
TBC_WOG | Not yet billed costs (WIP costs) (Company Code currency) | AD01TBC_WOG | CURR | 15(2) | WERTV8 | ||||
TBC_WKG | Not yet billed costs (WIP costs) (CO Area currency) | AD01TBC_WKG | CURR | 15(2) | WERTV8 | ||||
TBC_MEG | Not yet billed quantity (WIP quantity) | AD01TBC_MEG | QUAN | 15(3) | MENGV8 | ||||
TBR_WTG | Revenue to be billed (revenue currency) | AD01REV_WTG | CURR | 15(2) | WERTV8 | ||||
TBR_WOG | Revenue to be billed (Company Code currency) | AD01REV_WOG | CURR | 15(2) | WERTV8 | ||||
TBR_WKG | Revenue to be billed (CO Area currency) | AD01REV_WKG | CURR | 15(2) | WERTV8 | ||||
REV_KSTAR | Cost element for billing | AD01REV_KSTAR | CHAR | 10 | CSKA | ALPHA | KSTAR | ||
REV_MATNR | Material Determination for Dynamic Items | AD01INVMAT | CHAR | 18 | MARA | MATN1 | MATNR | ||
REV_WTG | Revenue to be billed (revenue currency) | AD01REV_WTG | CURR | 15(2) | WERTV8 | ||||
REV_WOG | Revenue to be billed (Company Code currency) | AD01REV_WOG | CURR | 15(2) | WERTV8 | ||||
REV_WKG | Revenue to be billed (CO Area currency) | AD01REV_WKG | CURR | 15(2) | WERTV8 | ||||
POSID | Work Breakdown Structure Element (WBS Element) | PS_POSID | CHAR | 24 | PROJN | PS_POSID | PRO | ||
VBELN | Sales Document | VBELN_VA | CHAR | 10 | Assigned to domain | ALPHA | VBELN | AUN | |
VBPOS | Sales Document Item | POSNR_VA | NUMC | 6 | Assigned to domain | POSNR | APO | ||
AUFNR | Order Number | AUFNR | CHAR | 12 | AUFK | ALPHA | AUFNR | ANR | |
RCATID | WIP Revenue Category ID | AD01WIP_RCATID | CHAR | 5 | AD01WIP_RCAT | AD01WIP_RCATID | |||
WIP_AGE | Age of a WIP item (in work periods) | AD01WIP_AGE | NUMC | 5 | |||||
WIP_AGE_UNIT | Unit for WIP age | AD01WIP_AGE_UNIT | CHAR | 10 | TEXT10 |
Key field | Non-key field |
How do I retrieve data from SAP structure AD01WIP_DTL_RPT using ABAP code?
As AD01WIP_DTL_RPT is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on AD01WIP_DTL_RPT as there is no data to select.How to access SAP table AD01WIP_DTL_RPT
Within an ECC or HANA version of SAP you can also view further information about AD01WIP_DTL_RPT and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects