SAP ABAP Table J_3R_SIDATA (Type for transform data during transfer to FI-SL for PBU18)

Hierarchy

☛ SAP_FIN (Software Component) SAP_FIN
   ⤷ FI-LOC (Application Component) Localization
     ⤷ J3RFTAX (Package) Tax Accounting

Basic Data

Table Category	INTTAB	Structure
Structure	J_3R_SIDATA	Table Relationship Diagram
Short Description	Type for transform data during transfer to FI-SL for PBU18

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	.INCLUDE	☐				0	0	G/L user table 1
2	RCLNT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
3	RLDNR	☐	RLDNR	RLDNR	CHAR	2	0	Ledger	T881
4	RRCTY	☐	RRCTY	RRCTY	CHAR	1	0	Record Type
5	RVERS	☐	RVERS	RVERS	CHAR	3	0	Version	T894
6	RYEAR	☐	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
7	RTCUR	☐	RTCUR	WAERS	CUKY	5	0	Currency Key	TCURC
8	RUNIT	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
9	DRCRK	☐	SHKZG	SHKZG	CHAR	1	0	Debit/Credit Indicator
10	RBUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
11	RACCT	☐	RACCT	SAKNR	CHAR	10	0	Account Number	SKB1
12	RBUSA	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
13	RFAREA	☐	FKBER	FKBER	CHAR	16	0	Functional Area	TFKB
14	OCLNT	☐	OCLNT	NUM3	NUMC	3	0	Original client
15	LOGSYS	☐	LOGSYS	LOGSYS	CHAR	10	0	Logical system	TBDLS
16	RMVCT	☐	RMVCT	RMVCT	CHAR	3	0	Transaction type	T856
17	RASSC	☐	RASSC	RCOMP	CHAR	6	0	Company ID of trading partner	T880
18	SBUKRS	☐	PBUKRS	BUKRS	CHAR	4	0	Company code of partner	T001
19	SACCT	☐	PRACCT	SAKNR	CHAR	10	0	Partner account number	*
20	SBUSA	☐	PPARGB	GSBER	CHAR	4	0	Trading Partner Business Area of the Business Partner	TGSB
21	SFAREA	☐	SFKBER	FKBER	CHAR	16	0	Partner Functional Area	TFKB
22	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
23	POPER	☐	POPER	POPER	NUMC	3	0	Posting period
24	DOCCT	☐	DOCCT	DOCCT	CHAR	1	0	Document Type
25	DOCNR	☐	BELNR_D	BELNR	CHAR	10	0	Accounting Document Number
26	DOCLN	☐	DOCLN6	DOCLN6	CHAR	6	0	Six-Character Posting Item for Ledger
27	ACTIV	☐	GLVOR	CHAR4	CHAR	4	0	Business Transaction
28	AWTYP	☐	AWTYP	AWTYP	CHAR	5	0	Reference procedure	TTYP
29	COST_ELEM	☐	KSTAR	KSTAR	CHAR	10	0	Cost Element	CSKB
30	RCNTR	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	CSKS
31	PRCTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center	CEPC
32	KOKRS	☐	KOKRS	CACCD	CHAR	4	0	Controlling Area	TKA01
33	SEGMENT	☐	FB_SEGMENT	FB_SEGMENT	CHAR	10	0	Segment for Segmental Reporting	FAGL_SEGM
34	SCNTR	☐	SKOST	KOSTL	CHAR	10	0	Sender cost center	CSKS
35	PPRCTR	☐	PPRCTR	PRCTR	CHAR	10	0	Partner Profit Center	CEPC
36	PSEGMENT	☐	FB_PSEGMENT	FB_SEGMENT	CHAR	10	0	Partner Segment for Segmental Reporting	FAGL_SEGM
37	RPRCTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center	CEPC
38	RHOART	☐	HOART	HOART	NUMC	2	0	Type of origin object (EC-PCA)
39	HRKFT	☐	HRKFT	HRKFT	CHAR	4	0	Origin Group as Subdivision of Cost Element	*
40	EPRCTR	☐	EPRCTR	PRCTR	CHAR	10	0	Partner profit center for elimination of internal business	CEPC
41	AFABE	☐	AFABE_D	AFABE	NUMC	2	0	Real depreciation area	*
42	SPRCTR	☐	PPRCTR	PRCTR	CHAR	10	0	Partner Profit Center	CEPC
43	SHOART	☐	SHOART	HOART	NUMC	2	0	Type of receiver object
44	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
45	VERSA	☐	VERSN_ABGR	VERSN_ABGR	CHAR	3	0	Results Analysis Version	TKKAP
46	STAGR	☐	STAGR	STAGR	CHAR	6	0	Statistical key figure	TKA03
47	REP_MATNR	☐	REP_MATNR	MATNR	CHAR	18	0	Representative material for Profit Center Accounting	T8A60
48	RSCOPE	☐	SCOPE_CV	SCOPE_CV	CHAR	2	0	Object Class
49	RHRKFT	☐	HRKFT	HRKFT	CHAR	4	0	Origin Group as Subdivision of Cost Element	TKKH1
50	ROBART	☐	COFI_OB_CV	J_OBART_LD	CHAR	2	0	Reconciliation ledger object type (technical)
51	RFUND	☐	BP_GEBER	BP_GEBER	CHAR	10	0	Fund	FMFINCODE
52	RGRANT_NBR	☐	GM_GRANT_RECEIVER	GM_GRANT_NBR	CHAR	20	0	Receiver Grant	GMGR
53	RLOGSYS	☐	LOGSYSO	LOGSYS	CHAR	10	0	Logical system of object	TBDLS
54	SHRKFT	☐	PHRKFT	HRKFT	CHAR	4	0	Origin of partner (subdivision of cost element)	TKKH1
55	SOBART	☐	COFI_PO_CV	J_OBART_LD	CHAR	2	0	Partner object type (for reconciliation ledger)
56	SSCOPE	☐	PSCOPE_CV	SCOPE_CV	CHAR	2	0	Partner object class
57	SFUND	☐	BP_P_GEBER	BP_GEBER	CHAR	10	0	Partner Fund	FMFINCODE
58	SGRANT_NBR	☐	GM_GRANT_SENDER	GM_GRANT_NBR	CHAR	20	0	Sender Grant	GMGR
59	SLOGSYS	☐	LOGSYSP	LOGSYS	CHAR	10	0	Logical system of partner object	TBDLS
60	VRGNG	☐	CO_VORGANG	J_VORGANG	CHAR	4	0	CO Business Transaction	TJ01
61	WRTTP	☐	CO_WRTTP	CO_WRTTP	CHAR	2	0	Value Type
62	RCOMP	☐	RCOMP_D	RCOMP	CHAR	6	0	Company	T880
63	RDIMEN	☐	FC_DIMEN	FC_DIMEN	CHAR	2	0	Dimension	TF150
64	RBUNIT	☐	FC_BUNIT	FC_BUNIT	CHAR	18	0	Consolidation unit	TF160
65	RITCLG	☐	FC_ITCLG	FC_ITCLG	CHAR	2	0	Consolidation chart of accounts	TF120
66	RITEM	☐	FC_ITEM	FC_ITEM	CHAR	10	0	Financial statement item	TF100
67	RBUPTR	☐	FC_BUPTR	FC_BUNIT	CHAR	18	0	Partner unit	TF160
68	RCONGR	☐	FC_CONGR	FC_CONGR	CHAR	18	0	Consolidation group	TF180
69	ROBUKRS	☐	OBUKR	BUKRS	CHAR	4	0	Original company code	T001
70	SITYP	☐	FC_SITYP	FC_SITYP	CHAR	3	0	Subitem category	TF110
71	SUBIT	☐	FC_SITEM	FC_SITEM	CHAR	10	0	Subitem	TF115
72	PLEVL	☐	FC_PLEVL	FC_PLEVL	CHAR	2	0	Posting level
73	RPFLG	☐	FC_RPFLG	FC_RPFLG	NUMC	1	0	Apportionment
74	RTFLG	☐	FC_RTFLG	FC_RTFLG	NUMC	1	0	Currency translation
75	DOCTY	☐	DOCTY	DOCTY	CHAR	2	0	FI-SL Document Type	T889
76	YRACQ	☐	FC_RYACQ	GJAHR	NUMC	4	0	Year of acquisition
77	PRACQ	☐	RPACQ	NUM03	NUMC	3	0	Period of Acquisition
78	COICU	☐	FC_COICU	FC_BUNIT	CHAR	18	0	Investee unit	TF160
79	SEQNR	☐	SQNR	SQNR	NUMC	4	0	Segment number within a cycle	T811S
80	RTYPE	☐	FB_ICRC_RTYPE	FB_ICRC_RTYPE	CHAR	1	0	Record Type
81	RCUST	☐	KUNNR	KUNNR	CHAR	10	0	Customer Number	*
82	RVEND	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	*
83	RLEVL	☐	RLEVL	RLEVL	CHAR	1	0	Posting level
84	RSUBD	☐	RSUBD	RSUBD	CHAR	3	0	Subgroup	T852
85	RYACQ	☐	RYACQ	CJAHR	CHAR	4	0	Year of acquisition
86	RPACQ	☐	RPACQ	NUM03	NUMC	3	0	Period of Acquisition
87	ADFLD1	☐	ADFLD1	ADFLD1	CHAR	10	0	First additional field for user-defined account assignments	T85A
88	ADFLD2	☐	ADFLD2	ADFLD2	CHAR	10	0	Second additional field for user-defined account assignments	T85B
89	ADFLD3	☐	ADFLD3	ADFLD3	CHAR	10	0	Third additional field for user-defined account assignments	T85C
90	SCOMP	☐	SCOMP_D	RCOMP	CHAR	6	0	Company	T880
91	SASSC	☐	SASSC	RCOMP	CHAR	6	0	Company ID of trading partner	T880
92	FIKRS	☐	FIKRS	FIKRS	CHAR	4	0	Financial Management Area	*
93	UMSKZ	☐	UMSKZ	UMSKZ	CHAR	1	0	Special G/L Indicator	*
94	RACVT	☐	LSTAR	LSTAR	CHAR	6	0	Activity Type	*
95	OBUKR	☐	OBUKR	BUKRS	CHAR	4	0	Original company code	T001
96	RSPONSORED_PROG	☐	GM_SPONSORED_PROG	GM_SPONSORED_PROG	CHAR	20	0	Sponsored Program	*
97	RSPONSORED_CLASS	☐	GM_SPONSORED_CLASS	GM_SPONSORED_CLASS	CHAR	20	0	Sponsored Class	*
98	RBDGT_VLDTY_NBR	☐	GM_BDGT_VLDTY_NBR	GM_BDGT_VLDTY_NBR	CHAR	3	0	Budget Validity Number
99	CEFFYEAR_9	☐	GNJHR	GJAHR	NUMC	4	0	Year of Cash Effectivity
100	WFSTATE_9	☐	BUAVC_WFSTATE	BUKU_WFSTATE	CHAR	1	0	Workflow Status of a Record in the AVC Totals Table
101	ALLOCTYPE_9	☐	BUAVC_ALLOCTYPE	BUAVC_ALLOCTYPE	CHAR	4	0	Amount Type (Availability Control)
102	GRANTEE_FY_9	☐	GM_GRANTEE_FY	GJAHR	NUMC	4	0	Fiscal Year of Grantee Organization
103	RPSC_NAME	☐	PSC_NAME	PSC_NAME	CHAR	10	0	PSC Name	*
104	RPSC_PRODUCT	☐	PSC_PRODUCT	PSC_PRODUCT	CHAR	10	0	PSC Product	*
105	RJVNAM	☐	JV_NAME	JV_NAME	CHAR	6	0	Joint venture	T8JV
106	REGROU	☐	JV_EGROUP	JV_EGROUP	CHAR	3	0	Equity group	T8JF
107	RORDNR	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	AUFK
108	RPROJK	☐	PS_PSP_PNR	PS_POSNR	NUMC	8	0	Work Breakdown Structure Element (WBS Element)	PRPS
109	RAUFPL	☐	AUFPL_CH	AUFPL	NUMC	10	0	Task List Number for Operations in Order
110	RAPLZL	☐	APLZL_CH	CO_APLZL	NUMC	8	0	General Counter for Order	*
111	RRECIN	☐	JV_RECIND	JV_RECIND	CHAR	2	0	Recovery Indicator	T8JJ
112	PSC_CALC_TYPE	☐	PSC_CT	PSC_CT	NUMC	3	0	PSC Calculation Type	*
113	PSC_PER_COST	☐	PSC_PER_COST	PSC_PER_COST	CHAR	1	0	PSC Period Costs
114	ANLN1	☐	ANLN1	ANLN1	CHAR	12	0	Main Asset Number	*
115	ANLN2	☐	ANLN2	ANLN2	CHAR	4	0	Asset Subnumber	*
116	ANBWA	☐	ANBWA	BWASL	CHAR	3	0	Asset Transaction Type	*
117	PARTN	☐	JV_PART	KUNNR	CHAR	10	0	Partner account number	*
118	SPSC_NAME	☐	PSC_NAME	PSC_NAME	CHAR	10	0	PSC Name	*
119	SPSC_PRODUCT	☐	PSC_PRODUCT	PSC_PRODUCT	CHAR	10	0	PSC Product	*
120	RKOKRS	☐	KOKRS	CACCD	CHAR	4	0	Controlling Area	TKA01
121	RANLN1	☐	ANLN1	ANLN1	CHAR	12	0	Main Asset Number	ANLH
122	RANLN2	☐	ANLN2	ANLN2	CHAR	4	0	Asset Subnumber	ANLA
123	RANBWA	☐	ANBWA	BWASL	CHAR	3	0	Asset Transaction Type	TABW
124	RPARTN	☐	JV_PART	KUNNR	CHAR	10	0	Partner account number	KNA1
125	NPLNR	☐	NPLNR	AUFNR	CHAR	12	0	Network Number for Account Assignment	AUFK
126	AUFPL	☐	CO_AUFPL	AUFPL	NUMC	10	0	Routing number of operations in the order
127	APLZL	☐	APLZL_CH	CO_APLZL	NUMC	8	0	General Counter for Order	*
128	VORNR	☐	VORNR	VORNR	CHAR	4	0	Operation/Activity Number
129	RBILID	☐	JV_BILIND	JV_BILIND	CHAR	2	0	Payroll Type	T8JA
130	RDPOM	☐	JV_DPOM	CHAR4	CHAR	4	0	Posting Period Difference for Operational Month
131	RDBILLM	☐	JV_DBILLM	CHAR4	CHAR	4	0	Invoice Month: Posting Period Difference
132	REFDOCNR	☐	REFBELNR	BELNR	CHAR	10	0	Reference document number of an accounting document
133	REFRYEAR	☐	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
134	REFDOCLN	☐	BUZEI6	BUZEI6	NUMC	6	0	Six-figure number of line item
135	REFDOCCT	☐	DOCCT	DOCCT	CHAR	1	0	Document Type
136	BELNR	☐	BELNR_D	BELNR	CHAR	10	0	Accounting Document Number
137	GJAHR	☐	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
138	BUZEI	☐	BUZEI	BUZEI	NUMC	3	0	Number of Line Item Within Accounting Document
139	CSPRED	☐	CSPRED	SPRED	CHAR	4	0	Distribution key for currency amounts	T821S
140	QSPRED	☐	QSPRED	SPRED	CHAR	4	0	Distribution key for quantities	T821S
141	CPUDT	☐	CPUDT	DATUM	DATS	8	0	Accounting document entry date
142	CPUTM	☐	CPUTM	UZEIT	TIMS	6	0	Time of data entry
143	USNAM	☐	USNAM	XUBNAME	CHAR	12	0	User name	USR02
144	TSL	☐	VTCUR12	WERTV12	CURR	23	2	Value in Transaction Currency
145	HSL	☐	VLCUR12	WERTV12	CURR	23	2	Value in Local Currency
146	KSL	☐	VGCUR12	WERTV12	CURR	23	2	Value in Group Currency
147	AUNIT	☐	AUNIT	MEINS	UNIT	3	0	Additional unit of measure	T006
148	SGTXT	☐	SGTXT	TEXT50	CHAR	50	0	Item Text
149	AUTOM	☐	AUTOM	TEXT1	CHAR	1	0	Indicator: Automatic posting lines
150	BVORG	☐	BVORG	BVORG	CHAR	16	0	Number of Cross-Company Code Posting Transaction
151	REFACTIV	☐	GLVOR	CHAR4	CHAR	4	0	Business Transaction
152	AWORG	☐	AWORG	AWORG	CHAR	10	0	Reference organisational units
153	OSL	☐	VOCUR12	WERTV12	CURR	23	2	Value in Another Currency
154	MSL	☐	QUAN1_12	MENGV12	QUAN	23	3	Quantity
155	WSL	☐	VWCUR12	WERTV12	CURR	23	2	Value in Original Transaction Currency (Document Currency)
156	RWCUR	☐	RWCUR	WAERS	CUKY	5	0	Currency key of the original transaction currency	TCURC
157	BUDAT	☐	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
158	BSCHL	☐	BSCHL	BSCHL	CHAR	2	0	Posting Key	TBSL
159	BSTAT	☐	BSTAT_D	BSTAT	CHAR	1	0	Document Status
160	LINETYPE	☐	LINETYPE	LINETYPE	CHAR	5	0	Item category	T8G02
161	XSPLITMOD	☐	XSPLITMOD	XFELD	CHAR	1	0	Item changed by document splitting
162	TIMESTAMP	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
163	BLDAT	☐	BLDAT	DATUM	DATS	8	0	Document Date in Document
164	WSDAT	☐	WSDAT	DATUM	DATS	8	0	Value Date for Currency Translation
165	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
166	KOSTL	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	CSKS
167	LSTAR	☐	LSTAR	LSTAR	CHAR	6	0	Activity Type	CSLA
168	AUFNR	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	AUFK
169	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
170	BWKEY	☐	BWKEY	BWKEY	CHAR	4	0	Valuation area	*
171	BWTAR	☐	BWTAR_D	BWTAR	CHAR	10	0	Valuation type	*
172	KUNNR	☐	KUNNR	KUNNR	CHAR	10	0	Customer Number	*
173	LIFNR	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	*
174	EBELN	☐	EBELN	EBELN	CHAR	10	0	Purchasing Document Number	EKKO
175	EBELP	☐	EBELP	EBELP	NUMC	5	0	Item Number of Purchasing Document	EKPO
176	KSTRG	☐	KSTRG	KSTRG	CHAR	12	0	Cost Object	*
177	ERKRS	☐	ERKRS	ERKRS	CHAR	4	0	Operating concern	*
178	PAOBJNR	☐	RKEOBJNR	RKEOBJNR	NUMC	10	0	Profitability Segment Number (CO-PA)
179	PASUBNR	☐	RKESUBNR	RKESUBNR	NUMC	4	0	Profitability Segment Changes (CO-PA)
180	PS_PSP_PNR	☐	PS_PSP_PNR	PS_POSNR	NUMC	8	0	Work Breakdown Structure Element (WBS Element)	*
181	KDAUF	☐	KDAUF	VBELN	CHAR	10	0	Sales Order Number	*
182	KDPOS	☐	KDPOS	NUM06	NUMC	6	0	Item number in Sales Order
183	FKART	☐	FKART	FKART	CHAR	4	0	Billing Type	*
184	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	*
185	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	*
186	AUBEL	☐	VBELN_VA	VBELN	CHAR	10	0	Sales Document	*
187	AUPOS	☐	POSNR_VA	POSNR	NUMC	6	0	Sales Document Item	*
188	SPART	☐	SPART	SPART	CHAR	2	0	Division	*
189	VBELN	☐	VBELN	VBELN	CHAR	10	0	Sales and Distribution Document Number	*
190	POSNR	☐	POSNR	POSNR	NUMC	6	0	Item number of the SD document	*
191	VKGRP	☐	VKGRP	VKGRP	CHAR	3	0	Sales group	*
192	VKBUR	☐	VKBUR	VKBUR	CHAR	4	0	Sales office	*
193	VBUND	☐	RASSC	RCOMP	CHAR	6	0	Company ID of trading partner	*
194	ALEBN	☐	PCA_ALEBN	BELNR	CHAR	10	0	ALE: PCA document number in system where created
195	AWSYS	☐	AWSYS	LOGSYS	CHAR	10	0	Logical system of source document	*
196	STFLG	☐	CO_STFLG	FLAG	CHAR	1	0	Identifier for reversal document
197	STOKZ	☐	CO_STOKZ	FLAG	CHAR	1	0	Indicator: Document Has Been Reversed
198	GRTYP	☐	GRTYP	GRTYP	CHAR	1	0	Statistical Key Figure Category
199	CO_PRZNR	☐	CO_PRZNR	CO_PRZNR	CHAR	12	0	Business Process	CBPR
200	IMKEY	☐	IMKEY	IMKEY	CHAR	8	0	Internal Key for Real Estate Object
201	DABRZ	☐	DABRBEZ	DDAT	DATS	8	0	Reference date for settlement
202	VALUT	☐	VALUT	DATUM	DATS	8	0	Fixed Value Date
203	AWREF_REV	☐	AWREF_REV	AWREF	CHAR	10	0	Reversal: Reverse Document Reference Document Number
204	AWORG_REV	☐	AWORG_REV	AWORG	CHAR	10	0	Reversal: Reverse Document Reference Organization
205	BWART	☐	BWART	BWART	CHAR	3	0	Movement type (inventory management)	*
206	BLART	☐	BLART	BLART	CHAR	2	0	Document type	*
207	ACCOUNT	☐	RACCT_RCL	SAKNR	CHAR	10	0	Reconciliation Account for Reconciliation Posting	SKB1
208	VAL_REFDOCLN	☐	VAL_REFDOCLN	DOCLN	CHAR	3	0	Posting Row in Operative Version
209	DISTKEY	☐	FM_DISTKEY	FM_DISTKEY	CHAR	4	0	Distribution keys
210	RFISTL	☐	FISTL	FISTL	CHAR	16	0	Funds Center	*
211	RFONDS	☐	BP_GEBER	BP_GEBER	CHAR	10	0	Fund	*
212	RFIPEX	☐	FM_FIPEX	FM_FIPEX	CHAR	24	0	Commitment item	*
213	UPDHP	☐	UPDHP	POPER	NUMC	3	0	Highest update period
214	RVSDOCNR	☐	STBLG	BELNR	CHAR	10	0	Reverse Document Number
215	ORNDOCNR	☐	STBLN	BELNR	CHAR	10	0	Document number of reversed document
216	COIAC	☐	FC_COIAC	FC_COIAC	CHAR	2	0	Activity for consolidation of investments
217	COINR	☐	FC_COINR	BELNR	CHAR	10	0	Consolidation of investments activity number
218	REVYEAR	☐	FC_REVYEAR	GJAHR	NUMC	4	0	Year of reversal document or reversed document
219	DOCDT	☐	BLDAT	DATUM	DATS	8	0	Document Date in Document
220	REFNR	☐	FB_ICRC_REFNR	CHAR30LOW	CHAR	30	0	Reference Number
221	GRREF	☐	FB_ICRC_GROUPREF	FB_ICRC_GROUPREF	CHAR	18	0	Document Group Number
222	PSTAT	☐	FB_ICRC_PSTAT	NUMC3	NUMC	3	0	Processing Status
223	CSTAT	☐	FB_ICRC_CSTAT	NUMC3	NUMC	3	0	Communication Status
224	OSIRID	☐	GU_RECID	OBJNR	CHAR	18	0	Record number of the line item record
225	FAGL_RCLNT	☐	MANDT	MANDT	CLNT	3	0	Client	*
226	FAGL_RYEAR	☐	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
227	FAGL_DOCNR	☐	BELNR_D	BELNR	CHAR	10	0	Accounting Document Number
228	FAGL_RLDNR	☐	RLDNR	RLDNR	CHAR	2	0	Ledger	*
229	FAGL_RBUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	*
230	FAGL_DOCLN	☐	DOCLN6	DOCLN6	CHAR	6	0	Six-Character Posting Item for Ledger
231	ASL	☐	QUAN2_12	MENGV12	QUAN	23	3	Additional Quantity
232	ULDNR	☐	ULDNR	RLDNR	CHAR	2	0	Original ledger	T881
233	URCTY	☐	URCTY	RRCTY	CHAR	1	0	Original record type
234	UVERS	☐	UUVERS	RVERS	CHAR	3	0	Original version	*
235	UDRCRK	☐	USHKZG	SHKZG	CHAR	1	0	Original debit/credit indicator
236	UBUKRS	☐	UBUKRS	BUKRS	CHAR	4	0	Original company code	T001
237	UACCT	☐	UACCT	SAKNR	CHAR	10	0	Original account number	*
238	UBUSA	☐	UGSBER	GSBER	CHAR	4	0	Original business area	TGSB
239	UFAREA	☐	UFKBER	FKBER	CHAR	16	0	Source Functional Area	TFKB
240	REFFIDLN	☐	BUZEI	BUZEI	NUMC	3	0	Number of Line Item Within Accounting Document
241	BILID	☐	JV_BILIND	JV_BILIND	CHAR	2	0	Payroll Type	T8JA
242	ORECID	☐	JV_ORECID	JV_RECIND	CHAR	2	0	Original Recovery Indicator	T8JJ
243	MWSKZ	☐	MWSKZ	MWSKZ	CHAR	2	0	Tax on sales/purchases code	T007A
244	BILLM	☐	JV_BILLM	DATUM	DATS	8	0	Billing Month
245	POM	☐	JV_POM	DATUM	DATS	8	0	Processing operational month
246	CBPERIOD	☐	JV_CBPERI	POPER	NUMC	3	0	JV Cutback Period
247	KTOSL	☐	KTOSL	CHAR3	CHAR	3	0	Transaction Key
248	MMACT	☐	JV_MM_ACT	JV_MM_ACT	CHAR	1	0	JVA MM Activity Type
249	CYCLE	☐	CYCLE	CYCLE	CHAR	10	0	Allocation/cycle
250	SDATE	☐	SDATE	SDATE	DATS	8	0	Start Date	*
251	SEQNAME	☐	SEQNAME	SEQNAME	CHAR	10	0	Name of a segment in assessment/distribution
252	REFCYC	☐	JV_REFCYC	TEXT10	CHAR	10	0	Reference Field for Allocation Cycle
253	CONDI	☐	JV_CONDCOD	JV_CONDCOD	CHAR	2	0	Joint Venture Indicator (Condition Key)	T8JX
254	REFAWTYP	☐	AWTYP	AWTYP	CHAR	5	0	Reference procedure	TTYP
255	REFAWREF	☐	AWREF	AWREF	CHAR	10	0	Reference document number
256	REFAWORG	☐	AWORG	AWORG	CHAR	10	0	Reference organisational units
257	REFLOGSYS	☐	LOGSYS	LOGSYS	CHAR	10	0	Logical system	TBDLS
258	PRODPER	☐	JV_PRODPER	JV_PRODPER	DATS	8	0	Production Month (Date to find period and year)
259	REFFIDOC	☐	BELNR_D	BELNR	CHAR	10	0	Accounting Document Number
260	CBCUSTOMER	☐	KUNNR	KUNNR	CHAR	10	0	Customer Number	*
261	CBVENDOR	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	*
262	CBPAYTERM	☐	DZTERM	ZTERM	CHAR	4	0	Terms of payment key
263	XSBL	☐	JV_XSBLINE	XFELD	CHAR	1	0	Flag: Line is Split Basis Line
264	SBREFLN	☐	JV_SBREFLN	JV_SBREFLN	NUMC	5	0	Reference Split Basis Line Number
265	LCURR	☐	CURR1	WAERS	CUKY	5	0	Currency key of currency 2	TCURC
266	GCURR	☐	CURR2	WAERS	CUKY	5	0	Currency key of currency 3	TCURC
267	OCURR	☐	CURR3	WAERS	CUKY	5	0	Currency key of currency 4	TCURC
268	JVA_KSL	☐	VGCUR	WERTV8	CURR	15	2	Value in group currency
269	JVA_KSL1	☐	VGCUR	WERTV8	CURR	15	2	Value in group currency
270	JVA_CURR	☐	GCURR	WAERS	CUKY	5	0	Currency key of the ledger currency	TCURC
271	JVA_CURR1	☐	GCURR	WAERS	CUKY	5	0	Currency key of the ledger currency	TCURC
272	TYPE	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
273	GLX_BUDAT	☐	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
274	GLX_WUDAT	☐	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
275	KEY_FLAG	☐			DEC	2	0
276	DATA_FLAG	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
277	UNIT_TEXT	☐	MSEHT	TEXT10	CHAR	10	0	Unit of Measurement Text (Maximum 10 Characters)
278	AUNIT_TEXT	☐	MSEHT	TEXT10	CHAR	10	0	Unit of Measurement Text (Maximum 10 Characters)
279	XDIALOG	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	J_3R_SIDATA	ACCOUNT	SKB1	SAKNR
2	J_3R_SIDATA	ADFLD1	T85A	ADFLD1
3	J_3R_SIDATA	ADFLD2	T85B	ADFLD2
4	J_3R_SIDATA	ADFLD3	T85C	ADFLD3
5	J_3R_SIDATA	AUFNR	AUFK	AUFNR
6	J_3R_SIDATA	AUNIT	T006	MSEHI
7	J_3R_SIDATA	AWTYP	TTYP	AWTYP
8	J_3R_SIDATA	BILID	T8JA	BILIND
9	J_3R_SIDATA	BSCHL	TBSL	BSCHL
10	J_3R_SIDATA	BUKRS	T001	BUKRS
11	J_3R_SIDATA	COICU	TF160	BUNIT
12	J_3R_SIDATA	CONDI	T8JX	CONDCODE
13	J_3R_SIDATA	COST_ELEM	CSKB	KSTAR
14	J_3R_SIDATA	CO_PRZNR	CBPR	PRZNR			CN
15	J_3R_SIDATA	CSPRED	T821S	SPRED
16	J_3R_SIDATA	DOCTY	T889	DOCTY
17	J_3R_SIDATA	EBELN	EKKO	EBELN
18	J_3R_SIDATA	EBELP	EKPO	EBELP
19	J_3R_SIDATA	EPRCTR	CEPC	PRCTR			CN
20	J_3R_SIDATA	GCURR	TCURC	WAERS
21	J_3R_SIDATA	GSBER	TGSB	GSBER
22	J_3R_SIDATA	JVA_CURR	TCURC	WAERS
23	J_3R_SIDATA	JVA_CURR1	TCURC	WAERS
24	J_3R_SIDATA	KOKRS	TKA01	KOKRS
25	J_3R_SIDATA	KOSTL	CSKS	KOSTL			CN
26	J_3R_SIDATA	LCURR	TCURC	WAERS
27	J_3R_SIDATA	LINETYPE	T8G02	LINETYPE
28	J_3R_SIDATA	LOGSYS	TBDLS	LOGSYS
29	J_3R_SIDATA	LSTAR	CSLA	LSTAR			CN
30	J_3R_SIDATA	MATNR	MARA	MATNR
31	J_3R_SIDATA	MWSKZ	T007A	MWSKZ			CN
32	J_3R_SIDATA	NPLNR	AUFK	AUFNR
33	J_3R_SIDATA	OBUKR	T001	BUKRS
34	J_3R_SIDATA	OCURR	TCURC	WAERS
35	J_3R_SIDATA	ORECID	T8JJ	RECID
36	J_3R_SIDATA	PPRCTR	CEPC	PRCTR
37	J_3R_SIDATA	PRCTR	CEPC	PRCTR
38	J_3R_SIDATA	PSEGMENT	FAGL_SEGM	SEGMENT
39	J_3R_SIDATA	QSPRED	T821S	SPRED
40	J_3R_SIDATA	RACCT	SKB1	SAKNR
41	J_3R_SIDATA	RANBWA	TABW	BWASL
42	J_3R_SIDATA	RANLN1	ANLH	ANLN1
43	J_3R_SIDATA	RANLN2	ANLA	ANLN2
44	J_3R_SIDATA	RASSC	T880	RCOMP
45	J_3R_SIDATA	RBILID	T8JA	BILIND
46	J_3R_SIDATA	RBUKRS	T001	BUKRS
47	J_3R_SIDATA	RBUNIT	TF160	BUNIT
48	J_3R_SIDATA	RBUPTR	TF160	BUNIT
49	J_3R_SIDATA	RBUSA	TGSB	GSBER
50	J_3R_SIDATA	RCLNT	T000	MANDT
51	J_3R_SIDATA	RCNTR	CSKS	KOSTL			CN
52	J_3R_SIDATA	RCOMP	T880	RCOMP
53	J_3R_SIDATA	RCONGR	TF180	CONGR
54	J_3R_SIDATA	RDIMEN	TF150	DIMEN
55	J_3R_SIDATA	REFAWTYP	TTYP	AWTYP
56	J_3R_SIDATA	REFLOGSYS	TBDLS	LOGSYS
57	J_3R_SIDATA	REGROU	T8JF	EGRUP
58	J_3R_SIDATA	REP_MATNR	T8A60	REP_MATNR
59	J_3R_SIDATA	RFAREA	TFKB	FKBER
60	J_3R_SIDATA	RFUND	FMFINCODE	FINCODE
61	J_3R_SIDATA	RGRANT_NBR	GMGR	GRANT_NBR
62	J_3R_SIDATA	RHRKFT	TKKH1	HRKFT
63	J_3R_SIDATA	RITCLG	TF120	ITCLG
64	J_3R_SIDATA	RITEM	TF100	ITEM
65	J_3R_SIDATA	RJVNAM	T8JV	VNAME
66	J_3R_SIDATA	RKOKRS	TKA01	KOKRS
67	J_3R_SIDATA	RLDNR	T881	RLDNR
68	J_3R_SIDATA	RLOGSYS	TBDLS	LOGSYS
69	J_3R_SIDATA	RMVCT	T856	TRTYP
70	J_3R_SIDATA	ROBUKRS	T001	BUKRS
71	J_3R_SIDATA	RORDNR	AUFK	AUFNR
72	J_3R_SIDATA	RPARTN	KNA1	KUNNR
73	J_3R_SIDATA	RPRCTR	CEPC	PRCTR			CN
74	J_3R_SIDATA	RPROJK	PRPS	PSPNR
75	J_3R_SIDATA	RRECIN	T8JJ	RECID
76	J_3R_SIDATA	RSUBD	T852	RSUBD
77	J_3R_SIDATA	RTCUR	TCURC	WAERS
78	J_3R_SIDATA	RUNIT	T006	MSEHI
79	J_3R_SIDATA	RVERS	T894	RVERS
80	J_3R_SIDATA	RWCUR	TCURC	WAERS
81	J_3R_SIDATA	SASSC	T880	RCOMP
82	J_3R_SIDATA	SBUKRS	T001	BUKRS
83	J_3R_SIDATA	SBUSA	TGSB	GSBER
84	J_3R_SIDATA	SCNTR	CSKS	KOSTL
85	J_3R_SIDATA	SCOMP	T880	RCOMP
86	J_3R_SIDATA	SEGMENT	FAGL_SEGM	SEGMENT
87	J_3R_SIDATA	SEQNR	T811S	SEQNR			CN
88	J_3R_SIDATA	SFAREA	TFKB	FKBER
89	J_3R_SIDATA	SFUND	FMFINCODE	FINCODE
90	J_3R_SIDATA	SGRANT_NBR	GMGR	GRANT_NBR
91	J_3R_SIDATA	SHRKFT	TKKH1	HRKFT
92	J_3R_SIDATA	SITYP	TF110	SITYP
93	J_3R_SIDATA	SLOGSYS	TBDLS	LOGSYS
94	J_3R_SIDATA	SPRCTR	CEPC	PRCTR			CN
95	J_3R_SIDATA	STAGR	TKA03	STAGR
96	J_3R_SIDATA	SUBIT	TF115	SITEM
97	J_3R_SIDATA	UBUKRS	T001	BUKRS
98	J_3R_SIDATA	UBUSA	TGSB	GSBER
99	J_3R_SIDATA	UFAREA	TFKB	FKBER
100	J_3R_SIDATA	ULDNR	T881	RLDNR
101	J_3R_SIDATA	USNAM	USR02	BNAME
102	J_3R_SIDATA	VERSA	TKKAP	VERSA
103	J_3R_SIDATA	VRGNG	TJ01	VRGNG
104	J_3R_SIDATA	WERKS	T001W	WERKS

History

Last changed by/on	SAP	20150220
SAP Release Created in