SAP ABAP Table V_VIITTAXDOC_DS (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	V_VIITTAXDOC_DS	Table Relationship Diagram
Short Description	Generated Table for View

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	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client
2	DOCGUID	☑	REITDOCGUID	RECAGUID	RAW	16	0	GUID: Unique Internal Key for Tax Document
3	ITEMNO	☑	REITITEMNO	POSNR_ACC	NUMC	10	0	Internal Item Number for Tax Document Item
4	REFDOCTYPE	☑	RERAREFDOCTYPE	AWTYP	CHAR	5	0	Reference to Document Class
5	REFDOCID	☑	RERAREFDOCID	CHAR20	CHAR	20	0	Reference Key of Document
6	REFITEMNO	☑	POSNR_ACC	POSNR_ACC	NUMC	10	0	Accounting Document Line Item Number
7	ACCSYSTEM	☑	RERAACCSYSTEM	RERAACCSYSTEM	CHAR	4	0	Definition of Accounting System	TIVRAACCSYSTEM
8	LOGSYSTEM	☑	LOGSYSTEM	LOGSYS	CHAR	10	0	Logical System
9	REVDOCID	☑	RERAREVDOCID	CHAR20	CHAR	20	0	Reference Key of Reversal Document
10	STATUS	☑	REITDSSTATUS	REITDSSTATUS	CHAR	1	0	Tax Breakdown Status
11	FISCALYEAR	☑	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
12	PSTNGPERIOD	☑	RERAPSTNGPERIOD	RERAFISCALPERIOD	NUMC	2	0	Posting Period
13	PSTNGDATE	☑	RERAPSTNGDATE	RECADATE	DATS	8	0	Posting Date
14	BUKRS	☑	BUKRS	BUKRS	CHAR	4	0	Company Code
15	OBJNR	☑	REITOBJNR	J_OBJNR	CHAR	22	0	ID of Object for which Option Rate Was Determined
16	REFDATE	☑	DABRBEZ	DDAT	DATS	8	0	Reference date for settlement
17	DCINDICATOR	☑	RERADCINDICATOR	RERADCINDICATOR	CHAR	1	0	Debit/Credit Indicator
18	COSTACCOUNT	☑	REITCOSTACCOUNT	REITEXTGLACCOUNT	CHAR	15	0	Cost Account in G/L Accounting
19	TAXTYPE	☑	RERATAXTYPE	RERATAXTYPE	CHAR	4	0	Tax Type
20	TAXGROUP	☑	RERATAXGROUP	RERATAXGROUP	CHAR	20	0	Tax Group	TIVRATAXGROUP
21	TAXACCOUNT	☑	REITTAXACCOUNT	REITEXTGLACCOUNT	CHAR	15	0	Tax Account of General Ledger Accounting
22	OBJNROPTRATE	☑	REITOBJNROPTRATE	J_OBJNR	CHAR	22	0	ID of Object from Which the Option Rate Was Read
23	NETAMOUNT	☑	RERANETAMOUNT	RECACURR	CURR	15	2	Net Amount in Transaction Currency
24	TAXAMOUNT	☑	RERATAXAMOUNT	RECACURR	CURR	15	2	Tax Amount in Transaction Currency
25	DEDTAXAMT	☑	RERADEDTAXAMT	RECACURR	CURR	15	2	Deductible Tax Amount
26	NONDEDTAXAMT	☑	RERANONDEDTAXAMT	RECACURR	CURR	15	2	Non-Deductible Tax Amount
27	CURRENCY	☑	WAERS	WAERS	CUKY	5	0	Currency Key
28	TCOBJNR	☑	RECAOBJNR	J_OBJNR	CHAR	22	0	Object Number
29	DATEOFSERVICE	☑	REITTCDATEOFSERVICE	RECADATE	DATS	8	0	Date of Service
30	HASDIFFOPTRATE	☑	REITHASDIFFOPTRATE	RECABOOL	CHAR	1	0	Has Differing Option Rate
31	DIFFOPTRATE	☑	REITDIFFOPTRATE	REITOPTRATE	DEC	9	6	Differing Option Rate for Distribution
32	NOTAXCORR	☑	REITNOTAXCORR	RECABOOL	CHAR	1	0	Do Not Consider Item in Input Tax Correction
33	AMTRANSTYPE	☑	REITAMTRANSTYPE	BWASL	CHAR	3	0	Transaction Type of Asset Postings
34	POREFDOCID	☑	REEXPOREFDOCID	CHAR20	CHAR	20	0	Reference Document Number of Purchase Order
35	POREFITEMNO	☑	REEXPOREFITEMNO	POSNR_ACC	NUMC	10	0	Number of Purchase Order Item
36	TCBASEGUID	☑	REITTCBASEGUID	RECAGUID	RAW	16	0	GUID for Basis for Input Tax Correction
37	EXTTAXCODE	☑	RERATAXCODE		CHAR	5	0	Tax Code of the Accounting System
38	ITEMGUID	☑	REITITEMGUID	RECAGUID	RAW	16	0	GUID: Unique Key for Tax Breakdown Item
39	VERSION	☑	REITDSVERSION	POSNR_ACC	NUMC	10	0	Internal Version Number for Tax Breakdown Item
40	OPTRATE	☑	POPTSATZ	POPTSATZ	DEC	9	6	Real Estate Option Rate
41	OPTMETH	☑	REITOPTMETH	REITOPTMETH	CHAR	4	0	Method for Option Rate Determination	TIVITOPTMETH
42	DIFFNONDEDTAXAMT	☑	REITDIFFNONDEDTAXAMT	RECACURR	CURR	15	2	Non-Deductible Tax Amount Difference
43	DIFFDEDTAXAMT	☑	REITDIFFDEDTAXAMT	RECACURR	CURR	15	2	Deductible Tax Amount Difference
44	NONDEDACCOUNT	☑	REITNONDEDACCOUNT	REITEXTGLACCOUNT	CHAR	15	0	Account for Non-Deductible Tax
45	PROCESS	☑	RECAPROCESS	RECAPROCESS	CHAR	4	0	Process	TIVCAPROCESS
46	PROCESSGUID	☑	RECAPROCESSGUID	RECAGUID	RAW	16	0	Generic Key of Process
47	REFDOCGUID	☑	RERAREFGUID	RECAGUID	RAW	16	0	Reference GUID
48	WAERSITEM	☑	WAERS	WAERS	CUKY	5	0	Currency Key
49	PSTNGPROCEDURE	☑	RERAPROCEDURE	RERAPROCEDURE	CHAR	4	0	Posting Procedure	TIVRAPROCEDURE
50	PROCESSID	☑	RECAPROCESSID	RECAPROCESSID	CHAR	16	0	Process Identification -> Accounting Reference Number
51	FISC_YEAR	☑	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
52	DOCDATE	☑	RERADOCDATE	RECADATE	DATS	8	0	Document Date
53	ACCSYSTYPE	☑	RERAACCSYSTYPE	RERAACCSYSTYPE	CHAR	4	0	Type of Accounting System
54	REVID	☑	RERAREVID	RERAREVID	CHAR	1	0	Indicator for Reversed Documents
55	REVDOCGUID	☑	RERAREVDOCGUID	RECAGUID	RAW	16	0	GUID: Internal Key for Accompanying Reversal Document
56	TAXID	☑	RERATAXID	CHAR1	CHAR	1	0	Tax Exists
57	HASGLACCSYMB	☑	RERAHASGLACCSYMB	RECABOOL	CHAR	1	0	Indicator: Account Symbol
58	REFERENCEDOCGUID	☑	RERAREFGUID	RECAGUID	RAW	16	0	Reference GUID
59	RERF	☑	RERF	SYCHAR12	CHAR	12	0	Entered by
60	DERF	☑	DERF	DATUM	DATS	8	0	First Entered on
61	TERF	☑	TERF	TIMES	TIMS	6	0	Time of Initial Entry
62	REHER	☑	REHER	CHAR10	CHAR	10	0	Source of initial entry
63	RBEAR	☑	RBEAR	SYCHAR12	CHAR	12	0	Employee ID
64	DBEAR	☑	DBEAR	DATUM	DATS	8	0	Last Edited on
65	TBEAR	☑	TBEAR	TIMES	TIMS	6	0	Last Edited at
66	RBHER	☑	RBHER	CHAR10	CHAR	10	0	Editing Source
67	FDELETE	☑	RECAARDELETEIND	RECABOOL	CHAR	1	0	Deletion Indicator for Archiving
68	CTRULE	☑	RECACTRULE	RECACTRULE	CHAR	20	0	Currency Translation Rule
69	CTRATE	☑	RECACTRATE	KURSF	DEC	9	5	Exchange Rate
70	POSTCDCURR	☑	RECACTPOSTCDCURR	RECABOOL	CHAR	1	0	Post in Condition Currency
71	CTDATEREQ	☑	RECACTDATEREQ	DATS	DATS	8	0	Planned Translation Date
72	CTDATEACT	☑	RECACTDATEACT	DATS	DATS	8	0	Actual Translation Date
73	CTFCCURRKEY	☑	RECACTFCCURRKEY	WAERS	CUKY	5	0	Foreign Currency
74	PROCESSVIRADOC	☑	RECAPROCESS	RECAPROCESS	CHAR	4	0	Process	TIVCAPROCESS
75	BELNR	☑	BELNR_D	BELNR	CHAR	10	0	Accounting Document Number
76	GJAHR	☑	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
77	BLART	☐	BLART	BLART	CHAR	2	0	Document type	T003
78	BLDAT	☐	BLDAT	DATUM	DATS	8	0	Document Date in Document
79	BUDAT	☐	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
80	MONAT	☐	MONAT	MONAT	NUMC	2	0	Fiscal period
81	CPUDT	☐	CPUDT	DATUM	DATS	8	0	Accounting document entry date
82	CPUTM	☐	CPUTM	UZEIT	TIMS	6	0	Time of data entry
83	AEDAT	☐	AEDAT_BKPF	DATUM	DATS	8	0	Date of the Last Document Change by Transaction
84	UPDDT	☐	UPDDT	DATUM	DATS	8	0	Date of the Last Document Update
85	WWERT	☐	WWERT_D	DATUM	DATS	8	0	Translation date
86	USNAM	☐	USNAM	XUBNAME	CHAR	12	0	User name
87	TCODE	☐	TCODE	TCODE	CHAR	20	0	Transaction Code
88	BVORG	☐	BVORG	BVORG	CHAR	16	0	Number of Cross-Company Code Posting Transaction
89	XBLNR	☐	XBLNR1	XBLNR1	CHAR	16	0	Reference Document Number
90	DBBLG	☐	DBBLG	BELNR	CHAR	10	0	Recurring Entry Document Number
91	STBLG	☐	STBLG	BELNR	CHAR	10	0	Reverse Document Number
92	STJAH	☐	STJAH	GJAHR	NUMC	4	0	Reverse document fiscal year
93	BKTXT	☐	BKTXT	TEXT25	CHAR	25	0	Document Header Text
94	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
95	KURSF	☐	KURSF	KURSF	DEC	9	5	Exchange rate
96	KZWRS	☐	KZWRS	WAERS	CUKY	5	0	Currency Key for the Group Currency	TCURC
97	KZKRS	☐	KZKRS	KURSF	DEC	9	5	Group Currency Exchange Rate
98	BSTAT	☐	BSTAT_D	BSTAT	CHAR	1	0	Document Status
99	XNETB	☐	XNETB	XFELD	CHAR	1	0	Indicator: Document posted net ?
100	FRATH	☐	FRATH	WERT7	CURR	13	2	Unplanned Delivery Costs
101	XRUEB	☐	XRUEB	XFELD	CHAR	1	0	Indicator: Document is posted to a previous period
102	GLVOR	☐	GLVOR	CHAR4	CHAR	4	0	Business Transaction
103	GRPID	☐	GRPID_BKPF	CHAR12	CHAR	12	0	Batch Input Session Name
104	DOKID	☐	DOKID_BKPF	CHAR40	CHAR	40	0	Document Name in the Archive System
105	ARCID	☐	EXTID_BKPF	CHAR10	CHAR	10	0	Extract ID Document Header
106	IBLAR	☐	IBLAR	IBLAR	CHAR	2	0	Internal Document Type for Document Control
107	AWTYP	☐	AWTYP	AWTYP	CHAR	5	0	Reference procedure
108	AWKEY	☐	AWKEY	AWKEY	CHAR	20	0	Object key
109	FIKRS	☐	FIKRS	FIKRS	CHAR	4	0	Financial Management Area
110	HWAER	☐	HWAER	WAERS	CUKY	5	0	Local Currency
111	HWAE2	☐	HWAE2	WAERS	CUKY	5	0	Currency Key of Second Local Currency
112	HWAE3	☐	HWAE3	WAERS	CUKY	5	0	Currency Key of Third Local Currency
113	KURS2	☐	KURS2	KURSF	DEC	9	5	Exchange Rate for the Second Local Currency
114	KURS3	☐	KURS3	KURSF	DEC	9	5	Exchange Rate for the Third Local Currency
115	BASW2	☐	CURSR	CURSR	CHAR	1	0	Source Currency for Currency Translation
116	BASW3	☐	CURSR	CURSR	CHAR	1	0	Source Currency for Currency Translation
117	UMRD2	☐	UMRD2	CURDT	CHAR	1	0	Translation Date Type for Second Local Currency
118	UMRD3	☐	UMRD3	CURDT	CHAR	1	0	Translation Date Type for Third Local Currency
119	XSTOV	☐	XSTOV	XFELD	CHAR	1	0	Indicator: Document is flagged for reversal
120	STODT	☐	STODT	DATUM	DATS	8	0	Planned Date for the Reverse Posting
121	XMWST	☐	XMWST	XFELD	CHAR	1	0	Calculate tax automatically
122	CURT2	☐	CURT2	CURTP	CHAR	2	0	Currency Type of Second Local Currency
123	CURT3	☐	CURT3	CURTP	CHAR	2	0	Currency Type of Third Local Currency
124	KUTY2	☐	KURST	KURST	CHAR	4	0	Exchange Rate Type	TCURV
125	KUTY3	☐	KURST	KURST	CHAR	4	0	Exchange Rate Type	TCURV
126	XSNET	☐	XSNET	XFELD	CHAR	1	0	G/L account amounts entered exclude tax
127	AUSBK	☐	AUSBK	BUKRS	CHAR	4	0	Source Company Code	T001
128	XUSVR	☐	XUSVR_BKPF	XFELD	CHAR	1	0	Indicator: US taxes changed at detail level ?
129	DUEFL	☐	DUEFL_BKPF	DUEFL_BKPF	CHAR	1	0	Status of Data Transfer into Subsequent Release
130	AWSYS	☐	LOGSYSTEM	LOGSYS	CHAR	10	0	Logical System
131	TXKRS	☐	TXKRS_BKPF	KURSF	DEC	9	5	Exchange Rate for Taxes
132	LOTKZ	☐	PSO_LOTKZ	LOTKZ	CHAR	10	0	Lot Number for Requests
133	XWVOF	☐	XWVOF	XFELD	CHAR	1	0	Indicator: Customer bill of exchange payment before due date
134	STGRD	☐	STGRD	STGRD	CHAR	2	0	Reason for Reversal	T041C
135	PPNAM	☐	PPNAM	XUBNAME	CHAR	12	0	Name of User Who Parked this Document
136	BRNCH	☐	J_1ABRNCH	J_1BBRANCH	CHAR	4	0	Branch number	J_1BBRANCH
137	NUMPG	☐	J_1ANOPG	J_1ANOPG	NUMC	3	0	Number of pages of invoice
138	ADISC	☐	J_1ADISC	ADISC	CHAR	1	0	Indicator: entry represents a discount document
139	XREF1_HD	☐	XREF1_HD	CHAR20	CHAR	20	0	Reference Key 1 Internal for Document Header
140	XREF2_HD	☐	XREF2_HD	CHAR20	CHAR	20	0	Reference Key 2 Internal for Document Header
141	XREVERSAL	☐	XREVERSAL	XREVERSAL	CHAR	1	0	Specifies whether doc. is reversal doc. or reversed doc.
142	REINDAT	☐	REINDAT	DATUM	DATS	8	0	Invoice Receipt Date
143	RLDNR	☐	FAGL_RLDNR	RLDNR	CHAR	2	0	Ledger in General Ledger Accounting	T882G
144	LDGRP	☐	FAGL_LDGRP	FAGL_LDGRP	CHAR	4	0	Ledger Group	FAGL_TLDGRP
145	PROPMANO	☐	RE_MANDAT	RE_MANDAT	CHAR	13	0	Real Estate Management Mandate
146	XBLNR_ALT	☐	XBLNR_ALT	XBLNR_ALT	CHAR	26	0	Alternative Reference Number
147	VATDATE	☐	VATDATE	DATUM	DATS	8	0	Tax Reporting Date
148	DOCCAT	☐	DOCUMENT_CATEGORY	DOCUMENT_CATEGORY	CHAR	6	0	Classification of an FI Document
149	XSPLIT	☐	SPLIT_POSTING	XFELD	CHAR	1	0	FI Document Originates from Split Posting (Indicator)
150	CASH_ALLOC	☐	FAGL_CASH_ALLOC	BOOLE	CHAR	1	0	Cash-Relevant Document
151	FOLLOW_ON	☐	FAGL_FOLLOW_ON	FAGL_FOLLOW_ON	CHAR	1	0	Follow-on document indicator
152	XREORG	☐	FAGL_R_XDOC_REORG	FLAG	CHAR	1	0	Doc. Contains Open Item that Was Transferred During Reorg.
153	SUBSET	☐	ACC_SUBSET	ACC_SUBSET	CHAR	4	0	Defines subset of components for the FI/CO interface
154	KURST	☐	KURST	KURST	CHAR	4	0	Exchange Rate Type	TCURV
155	KURSX	☐	GLE_FXR_DTE_RATEX28	GLE_FXR_RATEX28	DEC	28	14	Market Data Exchange Rate
156	KUR2X	☐	GLE_FXR_DTE_RATE2X28	GLE_FXR_RATEX28	DEC	28	14	Market Data Exchange Rate 2
157	KUR3X	☐	GLE_FXR_DTE_RATE3X28	GLE_FXR_RATEX28	DEC	28	14	Market Data Exchange Rate 3
158	XMCA	☐	GLE_DTE_MCA_XMCA	XFELD	CHAR	1	0	Document Originates from Multi Currency Accounting
159	/SAPF15/STATUS	☐	/SAPF15/STATUS	/SAPF15/STATUS	CHAR	1	0	Document Status
160	PSOTY	☐	PSOTY_D	PSOTY	CHAR	2	0	Document category payment requests	PSOTP
161	PSOAK	☐	PSOAK	PSOAK	CHAR	10	0	Reason	PSO12
162	PSOKS	☐	PSOKS	PSOKS	CHAR	10	0	Region
163	PSOSG	☐	PSOSG	PSOSG	CHAR	1	0	Reason for reversal - IS-PS requests
164	PSOFN	☐	PSOFN	CHAR30	CHAR	30	0	IS-PS: File number
165	INTFORM	☐	FM_INTFORM	CHAR4	CHAR	4	0	Interest Formula
166	INTDATE	☐	FM_INTDATE	DATUM	DATS	8	0	Interest Calc. Date
167	PSOBT	☐	PSOBT	DATUM	DATS	8	0	Posting Day
168	PSOZL	☐	PSOZL	XFELD	CHAR	1	0	Actual posting
169	PSODT	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
170	PSOTM	☐	PSOTM	UZEIT	TIMS	6	0	Last changed at
171	FM_UMART	☐	FM_UMART	FM_UMART	CHAR	1	0	Type of Payment Transfer
172	CCINS	☐	CCINS_30F	CCINS_30F	CHAR	4	0	Payment cards: Card type	TCRIN
173	CCNUM	☐	CCNUM_30F	CCNUM_30F	CHAR	25	0	Payment cards: Card number
174	SSBLK	☐	SSBLK	SSBLK	CHAR	1	0	Payment Statistical Sampling Block
175	BATCH	☐	LOTKZ	LOTKZ	CHAR	10	0	Lot Number for Documents
176	SNAME	☐	UNAME	UNAME	CHAR	12	0	User Name
177	SAMPLED	☐	SAMPLED	SSBLK	CHAR	1	0	Sampled Invoice by Payment Certification
178	EXCLUDE_FLAG	☐	EXCLUDE_FLG	XFELD	CHAR	1	0	PPA Exclude Indicator
179	BLIND	☐	FM_BLIND	FM_BLIND	CHAR	1	0	Budgetary Ledger Indicator
180	OFFSET_STATUS	☐	FMFG_OFFSET_STATUS	FMFG_OFFSET_STATUS	CHAR	2	0	Treasury Offset Status
181	OFFSET_REFER_DAT	☐	FMFG_REFERRED_OFFSET_DAT	DATUM	DATS	8	0	Date Record Referred to Treasury
182	PENRC	☐	PENRC	CHAR2	CHAR	2	0	Reason for Late Payment
183	KNUMV	☐	KNUMV	KNUMV	CHAR	10	0	Number of the document condition

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	V_VIITTAXDOC_DS	ACCSYSTEM	TIVRAACCSYSTEM	ACCSYSTEM	REF	1	CN
2	V_VIITTAXDOC_DS	AUSBK	T001	BUKRS	REF	C	CN
3	V_VIITTAXDOC_DS	BLART	T003	BLART	REF	1	CN
4	V_VIITTAXDOC_DS	BRNCH	J_1BBRANCH	BRANCH	REF	1	CN
5	V_VIITTAXDOC_DS	CCINS	TCRIN	CCINS
6	V_VIITTAXDOC_DS	KURST	TCURV	KURST	REF	C	CN
7	V_VIITTAXDOC_DS	KUTY2	TCURV	KURST	REF	C	CN
8	V_VIITTAXDOC_DS	KUTY3	TCURV	KURST	REF	C	CN
9	V_VIITTAXDOC_DS	KZWRS	TCURC	WAERS	REF	1	CN
10	V_VIITTAXDOC_DS	LDGRP	FAGL_TLDGRP	LDGRP
11	V_VIITTAXDOC_DS	OPTMETH	TIVITOPTMETH	OPTMETH	REF	1	CN
12	V_VIITTAXDOC_DS	PROCESS	TIVCAPROCESS	PROCESS	REF	1	CN
13	V_VIITTAXDOC_DS	PROCESSVIRADOC	TIVCAPROCESS	PROCESS	REF	1	CN
14	V_VIITTAXDOC_DS	PSOAK	PSO12	PSOAK
15	V_VIITTAXDOC_DS	PSOTY	PSOTP	PSOTYP
16	V_VIITTAXDOC_DS	PSTNGPROCEDURE	TIVRAPROCEDURE	POSTNGPROCEDURE	REF	1	CN
17	V_VIITTAXDOC_DS	RLDNR	T882G	RLDNR
18	V_VIITTAXDOC_DS	STGRD	T041C	STGRD		1	CN
19	V_VIITTAXDOC_DS	TAXGROUP	TIVRATAXGROUP	TAXGROUP	REF	1	CN
20	V_VIITTAXDOC_DS	WAERS	TCURC	WAERS	REF	1	CN

History

Last changed by/on	SAP	20140121
SAP Release Created in