AVIYCEXPITEM SAP (Change Document Structure Expense Item (VIYCEXPITEM)) Structure details

Dictionary Type: Structure
Description: Change Document Structure Expense Item (VIYCEXPITEM)




ABAP Code to SELECT data from AVIYCEXPITEM
Related tables to AVIYCEXPITEM
Access table AVIYCEXPITEM




Structure field list including key, data, relationships and ABAP select examples

AVIYCEXPITEM is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Change Document Structure Expense Item (VIYCEXPITEM)" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_AVIYCEXPITEM TYPE AVIYCEXPITEM.

The AVIYCEXPITEM table consists of various fields, each holding specific information or linking keys about Change Document Structure Expense Item (VIYCEXPITEM) data available in SAP. These include MANDT (Client), EXPLINEGUID (Expense Type of CAM Pool), OBJNR (Object Number), REFBK (Company code of FI document).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP AVIYCEXPITEM structure fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3Assigned to domainMANDT
EXPLINEGUIDExpense Type of CAM Pool REYCEXPGUIDRAW16RECAGUID
OBJNRObject Number RECAOBJNRCHAR22Assigned to domainJ_OBJNRONR
REFBKCompany code of FI document CO_REFBKCHAR4Assigned to domainBUKRS
REFBNReference Document Number CO_REFBNCHAR10ALPHABELNR
AWORGReference Organizational Units AWORGCHAR10AWORG
AWKEYReference Key AWKEYCHAR20AWKEY
REFGJFiscal year of reference document CO_REFGJNUMC4GJAHRGJAHR
REFBZPosting row of reference document CO_REFBZNUMC3BUZEI
AWTYPReference Transaction AWTYPCHAR5Assigned to domainAWTYP
LOGSYSTEMLogical System LOGSYSTEMCHAR10Assigned to domainALPHALOGSYS
KOKRSControlling Area KOKRSCHAR4Assigned to domainCACCDCAC
BELNRDocument Number CO_BELNRCHAR10Assigned to domainALPHACO_BELNRBLN
BUKRSCompany Code BUKRSCHAR4Assigned to domainBUKRSBUKC_T001
BUZEINumber of Line Item Within Accounting Document BUZEINUMC3BUZEIBUZ
BSCHLPosting Key BSCHLCHAR2Assigned to domainBSCHL
UMSKZSpecial G/L Indicator UMSKZCHAR1Assigned to domainUMSKZ
MWSKZTax on sales/purchases code MWSKZCHAR2Assigned to domainMWSKZ
SHKZGDebit/Credit Indicator SHKZGCHAR1SHKZG
SGTXTItem Text SGTXTCHAR50TEXT50
HKONTGeneral Ledger Account HKONTCHAR10Assigned to domainALPHASAKNR
MENGETotal Quantity MEGXXXQUAN15(3) MENGV8
MEINSBase Unit of Measure MEINSUNIT3Assigned to domainCUNITMEINS
DESCRIPTIONAccount Description REEXACCOUNTDESCRIPTIONCHAR35NAME
KOSTLCost Center KOSTLCHAR10Assigned to domainALPHAKOSTLKOS
CLEAREDIndicator: Item from clearing document VVJAUGBELCHAR1XFELD
AUGBLDocument Number of the Clearing Document AUGBLCHAR10ALPHABELNR
IDENTComplete Object Identification, for Example BE 1000/123 RECAIDENTCHAR50CHAR50
CREDITORNAMEVendor Name RECACREDITORNAMECHAR35NAME
DABRBEZReference Date for Settlement DABRBEZDATS8DDAT
GJAHRFiscal Year GJAHRNUMC4GJAHRGJAHRGJR
TXJCDTax Jurisdiction TXJCDCHAR15Assigned to domainTXJCDTXJ
BLARTDocument Type BLARTCHAR2Assigned to domainBLARTBAR
BUDATPosting Date in the Document BUDATDATS8DATUM
BLDATDocument Date in Document BLDATDATS8DATUM
USNAMUser name USNAMCHAR12Assigned to domainXUBNAMEUSR
TCODETransaction Code TCODECHAR20Assigned to domainTCODETCD
TXBHWOriginal Tax Base Amount in Local Currency TXBHWCURR13(2) WERT7
TXBFWOriginal Tax Base Amount in Document Currency TXBFWCURR13(2) WERT7
DATEOFSERVICEDate of Service REITTCDATEOFSERVICEDATS8RECADATE
EBELNPurchasing Document Number EBELNCHAR10Assigned to domainALPHAEBELNBESMEKK_C
EBELPItem Number of Purchasing Document EBELPNUMC5Assigned to domainEBELPBSP
ZEKKNSequential Number of Account Assignment DZEKKNNUMC2NUM02
WERKSPlant WERKS_DCHAR4Assigned to domainWERKSWRKH_T001W_C
MATNRMaterial Number MATNRCHAR18Assigned to domainMATN1MATNRMATS_MAT1
GSBERBusiness Area GSBERCHAR4Assigned to domainGSBERGSB
TAXISCALCULATEDTax Is Calculated REISTAXISCALCULATEDCHAR1RECABOOL
EXPTYPEExpense Type REYCEXPTYPECHAR4REYCEXPTYPE
PGOBJNRObject Number RECAOBJNRCHAR22Assigned to domainJ_OBJNRONR
SERVVALIDFROMStart of Service Period REYCSERVVALIDFROMDATS8RECADATE
SERVVALIDTOEnd of Service Period REYCSERVVALIDTODATS8RECADATE
DMBTRNet Amount in Local Currency REISLCNETAMOUNTCURR13(2) WERT7
WRBTRNet Amount in Foreign Currency REISFCNETAMOUNTCURR13(2) WERT7
BRUTTOGross Amount in Local Currency REISLCGROSSAMOUNTCURR13(2) WERT7
HWAERSLocal Currency HWAERCUKY5Assigned to domainWAERS
WAERSCurrency Key WAERSCUKY5Assigned to domainWAERSFWS
INTRENOInternal Key of Real Estate Object RECAINTRENOCHAR13RECAINTRENO
REVERSALIndicator for Reverse Posting Entered REYCREVERSALCHAR1RECABOOL
SWENRValid Site RESCPGBECHAR8Assigned to domainSWENRREBDBENOREBDBENOREBDBENO
SEASONALITYKEYSeasonality REYCSEASONKEYCHAR4REYCSEASON
ADJUSTMENTAdjustment Amount REYCISADJUSTAMTCURR15(2) WERTV8
AWREF_REVReversal: Reverse Document Reference Document Number AWREF_REVCHAR10ALPHAAWREF
KZChange Type (U, I, S, D) CDCHNGINDCHAR1CDCHNGIND

Key field Non-key field



How do I retrieve data from SAP structure AVIYCEXPITEM using ABAP code?

As AVIYCEXPITEM is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on AVIYCEXPITEM as there is no data to select.

How to access SAP table AVIYCEXPITEM

Within an ECC or HANA version of SAP you can also view further information about AVIYCEXPITEM and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!