SAP ABAP Table AVIRAINVITEM (Change Structure for RE Invoice Item (VIRAINVITEM))

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	INTTAB	Structure
Structure	AVIRAINVITEM	Table Relationship Diagram
Short Description	Change Structure for RE Invoice Item (VIRAINVITEM)

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

Foreign Keys

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

History

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