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