SAP ABAP View V_VIITDOC_DS (Entries in RE Tax Tables for FI 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_VIITDOC_DS
Short Description	Entries in RE Tax Tables for FI Documents
Root table	BKPF	Accounting Document Header

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	BKPF	BKPF
2	VIITTAXDSBASE

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	BKPF	AWKEY	JL	EQ				0	0
2	VIITTAXDSBASE	REFDOCID	JR	EQ			AND	0	0
3	BKPF	MANDT	JL	EQ				0	0
4	VIITTAXDSBASE	MANDT	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	*	BKPF	*		☐		☐
2	MANDT	BKPF	MANDT		☐	MANDT	☐	Client
3	BUKRS	BKPF	BUKRS		☐	BUKRS	☐	Company Code
4	BELNR	BKPF	BELNR		☐	BELNR_D	☐	Accounting Document Number
5	GJAHR	BKPF	GJAHR		☐	GJAHR	☐	Fiscal Year
6	BLART	BKPF	BLART		☐	BLART	☐	Document type
7	BLDAT	BKPF	BLDAT		☐	BLDAT	☐	Document Date in Document
8	BUDAT	BKPF	BUDAT		☐	BUDAT	☐	Posting Date in the Document
9	MONAT	BKPF	MONAT		☐	MONAT	☐	Fiscal period
10	CPUDT	BKPF	CPUDT		☐	CPUDT	☐	Accounting document entry date
11	CPUTM	BKPF	CPUTM		☐	CPUTM	☐	Time of data entry
12	AEDAT	BKPF	AEDAT		☐	AEDAT_BKPF	☐	Date of the Last Document Change by Transaction
13	UPDDT	BKPF	UPDDT		☐	UPDDT	☐	Date of the Last Document Update
14	WWERT	BKPF	WWERT		☐	WWERT_D	☐	Translation date
15	USNAM	BKPF	USNAM		☐	USNAM	☐	User name
16	TCODE	BKPF	TCODE		☐	TCODE	☐	Transaction Code
17	BVORG	BKPF	BVORG		☐	BVORG	☐	Number of Cross-Company Code Posting Transaction
18	XBLNR	BKPF	XBLNR		☐	XBLNR1	☐	Reference Document Number
19	DBBLG	BKPF	DBBLG		☐	DBBLG	☐	Recurring Entry Document Number
20	STBLG	BKPF	STBLG		☐	STBLG	☐	Reverse Document Number
21	STJAH	BKPF	STJAH		☐	STJAH	☐	Reverse document fiscal year
22	BKTXT	BKPF	BKTXT		☐	BKTXT	☐	Document Header Text
23	WAERS	BKPF	WAERS		☐	WAERS	☐	Currency Key
24	KURSF	BKPF	KURSF		☐	KURSF	☐	Exchange rate
25	KZWRS	BKPF	KZWRS		☐	KZWRS	☐	Currency Key for the Group Currency
26	KZKRS	BKPF	KZKRS		☐	KZKRS	☐	Group Currency Exchange Rate
27	BSTAT	BKPF	BSTAT		☐	BSTAT_D	☐	Document Status
28	XNETB	BKPF	XNETB		☐	XNETB	☐	Indicator: Document posted net ?
29	FRATH	BKPF	FRATH		☐	FRATH	☐	Unplanned Delivery Costs
30	XRUEB	BKPF	XRUEB		☐	XRUEB	☐	Indicator: Document is posted to a previous period
31	GLVOR	BKPF	GLVOR		☐	GLVOR	☐	Business Transaction
32	GRPID	BKPF	GRPID		☐	GRPID_BKPF	☐	Batch Input Session Name
33	DOKID	BKPF	DOKID		☐	DOKID_BKPF	☐	Document Name in the Archive System
34	ARCID	BKPF	ARCID		☐	EXTID_BKPF	☐	Extract ID Document Header
35	IBLAR	BKPF	IBLAR		☐	IBLAR	☐	Internal Document Type for Document Control
36	AWTYP	BKPF	AWTYP		☐	AWTYP	☐	Reference procedure
37	AWKEY	BKPF	AWKEY		☐	AWKEY	☐	Object key
38	FIKRS	BKPF	FIKRS		☐	FIKRS	☐	Financial Management Area
39	HWAER	BKPF	HWAER		☐	HWAER	☐	Local Currency
40	HWAE2	BKPF	HWAE2		☐	HWAE2	☐	Currency Key of Second Local Currency
41	HWAE3	BKPF	HWAE3		☐	HWAE3	☐	Currency Key of Third Local Currency
42	KURS2	BKPF	KURS2		☐	KURS2	☐	Exchange Rate for the Second Local Currency
43	KURS3	BKPF	KURS3		☐	KURS3	☐	Exchange Rate for the Third Local Currency
44	BASW2	BKPF	BASW2		☐	CURSR	☐	Source Currency for Currency Translation
45	BASW3	BKPF	BASW3		☐	CURSR	☐	Source Currency for Currency Translation
46	UMRD2	BKPF	UMRD2		☐	UMRD2	☐	Translation Date Type for Second Local Currency
47	UMRD3	BKPF	UMRD3		☐	UMRD3	☐	Translation Date Type for Third Local Currency
48	XSTOV	BKPF	XSTOV		☐	XSTOV	☐	Indicator: Document is flagged for reversal
49	STODT	BKPF	STODT		☐	STODT	☐	Planned Date for the Reverse Posting
50	XMWST	BKPF	XMWST		☐	XMWST	☐	Calculate tax automatically
51	CURT2	BKPF	CURT2		☐	CURT2	☐	Currency Type of Second Local Currency
52	CURT3	BKPF	CURT3		☐	CURT3	☐	Currency Type of Third Local Currency
53	KUTY2	BKPF	KUTY2		☐	KURST	☐	Exchange Rate Type
54	KUTY3	BKPF	KUTY3		☐	KURST	☐	Exchange Rate Type
55	XSNET	BKPF	XSNET		☐	XSNET	☐	G/L account amounts entered exclude tax
56	AUSBK	BKPF	AUSBK		☐	AUSBK	☐	Source Company Code
57	XUSVR	BKPF	XUSVR		☐	XUSVR_BKPF	☐	Indicator: US taxes changed at detail level ?
58	DUEFL	BKPF	DUEFL		☐	DUEFL_BKPF	☐	Status of Data Transfer into Subsequent Release
59	AWSYS	BKPF	AWSYS		☐	LOGSYSTEM	☐	Logical System
60	TXKRS	BKPF	TXKRS		☐	TXKRS_BKPF	☐	Exchange Rate for Taxes
61	LOTKZ	BKPF	LOTKZ		☐	PSO_LOTKZ	☐	Lot Number for Requests
62	XWVOF	BKPF	XWVOF		☐	XWVOF	☐	Indicator: Customer bill of exchange payment before due date
63	STGRD	BKPF	STGRD		☐	STGRD	☐	Reason for Reversal
64	PPNAM	BKPF	PPNAM		☐	PPNAM	☐	Name of User Who Parked this Document
65	BRNCH	BKPF	BRNCH		☐	J_1ABRNCH	☐	Branch number
66	NUMPG	BKPF	NUMPG		☐	J_1ANOPG	☐	Number of pages of invoice
67	ADISC	BKPF	ADISC		☐	J_1ADISC	☐	Indicator: entry represents a discount document
68	XREF1_HD	BKPF	XREF1_HD		☐	XREF1_HD	☐	Reference Key 1 Internal for Document Header
69	XREF2_HD	BKPF	XREF2_HD		☐	XREF2_HD	☐	Reference Key 2 Internal for Document Header
70	XREVERSAL	BKPF	XREVERSAL		☐	XREVERSAL	☐	Specifies whether doc. is reversal doc. or reversed doc.
71	REINDAT	BKPF	REINDAT		☐	REINDAT	☐	Invoice Receipt Date
72	RLDNR	BKPF	RLDNR		☐	FAGL_RLDNR	☐	Ledger in General Ledger Accounting
73	LDGRP	BKPF	LDGRP		☐	FAGL_LDGRP	☐	Ledger Group
74	PROPMANO	BKPF	PROPMANO		☐	RE_MANDAT	☐	Real Estate Management Mandate
75	XBLNR_ALT	BKPF	XBLNR_ALT		☐	XBLNR_ALT	☐	Alternative Reference Number
76	VATDATE	BKPF	VATDATE		☐	VATDATE	☐	Tax Reporting Date
77	DOCCAT	BKPF	DOCCAT		☐	DOCUMENT_CATEGORY	☐	Classification of an FI Document
78	XSPLIT	BKPF	XSPLIT		☐	SPLIT_POSTING	☐	FI Document Originates from Split Posting (Indicator)
79	CASH_ALLOC	BKPF	CASH_ALLOC		☐	FAGL_CASH_ALLOC	☐	Cash-Relevant Document
80	FOLLOW_ON	BKPF	FOLLOW_ON		☐	FAGL_FOLLOW_ON	☐	Follow-on document indicator
81	XREORG	BKPF	XREORG		☐	FAGL_R_XDOC_REORG	☐	Doc. Contains Open Item that Was Transferred During Reorg.
82	SUBSET	BKPF	SUBSET		☐	ACC_SUBSET	☐	Defines subset of components for the FI/CO interface
83	KURST	BKPF	KURST		☐	KURST	☐	Exchange Rate Type
84	KURSX	BKPF	KURSX		☐	GLE_FXR_DTE_RATEX28	☐	Market Data Exchange Rate
85	KUR2X	BKPF	KUR2X		☐	GLE_FXR_DTE_RATE2X28	☐	Market Data Exchange Rate 2
86	KUR3X	BKPF	KUR3X		☐	GLE_FXR_DTE_RATE3X28	☐	Market Data Exchange Rate 3
87	XMCA	BKPF	XMCA		☐	GLE_DTE_MCA_XMCA	☐	Document Originates from Multi Currency Accounting
88	/SAPF15/STATUS	BKPF	/SAPF15/STATUS		☐	/SAPF15/STATUS	☐	Document Status
89	PSOTY	BKPF	PSOTY		☐	PSOTY_D	☐	Document category payment requests
90	PSOAK	BKPF	PSOAK		☐	PSOAK	☐	Reason
91	PSOKS	BKPF	PSOKS		☐	PSOKS	☐	Region
92	PSOSG	BKPF	PSOSG		☐	PSOSG	☐	Reason for reversal - IS-PS requests
93	PSOFN	BKPF	PSOFN		☐	PSOFN	☐	IS-PS: File number
94	INTFORM	BKPF	INTFORM		☐	FM_INTFORM	☐	Interest Formula
95	INTDATE	BKPF	INTDATE		☐	FM_INTDATE	☐	Interest Calc. Date
96	PSOBT	BKPF	PSOBT		☐	PSOBT	☐	Posting Day
97	PSOZL	BKPF	PSOZL		☐	PSOZL	☐	Actual posting
98	PSODT	BKPF	PSODT		☐	AEDAT	☐	Last Changed On
99	PSOTM	BKPF	PSOTM		☐	PSOTM	☐	Last changed at
100	FM_UMART	BKPF	FM_UMART		☐	FM_UMART	☐	Type of Payment Transfer
101	CCINS	BKPF	CCINS		☐	CCINS_30F	☐	Payment cards: Card type
102	CCNUM	BKPF	CCNUM		☐	CCNUM_30F	☐	Payment cards: Card number
103	SSBLK	BKPF	SSBLK		☐	SSBLK	☐	Payment Statistical Sampling Block
104	BATCH	BKPF	BATCH		☐	LOTKZ	☐	Lot Number for Documents
105	SNAME	BKPF	SNAME		☐	UNAME	☐	User Name
106	SAMPLED	BKPF	SAMPLED		☐	SAMPLED	☐	Sampled Invoice by Payment Certification
107	EXCLUDE_FLAG	BKPF	EXCLUDE_FLAG		☐	EXCLUDE_FLG	☐	PPA Exclude Indicator
108	BLIND	BKPF	BLIND		☐	FM_BLIND	☐	Budgetary Ledger Indicator
109	OFFSET_STATUS	BKPF	OFFSET_STATUS		☐	FMFG_OFFSET_STATUS	☐	Treasury Offset Status
110	OFFSET_REFER_DAT	BKPF	OFFSET_REFER_DAT		☐	FMFG_REFERRED_OFFSET_DAT	☐	Date Record Referred to Treasury
111	PENRC	BKPF	PENRC		☐	PENRC	☐	Reason for Late Payment
112	KNUMV	BKPF	KNUMV		☐	KNUMV	☐	Number of the document condition
113	*	VIITTAXDSBASE	*		☐		☐
114	-	VIITTAXDSBASE	MANDT		☐	MANDT	☐	Client
115	DOCGUID	VIITTAXDSBASE	DOCGUID		☐	REITDOCGUID	☐	GUID: Unique Internal Key for Tax Document
116	ITEMNO	VIITTAXDSBASE	ITEMNO		☐	REITITEMNO	☐	Internal Item Number for Tax Document Item
117	REFDOCTYPE	VIITTAXDSBASE	REFDOCTYPE		☐	RERAREFDOCTYPE	☐	Reference to Document Class
118	REFDOCID	VIITTAXDSBASE	REFDOCID		☐	RERAREFDOCID	☐	Reference Key of Document
119	REFITEMNO	VIITTAXDSBASE	REFITEMNO		☐	POSNR_ACC	☐	Accounting Document Line Item Number
120	ACCSYSTEM	VIITTAXDSBASE	ACCSYSTEM		☐	RERAACCSYSTEM	☐	Definition of Accounting System
121	LOGSYSTEM	VIITTAXDSBASE	LOGSYSTEM		☐	LOGSYSTEM	☐	Logical System
122	REVDOCID	VIITTAXDSBASE	REVDOCID		☐	RERAREVDOCID	☐	Reference Key of Reversal Document
123	STATUS	VIITTAXDSBASE	STATUS		☐	REITDSSTATUS	☐	Tax Breakdown Status
124	FISCALYEAR	VIITTAXDSBASE	FISCALYEAR		☐	GJAHR	☐	Fiscal Year
125	PSTNGPERIOD	VIITTAXDSBASE	PSTNGPERIOD		☐	RERAPSTNGPERIOD	☐	Posting Period
126	PSTNGDATE	VIITTAXDSBASE	PSTNGDATE		☐	RERAPSTNGDATE	☐	Posting Date
127	-	VIITTAXDSBASE	BUKRS		☐	BUKRS	☐	Company Code
128	OBJNR	VIITTAXDSBASE	OBJNR		☐	REITOBJNR	☐	ID of Object for which Option Rate Was Determined
129	REFDATE	VIITTAXDSBASE	REFDATE		☐	DABRBEZ	☐	Reference date for settlement
130	DCINDICATOR	VIITTAXDSBASE	DCINDICATOR		☐	RERADCINDICATOR	☐	Debit/Credit Indicator
131	COSTACCOUNT	VIITTAXDSBASE	COSTACCOUNT		☐	REITCOSTACCOUNT	☐	Cost Account in G/L Accounting
132	TAXTYPE	VIITTAXDSBASE	TAXTYPE		☐	RERATAXTYPE	☐	Tax Type
133	TAXGROUP	VIITTAXDSBASE	TAXGROUP		☐	RERATAXGROUP	☐	Tax Group
134	TAXACCOUNT	VIITTAXDSBASE	TAXACCOUNT		☐	REITTAXACCOUNT	☐	Tax Account of General Ledger Accounting
135	OBJNROPTRATE	VIITTAXDSBASE	OBJNROPTRATE		☐	REITOBJNROPTRATE	☐	ID of Object from Which the Option Rate Was Read
136	NETAMOUNT	VIITTAXDSBASE	NETAMOUNT		☐	RERANETAMOUNT	☐	Net Amount in Transaction Currency
137	TAXAMOUNT	VIITTAXDSBASE	TAXAMOUNT		☐	RERATAXAMOUNT	☐	Tax Amount in Transaction Currency
138	DEDTAXAMT	VIITTAXDSBASE	DEDTAXAMT		☐	RERADEDTAXAMT	☐	Deductible Tax Amount
139	NONDEDTAXAMT	VIITTAXDSBASE	NONDEDTAXAMT		☐	RERANONDEDTAXAMT	☐	Non-Deductible Tax Amount
140	CURRENCY	VIITTAXDSBASE	CURRENCY		☐	WAERS	☐	Currency Key
141	TCOBJNR	VIITTAXDSBASE	TCOBJNR		☐	RECAOBJNR	☐	Object Number
142	DATEOFSERVICE	VIITTAXDSBASE	DATEOFSERVICE		☐	REITTCDATEOFSERVICE	☐	Date of Service
143	HASDIFFOPTRATE	VIITTAXDSBASE	HASDIFFOPTRATE		☐	REITHASDIFFOPTRATE	☐	Has Differing Option Rate
144	DIFFOPTRATE	VIITTAXDSBASE	DIFFOPTRATE		☐	REITDIFFOPTRATE	☐	Differing Option Rate for Distribution
145	NOTAXCORR	VIITTAXDSBASE	NOTAXCORR		☐	REITNOTAXCORR	☐	Do Not Consider Item in Input Tax Correction
146	AMTRANSTYPE	VIITTAXDSBASE	AMTRANSTYPE		☐	REITAMTRANSTYPE	☐	Transaction Type of Asset Postings
147	POREFDOCID	VIITTAXDSBASE	POREFDOCID		☐	REEXPOREFDOCID	☐	Reference Document Number of Purchase Order
148	POREFITEMNO	VIITTAXDSBASE	POREFITEMNO		☐	REEXPOREFITEMNO	☐	Number of Purchase Order Item
149	TCBASEGUID	VIITTAXDSBASE	TCBASEGUID		☐	REITTCBASEGUID	☐	GUID for Basis for Input Tax Correction
150	EXTTAXCODE	VIITTAXDSBASE	EXTTAXCODE		☐	RERATAXCODE	☐	Tax Code of the Accounting System

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