SAP TABLES | Real Estate Management | Flexible Real Estate Management(RE-FX) SAP RE

VIYCEXPITEM SAP Expense Items Table and data







VIYCEXPITEM is a standard SAP Table which is used to store Expense Items data and is available within R/3 SAP systems depending on the version and release level.

Below is the standard documentation available and a few details of the fields which make up this Table. You can view further information about SAP VIYCEXPITEM Table and the data within it using relevant transactions such as SE11, SE80 or SE16. Also check out the Comments section below to view or add related contributions and example screen shots.

Delivery Class: A - Application table containing master and transaction data

Display/Maintenance via SM30: Allowed

Enhancement category i: Can be enhanced (character-type or numeric)
See here for more information about this and other SAP enhancement categories


SAP VIYCEXPITEM Table fields within data Dictionary





FieldData ElementData Typelength (Decimals)Check tableDescriptionConversion Routine
MANDTMANDTCLNT3
*
Client
.INCLUDEVIYCEXPITEM_KEY RE CAM Expense Items – Key
EXPLINEGUIDREYCEXPGUIDRAW16 Expense Type of CAM Pool
.INCLUDEVIYCEXPITEM_TAB RE CAM Expense Items - Non-Key Fields
OBJNRRECAOBJNRCHAR22
*
Object Number
REFBKCO_REFBKCHAR4
*
Company code of FI document
REFBNCO_REFBNCHAR10 Reference Document NumberALPHA
AWORGAWORGCHAR10 Reference Organizational Units
AWKEYAWKEYCHAR20 Reference Key
REFGJCO_REFGJNUMC4 Fiscal year of reference documentGJAHR
REFBZCO_REFBZNUMC3 Posting row of reference document
AWTYPAWTYPCHAR5
*
Reference Transaction
LOGSYSTEMLOGSYSTEMCHAR10
*
Logical SystemALPHA
KOKRSKOKRSCHAR4
*
Controlling Area
BELNRCO_BELNRCHAR10
*
Document NumberALPHA
BUKRSBUKRSCHAR4
*
Company Code
BUZEIBUZEINUMC3 Number of Line Item Within Accounting Document
BSCHLBSCHLCHAR2
*
Posting Key
UMSKZUMSKZCHAR1
*
Special G/L Indicator
MWSKZMWSKZCHAR2
*
Tax on sales/purchases code
SHKZGSHKZGCHAR1 Debit/Credit Indicator
SGTXTSGTXTCHAR50 Item Text
HKONTHKONTCHAR10
*
General Ledger AccountALPHA
MENGEMEGXXXQUAN15(3) Total Quantity
MEINSMEINSUNIT3
*
Base Unit of MeasureCUNIT
DESCRIPTIONREEXACCOUNTDESCRIPTIONCHAR35 Account Description
KOSTLKOSTLCHAR10
*
Cost CenterALPHA
CLEAREDVVJAUGBELCHAR1 Indicator: Item from clearing document
AUGBLAUGBLCHAR10 Document Number of the Clearing DocumentALPHA
IDENTRECAIDENTCHAR50 Complete Object Identification, for Example BE 1000/123
CREDITORNAMERECACREDITORNAMECHAR35 Vendor Name
DABRBEZDABRBEZDATS8 Reference Date for Settlement
GJAHRGJAHRNUMC4 Fiscal YearGJAHR
TXJCDTXJCDCHAR15
*
Tax Jurisdiction
BLARTBLARTCHAR2
*
Document Type
BUDATBUDATDATS8 Posting Date in the Document
BLDATBLDATDATS8 Document Date in Document
USNAMUSNAMCHAR12
*
User name
TCODETCODECHAR20
*
Transaction Code



TXBHWTXBHWCURR13(2) Original Tax Base Amount in Local Currency
TXBFWTXBFWCURR13(2) Original Tax Base Amount in Document Currency
DATEOFSERVICEREITTCDATEOFSERVICEDATS8 Date of Service
EBELNEBELNCHAR10
*
Purchasing Document NumberALPHA
EBELPEBELPNUMC5
*
Item Number of Purchasing Document
ZEKKNDZEKKNNUMC2 Sequential Number of Account Assignment
WERKSWERKS_DCHAR4
*
Plant
MATNRMATNRCHAR18
*
Material NumberMATN1
GSBERGSBERCHAR4
*
Business Area
TAXISCALCULATEDREISTAXISCALCULATEDCHAR1 Tax Is Calculated
EXPTYPEREYCEXPTYPECHAR4 Expense Type
PGOBJNRRECAOBJNRCHAR22
*
Object Number
SERVVALIDFROMREYCSERVVALIDFROMDATS8 Start of Service Period
SERVVALIDTOREYCSERVVALIDTODATS8 End of Service Period
DMBTRREISLCNETAMOUNTCURR13(2) Net Amount in Local Currency
WRBTRREISFCNETAMOUNTCURR13(2) Net Amount in Foreign Currency
BRUTTOREISLCGROSSAMOUNTCURR13(2) Gross Amount in Local Currency
HWAERSHWAERCUKY5
*
Local Currency
WAERSWAERSCUKY5
*
Currency Key
INTRENORECAINTRENOCHAR13 Internal Key of Real Estate Object
REVERSALREYCREVERSALCHAR1 Indicator for Reverse Posting Entered
SEASONALITYKEYREYCSEASONKEYCHAR4 Seasonality
ADJUSTMENTREYCISADJUSTAMTCURR15(2) Adjustment Amount
AWREF_REVAWREF_REVCHAR10 Reversal: Reverse Document Reference Document NumberALPHA



Key field
Non-key field