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