SAP ABAP Table AD01WIP_DTL_RPT (Results analysis: Basic structure for detailed WIP reporting)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ CO-PC-OBJ (Application Component) Cost Object Controlling
     ⤷ AD01_BIW_PI (Package) PS-REV: Interface to Business Information Warehouse

Basic Data

Table Category	INTTAB	Structure
Structure	AD01WIP_DTL_RPT	Table Relationship Diagram
Short Description	Results analysis: Basic structure for detailed WIP reporting

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	DLINR	☐	AD01DLINR	AD01DLINR	NUMC	20	0	Number of the Dynamic Item	*
2	RA_VERSN	☐	VERSN_ABGR	VERSN_ABGR	CHAR	3	0	Results Analysis Version	*
3	LINE_TYPE	☐	AD01WIP_LINE_TYPE	AD01WIP_LINE_TYPE	CHAR	1	0	Line type
4	.INCLUDE	☐				0	0	Independent Parameters of Dynamic Items
5	.INCLUDE	☐				0	0	Mandatory Parameters of Dynamic Items
6	OBJNR	☐	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	ONR00
7	POPER	☐	AD01PERIOD	JAHRPER	NUMC	7	0	Posting period
8	TWAER	☐	TWAER	WAERS	CUKY	5	0	Transaction Currency	TCURC
9	MEINH	☐	CO_MEINH	MEINS	UNIT	3	0	Unit of Measure	T006
10	MANUAL	☐	XFELD	XFELD	CHAR	1	0	Checkbox
11	.INCLUDE	☐				0	0	Independent Parameters of a Dynamic Item
12	KSTAR	☐	KSTAR	KSTAR	CHAR	10	0	Cost Element	*
13	KOSTL	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	CSKS
14	LSTAR	☐	LSTAR	LSTAR	CHAR	6	0	Activity Type	CSLA
15	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	*
16	STAGR	☐	STAGR	STAGR	CHAR	6	0	Statistical key figure	TKA03
17	FIPOS	☐	FIPOS	FIPOS	CHAR	14	0	Commitment Item	FMFPO
18	WRTTP	☐	CO_WRTTP	CO_WRTTP	CHAR	2	0	Value Type
19	VERSN	☐	VERSN	COVERSI	CHAR	3	0	Version	TKVS
20	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
21	PRODU	☐	PRODN	MATNR	CHAR	18	0	Product number	MARA
22	FAKTF	☐	FAKTF	FAKTF	CHAR	2	0	Billing Form
23	BEMOT	☐	BEMOT	BEMOT	CHAR	2	0	Accounting Indicator	TBMOT
24	BELNR	☐	CO_BELNR	CO_BELNR	CHAR	10	0	Document Number	*
25	BUZEI	☐	CO_BUZEI	BUZEI	NUMC	3	0	Posting row
26	ARBPL	☐	ARBPL	ARBPL	CHAR	8	0	Work center
27	AWERK	☐	AD01AWERK	WERKS	CHAR	4	0	Plant of Work Center	T001W
28	PRZNR	☐	CO_PRZNR	CO_PRZNR	CHAR	12	0	Business Process	CBPR
29	ASNUM	☐	ASNUM	ASNUM	CHAR	18	0	Activity Number	ASMD
30	PERNR	☐	HR_PERNR	PERNR	NUMC	8	0	Personnel Number
31	.INCLUDE	☐				0	0
32	.INCLUDE	☐				0	0
33	.INCLU--AP	☐				0	0	Contract and Billing: Append
34	/CBAD/ORIG_OBJNR	☐	/CBAD/ORIG_OBJNR	J_OBJNR	CHAR	22	0	CBAD Original Object Number	*
35	/CBAD/BILL_WBS	☐	/CBAD/PS_POSNR	PS_POSNR	NUMC	8	0	CBAD WBS Element	*
36	.INCLU--AP	☐				0	0	Commercial Project Inception & Lean Staffing append.ATTRI2
37	PRS_WORK_PERIOD	☐	PRS_WORK_PERIOD	PRS_WORK_PERIOD	NUMC	7	0	Work Period (Internal Representation)
38	.INCLU--AP	☐				0	0	Append Structure for Additional Account Assignment Info
39	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	*
40	PARGB	☐	PARGB	GSBER	CHAR	4	0	Trading partner's business area	*
41	PRCTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center	*
42	PPRCTR	☐	PPRCTR	PRCTR	CHAR	10	0	Partner Profit Center	*
43	.INCLUDE	☐				0	0	Additional Characteristics for Billing from SRM
44	ORDERED_PROD	☐	CRMT_ORDERED_PROD_DB	CRM_ORDERED_PROD	CHAR	54	0	Product Name Entered
45	CATEGORY_ID	☐	COMT_CATEGORY_ID	COM_CATEGORY_ID	CHAR	20	0	Category ID
46	AWSYS	☐	AWSYS	LOGSYS	CHAR	10	0	Logical system of source document	*
47	SERV_AGENT_ID	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
48	REF_OBJECT_ID	☐	CRMT_OBJECT_ID_DB	CRM_OBJECT_ID	CHAR	10	0	Transaction ID
49	REF_OBJECT_ITEM	☐	CRMT_ITEM_NO	CRM_ITEM_NO	NUMC	10	0	Item Number in Document
50	.INCLU--AP	☐				0	0	Additional Characteristics for Billing Between Company Codes
51	.INCLUDE	☐				0	0	Additional Characteristics for Billing Between Company Codes
52	ORIG_OBJNR	☐	DPICB_OBJNR	J_OBJNR	CHAR	22	0	Object Number of Original Object	*
53	.INCLU--AP	☐				0	0	Characteristics for Grants Mgmt.
54	.INCLUDE	☐				0	0	Additional characteristics for Grants Mgmt.
55	FAREA	☐	FM_FAREA	FKBER	CHAR	16	0	Functional Area	*
56	RGRANT_NBR	☐	GM_GRANT_NBR	GM_GRANT_NBR	CHAR	20	0	Grant
57	WBS_ELEMENT	☐	PS_POSNR	PS_POSNR	NUMC	8	0	WBS Element	*
58	ORDERID	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	*
59	FUNDS_CTR	☐	FISTL	FISTL	CHAR	16	0	Funds Center	*
60	FUND	☐	BP_GEBER	BP_GEBER	CHAR	10	0	Fund	*
61	SPONSORED_PROG	☐	GM_SPONSORED_PROG	GM_SPONSORED_PROG	CHAR	20	0	Sponsored Program	*
62	SPONSORED_CLASS	☐	GM_SPONSORED_CLASS	GM_SPONSORED_CLASS	CHAR	20	0	Sponsored Class	*
63	GL_SIRID	☐	GU_RECID	OBJNR	CHAR	18	0	Record number of the line item record
64	REFDOCNR	☐	REFBELNR	BELNR	CHAR	10	0	Reference document number of an accounting document
65	REFDOCLN	☐	REFBUZEI6	BUZEI6	NUMC	6	0	Six-digit number of the reference posting line
66	SGTXT	☐	SGTXT	TEXT50	CHAR	50	0	Item Text
67	GM_VALUETYPE	☐	GM_VALUETYPE	GM_VALUETYPE	CHAR	2	0	GM Value Type
68	ASSETMAINO	☐	BF_ANLN1	BF_ANLN1	CHAR	12	0	Main Asset Number
69	ASSETSUBNO	☐	BF_ANLN2	BF_ANLN2	CHAR	4	0	Asset Subnumber
70	DLISRC	☐	AD01DLISRC	AD01DLISRC	CHAR	4	0	Dynamic Item Source	AD01SRC
71	PROFNR	☐	AD01PROFNR	AD01PROFNR	CHAR	8	0	Dynamic Item Processor Profile	AD01C_PROF
72	HWAER	☐	HWAER	WAERS	CUKY	5	0	Local Currency	*
73	KWAER	☐	KWAER	WAERS	CUKY	5	0	Controlling area currency	*
74	RV_WAERS	☐	AD01REV_WAERS	WAERS	CUKY	5	0	Currency code for WIP revenue	*
75	ABC_WTG	☐	AD01ABC_WTG	WERTV8	CURR	15	2	Already billed costs (transaction currency)
76	ABC_WOG	☐	AD01ABC_WOG	WERTV8	CURR	15	2	Already billed costs (company code currency)
77	ABC_WKG	☐	AD01ABC_WKG	WERTV8	CURR	15	2	Already billed costs (CO Area currency)
78	ABC_MEG	☐	AD01ABC_MEG	MENGV8	QUAN	15	3	Already billed quantity
79	NOC_WTG	☐	AD01NOC_WTG	WERTV8	CURR	15	2	Already rejected costs (transaction currency)
80	NOC_WOG	☐	AD01NOC_WOG	WERTV8	CURR	15	2	Already rejected costs (Company Code currency)
81	NOC_WKG	☐	AD01NOC_WKG	WERTV8	CURR	15	2	Already rejected costs (CO Area currency)
82	NOC_MEG	☐	AD01NOC_MEG	MENGV8	QUAN	15	3	Already rejected quantity
83	TBC_WTG	☐	AD01TBC_WTG	WERTV8	CURR	15	2	Not yet billed costs (WIP costs) (transaction currency)
84	TBC_WOG	☐	AD01TBC_WOG	WERTV8	CURR	15	2	Not yet billed costs (WIP costs) (Company Code currency)
85	TBC_WKG	☐	AD01TBC_WKG	WERTV8	CURR	15	2	Not yet billed costs (WIP costs) (CO Area currency)
86	TBC_MEG	☐	AD01TBC_MEG	MENGV8	QUAN	15	3	Not yet billed quantity (WIP quantity)
87	TBR_WTG	☐	AD01REV_WTG	WERTV8	CURR	15	2	Revenue to be billed (revenue currency)
88	TBR_WOG	☐	AD01REV_WOG	WERTV8	CURR	15	2	Revenue to be billed (Company Code currency)
89	TBR_WKG	☐	AD01REV_WKG	WERTV8	CURR	15	2	Revenue to be billed (CO Area currency)
90	REV_KSTAR	☐	AD01REV_KSTAR	KSTAR	CHAR	10	0	Cost element for billing	CSKA
91	REV_MATNR	☐	AD01INVMAT	MATNR	CHAR	18	0	Material Determination for Dynamic Items	MARA
92	REV_WTG	☐	AD01REV_WTG	WERTV8	CURR	15	2	Revenue to be billed (revenue currency)
93	REV_WOG	☐	AD01REV_WOG	WERTV8	CURR	15	2	Revenue to be billed (Company Code currency)
94	REV_WKG	☐	AD01REV_WKG	WERTV8	CURR	15	2	Revenue to be billed (CO Area currency)
95	POSID	☐	PS_POSID	PS_POSID	CHAR	24	0	Work Breakdown Structure Element (WBS Element)
96	VBELN	☐	VBELN_VA	VBELN	CHAR	10	0	Sales Document	*
97	VBPOS	☐	POSNR_VA	POSNR	NUMC	6	0	Sales Document Item	*
98	AUFNR	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	AUFK
99	RCATID	☐	AD01WIP_RCATID	AD01WIP_RCATID	CHAR	5	0	WIP Revenue Category ID	AD01WIP_RCAT
100	WIP_AGE	☐	AD01WIP_AGE		NUMC	5	0	Age of a WIP item (in work periods)
101	WIP_AGE_UNIT	☐	AD01WIP_AGE_UNIT	TEXT10	CHAR	10	0	Unit for WIP age

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	AD01WIP_DTL_RPT	ASNUM	ASMD	ASNUM
2	AD01WIP_DTL_RPT	AUFNR	AUFK	AUFNR
3	AD01WIP_DTL_RPT	AWERK	T001W	WERKS
4	AD01WIP_DTL_RPT	BEMOT	TBMOT	BEMOT
5	AD01WIP_DTL_RPT	DLISRC	AD01SRC	DLISRC	KEY	1	CN
6	AD01WIP_DTL_RPT	FIPOS	FMFPO	FIPOS
7	AD01WIP_DTL_RPT	KOSTL	CSKS	KOSTL
8	AD01WIP_DTL_RPT	LSTAR	CSLA	LSTAR
9	AD01WIP_DTL_RPT	MEINH	T006	MSEHI	KEY	1	CN
10	AD01WIP_DTL_RPT	OBJNR	ONR00	OBJNR	KEY	1	CN
11	AD01WIP_DTL_RPT	PRODU	MARA	MATNR
12	AD01WIP_DTL_RPT	PROFNR	AD01C_PROF	PROFNR	KEY	1	CN
13	AD01WIP_DTL_RPT	PRZNR	CBPR	PRZNR
14	AD01WIP_DTL_RPT	RCATID	AD01WIP_RCAT	RCATID
15	AD01WIP_DTL_RPT	REV_KSTAR	CSKA	KSTAR
16	AD01WIP_DTL_RPT	REV_MATNR	MARA	MATNR
17	AD01WIP_DTL_RPT	STAGR	TKA03	STAGR
18	AD01WIP_DTL_RPT	TWAER	TCURC	WAERS	KEY	1	CN
19	AD01WIP_DTL_RPT	VERSN	TKVS	VERSI
20	AD01WIP_DTL_RPT	WERKS	T001W	WERKS		1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in	605