J_3R_AO1 SAP (Gathered Data for Form Advance report AO-1) Structure details

Dictionary Type: Structure
Description: Gathered Data for Form Advance report AO-1




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




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

J_3R_AO1 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 "Gathered Data for Form Advance report AO-1" 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_J_3R_AO1 TYPE J_3R_AO1.

The J_3R_AO1 table consists of various fields, each holding specific information or linking keys about Gathered Data for Form Advance report AO-1 data available in SAP. These include FSD (), H01_ORG_NAME (Organization name), H02_STRUCDIV_NAME (Structural division name), H03_ADVREPNUM (Advance report number).. 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 (Deep)


SAP J_3R_AO1 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
ALV_TEXTShort Description of Repository Objects AS4TEXTCHAR60AS4TEXT
FSD 0
H01_ORG_NAMEOrganization name J_3RALCOMNAMECHAR160CHAR160
H02_STRUCDIV_NAME Structural division name0
H03_ADVREPNUMAdvance report number J_3R_ADVREPNUMCHAR10J_3R_FNR
H04_ADVREPDATEAdvance report date J_3R_ADVREPDATEDATS8DATS
H05_PERSNAMEReporting person J_3R_REP_PERSCHAR80CHAR80
H06_PERSPOSReporting person signature description J_3R_REP_PERS_POSCHAR30CHAR30
H07_STRUCDIVCost Center KOSTLCHAR10ALPHAKOSTLKOS
H08_PERNRPersonnel Number PERNR_DNUMC8PERNRPER
H09_ADVPURPPurpose of advance J_3R_ADV_PURPCHAR50TEXT50
H10_MANAGERPOSManager Position J_3R_MANAGER_POSCHAR30TEXT30
H11_MANAGERManager Name J_3R_MANAGER_NAMECHAR50CHAR50LOW
H12_CHFACCNTChief accountant J_3R_CHFACCNTCHAR50TEXT50
H13_ACCNTNAMEAccountant's Name J_3R_ACCNTNAMECHAR50TEXT50
H17_ACCNTCASHNAME Accountant cashier0
H14_OKPO OKPO0
H15_ADVSIGDATE Signing date0
H16_ADVREPDATE_TEXT Advance report date text0
A1_RESTVALUE Rest value of old advances0
A2_ODVALUE Overdraft value of old advances0
A3_ADAMNTLOCActual payed off advance amount in local currency J_3R_ADAMNT_LOCCURR13(2) WERT7
A4_ADCURR Advance currency0
A5_ADAMNT_FORActual payed off advance amount in foreign currency J_3R_ADAMNT_FORCURR13(2) WERT7
A6_ADTOTALActual advance balance J_3R_ADTOTALCURR13(2) WERT7
A7_RESTNEWRest value of advances J_3R_RESTVALUECURR13(2) WERT7
A8_ODNEWOverdraft value of advances J_3R_ODVALUECURR13(2) WERT7
LC_CURR Local currency0
B1_DEBACCNTDebit account J_3R_DEB_ACCTCHAR10ALPHASAKNR
B2_DEBAMNTDebit amount J_3R_DEB_AMNTCURR13(2) WERT7
B3_CREACCNTCredit account J_3R_CRE_ACCTCHAR10ALPHASAKNR
B4_CREAMNTCredit amount J_3R_CRE_AMNTCURR13(2) WERT7
AO_EXP_AMNT_LC_TTLAdvance report expense amount in local currency J_3R_AO_EXP_AMNT_LCCURR13(2) WERT7
ACC_EXP_AMOUNT_LC_TTLAccepted expense amount in local currency J_3R_ACC_EXP_AMOUNT_LCCURR13(2) WERT7
AO_EXP_AMNT_FC_TTLAdvance report expense amount in foreign currency J_3R_AO_EXP_AMNT_FCCURR13(2) WERT7
ACC_EXP_AMOUNT_FC_TTLAccepted expense amount in foreign currency J_3R_ACC_EXP_AMOUNT_FCCURR13(2) WERT7
EXPENSE_AMOUNT Expense amount0
EXPENSE_INTAMOUNT Expense integer amount0
EXPENSE_DECAMOUNT Expense decimal amount0
RETURN_DATE Return date0
RETURN_NUMBERCash Journal Document Number for Display CJBELNR_DISPCHAR10ALPHABELNR
RETURN_INTAMOUNT Return integer amount0
RETURN_DECAMOUNT Return decimal amount0
S2T 0
S1T 0
S1M 0
S1S 0

Key field Non-key field



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

As J_3R_AO1 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 J_3R_AO1 as there is no data to select.

How to access SAP table J_3R_AO1

Within an ECC or HANA version of SAP you can also view further information about J_3R_AO1 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!