SAP ABAP Table VIRAINVITEM (RE Invoice Item)

Hierarchy

☛ EA-FIN (Software Component) EA-FIN
   ⤷ RE-FX-RA (Application Component) Rental Accounting
     ⤷ RE_RA_IV (Package) RE: Invoice for Rent

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	VIRAINVITEM	Table Relationship Diagram
Short Description	RE Invoice Item

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
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	.INCLUDE	☑				0	0	RE Invoice Item: Key Fields
3	INVGUID	☑	RERAINVGUID	RECAGUID	RAW	16	0	GUID: Unique Internal Key for RE Invoice	VIRAINV
4	ITEMNO	☑	RERAINVITEMNO	POSNR_ACC	NUMC	10	0	Item Number in RE Invoice
5	.INCLUDE	☐				0	0	RE Invoice Item: Non-Key Fields
6	OBJNR	☐	RERAINVOBJNR	J_OBJNR	CHAR	22	0	Object Number of Contract for the Invoice Item	*
7	OBJNRCALC	☐	RECDOBJNRCALC	J_OBJNR	CHAR	22	0	Object Number for Calculation	*
8	ITEMSRCIND	☐	RERAINVITEMSRCIND	RERAINVITEMSRCIND	CHAR	1	0	Source of Invoice Item
9	CONDTYPE	☐	RECDCONDTYPE	RECDCONDTYPE	CHAR	4	0	Condition Type	TIVCDCONDTYPE
10	FLOWTYPE	☐	RECDFLOWTYPE	RECDFLOWTYPE	CHAR	4	0	Flow Type	TIVCDFLOWTYPE
11	BLINEDATE	☐	DZFBDT	DATUM	DATS	8	0	Baseline date for due date calculation
12	CALCFROM	☐	DBERVON	DATUM	DATS	8	0	Start of Calculation Period
13	CALCTO	☐	DBERBIS	DATUM	DATS	8	0	End of Calculation Period
14	ISADVANCEPAYMENT	☐	RECDADVANCEPAYMENT	RECABOOL	CHAR	1	0	Condition Is Advance Payment Condition
15	CURRENCY	☐	RECACTLCCURRKEY	WAERS	CUKY	5	0	Local Currency	*
16	GROSSAMOUNT	☐	RECACTLCGROSSAMOUNT	RECACURR	CURR	15	2	Gross Amount in Local Currency
17	NETAMOUNT	☐	RECACTLCNETAMOUNT	RECACURR	CURR	15	2	Net Amount in Local Currency
18	TAXAMOUNT	☐	RECACTLCTAXAMOUNT	RECACURR	CURR	15	2	Tax Amount in Local Currency
19	TAXTYPE	☐	RERATAXTYPE	RERATAXTYPE	CHAR	4	0	Tax Type	TIVRATAXTYPE
20	TAXGROUP	☐	RERATAXGROUP	RERATAXGROUP	CHAR	20	0	Tax Group	TIVRATAXGROUP
21	PYMTMETH	☐	RERAPYMTMETH	CHAR4	CHAR	4	0	Payment Method
22	PYMTTERM	☐	RERAPYMTTERM	ZTERM	CHAR	4	0	Terms of Payment Key
23	XMACCTSHEETITEM	☐	RERAXLACCTSHEETITEM	RECAXLDESCRIPTION	CHAR	60	0	Name of Contract Account Sheet Item
24	.INCLUDE	☐				0	0	RE Invoice Item: Fields from FI Document Item
25	DOCITEMID	☐	RERADOCITEMID	RERADOCITEMID	CHAR	30	0	Coded Key of FI Document Item for RE Internal Use
26	REFDOCID	☐	RERAREFDOCID	CHAR20	CHAR	20	0	Reference Key of Document
27	REFITEMNO	☐	RERAREFITEMNO	POSNR_ACC	NUMC	10	0	Reference to Other Item Number of Document
28	LOGSYSTEM	☐	LOGSYSTEM	LOGSYS	CHAR	10	0	Logical System	*
29	OBJ_TYPE	☐	AWTYP	AWTYP	CHAR	5	0	Reference procedure	*
30	OBJ_KEY	☐	AWKEY	AWKEY	CHAR	20	0	Object key
31	PSTNGDATE	☐	RERAPSTNGDATE	RECADATE	DATS	8	0	Posting Date
32	DOCDATE	☐	RERADOCDATE	RECADATE	DATS	8	0	Document Date
33	CLEARINGDATE	☐	RERACLRNGDATE	RECADATE	DATS	8	0	Clearing Date
34	CLEARINGSTATUS	☐	RERACLEARINGSTATUS	CHAR02	CHAR	2	0	Clearing status
35	PROCESSID	☐	RECAPROCESSID	RECAPROCESSID	CHAR	16	0	Process Identification -> Accounting Reference Number
36	PSTNGPROCEDURE	☐	RERAPROCEDURE	RERAPROCEDURE	CHAR	4	0	Posting Procedure	*
37	XMACCTSHEETHDR	☐	RERAXLACCTSHEETHDR	RECAXLDESCRIPTION	CHAR	60	0	Name from Document Header
38	TAXRATE	☐	RERATAXRATE	PRZ43V	DEC	7	3	Tax Rate
39	TAXDATE	☐	RERATAXDATE	RECADATE	DATS	8	0	Date of Tax Calculation
40	TXJCD	☐	TXJCD	TXJCD	CHAR	15	0	Tax Jurisdiction	*
41	HOUSEBKID	☐	RERAHOUSEBKID	CHAR15	CHAR	15	0	Key for House Bank
42	HOUSEBKACC	☐	RERAHOUSEBKACC	CHAR15	CHAR	15	0	Key for House Bank Account
43	BANKDETAILID	☐	RERABANKDETAILID	CHAR15	CHAR	15	0	Bank Details ID
44	FCCURRKEY	☐	RECACTFCCURRKEY	WAERS	CUKY	5	0	Foreign Currency	*
45	FCGROSSAMOUNT	☐	RECACTFCGROSSAMOUNT	RECACURR	CURR	15	2	Gross Amount in Foreign Currency
46	FCNETAMOUNT	☐	RECACTFCNETAMOUNT	RECACURR	CURR	15	2	Net Amount in Foreign Currency
47	FCTAXAMOUNT	☐	RECACTFCTAXAMOUNT	RECACURR	CURR	15	2	Tax Amount in Foreign Currency
48	CTRULE	☐	RECACTRULE	RECACTRULE	CHAR	20	0	Currency Translation Rule	*
49	CTRATE	☐	RECACTRATE	KURSF	DEC	9	5	Exchange Rate
50	CTDATEREQ	☐	RECACTDATEREQ	DATS	DATS	8	0	Planned Translation Date
51	CTDATEACT	☐	RECACTDATEACT	DATS	DATS	8	0	Actual Translation Date
52	POSTCDCURR	☐	RECACTPOSTCDCURR	RECABOOL	CHAR	1	0	Post in Condition Currency
53	TCCURRKEY	☐	RERATCCURRKEY	WAERS	CUKY	5	0	Document Currency (Transaction Currency)	*
54	TCGROSSAMOUNT	☐	RERATCGROSSAMOUNT	RECACURR	CURR	15	2	Gross Amount in Document Currency (Transaction Currency)
55	TCNETAMOUNT	☐	RERATCNETAMOUNT	RECACURR	CURR	15	2	Net Amount in Document Currency (Transaction Currency)
56	TCTAXAMOUNT	☐	RERATCTAXAMOUNT	RECACURR	CURR	15	2	Tax Amount in Document Currency (Transaction Currency)
57	SEPAMNDID	☐	RETMSEPAMNDID	RETMSEPAMNDID	CHAR	35	0	SEPA Mandate: Unique Reference to Mandate per Vendor
58	SEPARECCRDID	☐	RETMSEPARECCRDID	RETMSEPACRDID	CHAR	35	0	SEPA Mandate: Creditor ID

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	VIRAINVITEM	CONDTYPE	TIVCDCONDTYPE	CONDTYPE	REF	C	CN
2	VIRAINVITEM	FLOWTYPE	TIVCDFLOWTYPE	FLOWTYPE	REF	C	CN
3	VIRAINVITEM	INVGUID	VIRAINV	INVGUID	KEY	1	N
4	VIRAINVITEM	TAXGROUP	TIVRATAXGROUP	TAXGROUP	REF	1	CN
5	VIRAINVITEM	TAXTYPE	TIVRATAXTYPE	TAXTYPE	REF	1	CN

History

Last changed by/on	SAP	20110901
SAP Release Created in	500