SAP ABAP Table V_VIRADOCITEM_DS (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	V_VIRADOCITEM_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	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	MANDT	MANDT	CLNT	3	0	Client
2	DOCGUID	RERADOCGUID	RECAGUID	RAW	16	0	GUID: Unique Internal Key for RE Document
3	PSTNGPROCEDURE	RERAPROCEDURE	RERAPROCEDURE	CHAR	4	0	Posting Procedure	TIVRAPROCEDURE
4	PROCESS	RECAPROCESS	RECAPROCESS	CHAR	4	0	Process	TIVCAPROCESS
5	PROCESSGUID	RECAPROCESSGUID	RECAGUID	RAW	16	0	Generic Key of Process
6	PROCESSID	RECAPROCESSID	RECAPROCESSID	CHAR	16	0	Process Identification -> Accounting Reference Number
7	FISC_YEAR	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
8	PSTNGPERIOD	RERAPSTNGPERIOD	RERAFISCALPERIOD	NUMC	2	0	Posting Period
9	PSTNGDATE	RERAPSTNGDATE	RECADATE	DATS	8	0	Posting Date
10	DOCDATE	RERADOCDATE	RECADATE	DATS	8	0	Document Date
11	ACCSYSTYPE	RERAACCSYSTYPE	RERAACCSYSTYPE	CHAR	4	0	Type of Accounting System
12	REFDOCID	RERAREFDOCID	CHAR20	CHAR	20	0	Reference Key of Document
13	LOGSYSTEM	LOGSYSTEM	LOGSYS	CHAR	10	0	Logical System
14	REVID	RERAREVID	RERAREVID	CHAR	1	0	Indicator for Reversed Documents
15	REVDOCGUID	RERAREVDOCGUID	RECAGUID	RAW	16	0	GUID: Internal Key for Accompanying Reversal Document
16	STATUS	RERASTATUS	BSTAT	CHAR	1	0	RE Document Status
17	TAXID	RERATAXID	CHAR1	CHAR	1	0	Tax Exists
18	HASGLACCSYMB	RERAHASGLACCSYMB	RECABOOL	CHAR	1	0	Indicator: Account Symbol
19	REFERENCEDOCGUID	RERAREFGUID	RECAGUID	RAW	16	0	Reference GUID
20	RERF	RERF	SYCHAR12	CHAR	12	0	Entered by
21	DERF	DERF	DATUM	DATS	8	0	First Entered on
22	TERF	TERF	TIMES	TIMS	6	0	Time of Initial Entry
23	REHER	REHER	CHAR10	CHAR	10	0	Source of initial entry
24	RBEAR	RBEAR	SYCHAR12	CHAR	12	0	Employee ID
25	DBEAR	DBEAR	DATUM	DATS	8	0	Last Edited on
26	TBEAR	TBEAR	TIMES	TIMS	6	0	Last Edited at
27	RBHER	RBHER	CHAR10	CHAR	10	0	Editing Source
28	FDELETE	RECAARDELETEIND	RECABOOL	CHAR	1	0	Deletion Indicator for Archiving
29	CTRULE	RECACTRULE	RECACTRULE	CHAR	20	0	Currency Translation Rule
30	CTRATE	RECACTRATE	KURSF	DEC	9	5	Exchange Rate
31	POSTCDCURR	RECACTPOSTCDCURR	RECABOOL	CHAR	1	0	Post in Condition Currency
32	CTDATEREQ	RECACTDATEREQ	DATS	DATS	8	0	Planned Translation Date
33	CTDATEACT	RECACTDATEACT	DATS	DATS	8	0	Actual Translation Date
34	CTFCCURRKEY	RECACTFCCURRKEY	WAERS	CUKY	5	0	Foreign Currency
35	ITEMNO	POSNR_ACC	POSNR_ACC	NUMC	10	0	Accounting Document Line Item Number
36	REFITEMNO	RERAREFITEMNO	POSNR_ACC	NUMC	10	0	Reference to Other Item Number of Document
37	BUKRS	BUKRS	BUKRS	CHAR	4	0	Company Code
38	ITEMTYPE	RERAITEMTYPE	CHAR02	CHAR	2	0	Item Category
39	REFDATE	DABRBEZ	DDAT	DATS	8	0	Reference date for settlement
40	CLEARINGSTATUS	RERACLEARINGSTATUS	CHAR02	CHAR	2	0	Clearing status
41	CLEARNGPROCESSID	RECAPROCESSID	RECAPROCESSID	CHAR	16	0	Process Identification -> Accounting Reference Number
42	PAYEDSTATUS	RERAPAYEDSTATUS	CHAR02	CHAR	2	0	Payment Status
43	DUNNINGSTATUS	RERADUNNINGSTATUS	CHAR02	CHAR	2	0	Dunning Status
44	REFGUIDORIGIN	RERAGUIDORIGIN	CHAR04	CHAR	4	0	Source of GUID
45	REFGUID	RERAREFGUID	RECAGUID	RAW	16	0	Reference GUID
46	OBJNR	RERAOBJNR	J_OBJNR	CHAR	22	0	Account Assignment: Object Number
47	PFROM	DBERVON	DATUM	DATS	8	0	Start of Calculation Period
48	PTO	DBERBIS	DATUM	DATS	8	0	End of Calculation Period
49	BLINEDATE	DZFBDT	DATUM	DATS	8	0	Baseline date for due date calculation
50	ORIGDUEDATE	RECDORIGDUEDATE	DATUM	DATS	8	0	Original Due Date
51	CONDTYPE	RECDCONDTYPE	RECDCONDTYPE	CHAR	4	0	Condition Type	TIVCDCONDTYPE
52	ISADVANCEPAYMENT	RECDADVANCEPAYMENT	RECABOOL	CHAR	1	0	Condition Is Advance Payment Condition
53	FLOWTYPE	RECDFLOWTYPE	RECDFLOWTYPE	CHAR	4	0	Flow Type	TIVCDFLOWTYPE
54	DCINDICATOR	RERADCINDICATOR	RERADCINDICATOR	CHAR	1	0	Debit/Credit Indicator
55	TAXGROUPID	RERATAXGROUPID	NUM03	NUMC	3	0	Group Indicator for Tax Line Items
56	TAXDATE	RERATAXDATE	RECADATE	DATS	8	0	Date of Tax Calculation
57	TERMNOOA	RETMTERMNO	RETMTERMNO	CHAR	4	0	Term Number
58	GSBER	GSBER	GSBER	CHAR	4	0	Business Area
59	PRCTR	PRCTR	PRCTR	CHAR	10	0	Profit Center
60	ADDOBJNR	RERAADDOBJNR	J_OBJNR	CHAR	22	0	Object Number for Additional Account Assignment
61	FUND	RERAFUND	CHAR24	CHAR	24	0	Fund
62	FUNDSCENTER	RERAFUNDSCENTER	CHAR24	CHAR	24	0	Funds Center
63	COMMITMENTITEM	RERACOMMITMENTITEM	FM_FIPEX	CHAR	24	0	Commitment Item
64	FUNCTIONALAREA	RERAFUNCTIONALAREA	CHAR24	CHAR	24	0	Functional Area
65	GRANTNUMBER	RERAGRANTNUMBER	CHAR24	CHAR	24	0	Grant
66	MEASURE	RERAMEASURE	CHAR24	CHAR	24	0	Program in Funds Management
67	BUDGETPERIOD	RERABUDGETPERIOD	CHAR24	CHAR	24	0	FM: Budget Period
68	TERMNOPY	RETMTERMNO	RETMTERMNO	CHAR	4	0	Term Number
69	CDSPLITNO	RETMCDSPLITNO	NUMC4	NUMC	4	0	Number of Condition Split
70	PYMTMETH	RERAPYMTMETH	CHAR4	CHAR	4	0	Payment Method
71	PYMTMETHCRMO	RERAPYMTMETHCRMO	CHAR4	CHAR	4	0	Payment Method for Credit Memos
72	PYMTBLOCK	RERAPYMTBLOCK	CHAR4	CHAR	4	0	Payment block key
73	PYMTTERM	RERAPYMTTERM	ZTERM	CHAR	4	0	Terms of Payment Key
74	HOUSEBKID	RERAHOUSEBKID	CHAR15	CHAR	15	0	Key for House Bank
75	HOUSEBKACC	RERAHOUSEBKACC	CHAR15	CHAR	15	0	Key for House Bank Account
76	BANKDETAILID	RERABANKDETAILID	CHAR15	CHAR	15	0	Bank Details ID
77	NOTETOPAYEE	RERANOTETOPAYEE	RERANOTETOPAYEE	CHAR	25	0	Note to Payee
78	DUNNAREA	RERADUNNAREA	CHAR4	CHAR	4	0	Dunning Area
79	DUNNKEY	RERADUNNKEY	CHAR4	CHAR	4	0	Dunning Keys
80	DUNNBLOCK	RERADUNNBLOCK	CHAR4	CHAR	4	0	Dunning Block
81	ACCDETKEY	RERAACCDETKEY	RERAACCDETKEY	CHAR	10	0	Account Determination Value
82	TAXTYPE	RERATAXTYPE	RERATAXTYPE	CHAR	4	0	Tax Type	TIVRATAXTYPE
83	TAXGROUP	RERATAXGROUP	RERATAXGROUP	CHAR	20	0	Tax Group	TIVRATAXGROUP
84	ISGROSS	RECDISGROSS	RECABOOL	CHAR	1	0	Condition Amount Is Gross Amount
85	PARTNER	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number
86	PARTNEROBJNR	RETMPARTNEROBJNR	J_OBJNR	CHAR	22	0	Object Number for Internal Use
87	TXJCD	TXJCD	TXJCD	CHAR	15	0	Tax Jurisdiction
88	ISCDSPLIT	RETMISCDSPLIT	RECABOOL	CHAR	1	0	Condition Split
89	ISPARTNERBLOCKED	RERAISPARTNERBLOCKED	RECABOOL	CHAR	1	0	Lock of Partner Data in Posting Term
90	SEPAMNDID	RETMSEPAMNDID	RETMSEPAMNDID	CHAR	35	0	SEPA Mandate: Unique Reference to Mandate per Vendor
91	SEPARECCRDID	RETMSEPARECCRDID	RETMSEPACRDID	CHAR	35	0	SEPA Mandate: Creditor ID
92	TERMNOWT	RETMTERMNO	RETMTERMNO	CHAR	4	0	Term Number
93	ACCTYPE	RERAACCTYPE	RERAACCTYPE	CHAR	1	0	Account Type
94	GLACCSYMB	RERAGLACCSYMB	RERAGLACCSYMB	CHAR	15	0	Account Determination: Account Symbols
95	GLACCOUNT	RERAGLACCOUNT	RERAGLACCOUNT	CHAR	10	0	General Ledger Account
96	AMOUNT	RERAAMOUNT	RECACURR	CURR	15	2	Amount in Transaction Currency
97	GROSSAMOUNT	RERAGROSSAMOUNT	RECACURR	CURR	15	2	Gross Amount in Transaction Currency
98	NETAMOUNT	RERANETAMOUNT	RECACURR	CURR	15	2	Net Amount in Transaction Currency
99	TAXAMOUNT	RERATAXAMOUNT	RECACURR	CURR	15	2	Tax Amount in Transaction Currency
100	CURRENCY	WAERS	WAERS	CUKY	5	0	Currency Key
101	CTLCAMOUNT	RECACTLCAMOUNT	RECACURR	CURR	15	2	Amount in Local Currency
102	CTLCGROSSAMOUNT	RECACTLCGROSSAMOUNT	RECACURR	CURR	15	2	Gross Amount in Local Currency
103	CTLCNETAMOUNT	RECACTLCNETAMOUNT	RECACURR	CURR	15	2	Net Amount in Local Currency
104	CTLCTAXAMOUNT	RECACTLCTAXAMOUNT	RECACURR	CURR	15	2	Tax Amount in Local Currency
105	CTLCCURRKEY	RECACTLCCURRKEY	WAERS	CUKY	5	0	Local Currency
106	CTFCAMOUNT	RECACTFCAMOUNT	RECACURR	CURR	15	2	Amount in Foreign Currency
107	CTFCGROSSAMOUNT	RECACTFCGROSSAMOUNT	RECACURR	CURR	15	2	Gross Amount in Foreign Currency
108	CTFCNETAMOUNT	RECACTFCNETAMOUNT	RECACURR	CURR	15	2	Net Amount in Foreign Currency
109	CTFCTAXAMOUNT	RECACTFCTAXAMOUNT	RECACURR	CURR	15	2	Tax Amount in Foreign Currency
110	TAXRATE	RERATAXRATE	PRZ43V	DEC	7	3	Tax Rate
111	EXTTAXCODE	RERATAXCODE		CHAR	5	0	Tax Code of the Accounting System
112	EXTREF1	RERAEXTREF1		CHAR	60	0	External Reference 1 (Line Item)
113	EXTREF2	RERAEXTREF2		CHAR	60	0	External Reference 2 (Line Item)
114	EXTREF3	RERAEXTREF3		CHAR	60	0	External Reference 3 (Line Item)
115	EXTREF4	RERAEXTREF4		CHAR	60	0	External Reference 4 (Line Item)

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right

1	V_VIRADOCITEM_DS	CONDTYPE	TIVCDCONDTYPE	CONDTYPE	KEY	1	CN
2	V_VIRADOCITEM_DS	FLOWTYPE	TIVCDFLOWTYPE	FLOWTYPE	KEY	1	CN
3	V_VIRADOCITEM_DS	PROCESS	TIVCAPROCESS	PROCESS	REF	1	CN
4	V_VIRADOCITEM_DS	PSTNGPROCEDURE	TIVRAPROCEDURE	POSTNGPROCEDURE	REF	1	CN
5	V_VIRADOCITEM_DS	TAXGROUP	TIVRATAXGROUP	TAXGROUP	REF	C	CN
6	V_VIRADOCITEM_DS	TAXTYPE	TIVRATAXTYPE	TAXTYPE	REF	C	CN