OIUH_AFRVTSTSLBYQBE SAP (Structure For Statistical Subledger Query) Structure details

Dictionary Type: Structure
Description: Structure For Statistical Subledger Query




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




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

OIUH_AFRVTSTSLBYQBE 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 "Structure For Statistical Subledger Query" 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_OIUH_AFRVTSTSLBYQBE TYPE OIUH_AFRVTSTSLBYQBE.

The OIUH_AFRVTSTSLBYQBE table consists of various fields, each holding specific information or linking keys about Structure For Statistical Subledger Query data available in SAP. These include C_GL_OR_LVL_1_NO (OIUH_CHAR3), C_OR1_OR_LVL_1_NM (OIUH_CHAR40), C_GL_ACCT_PERD_DT (OIUH_CHAR10), C_GL_ACCT_NO (OIUH_CHAR10).. 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 OIUH_AFRVTSTSLBYQBE 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
C_GL_GL_SYS_NOOIUH_DEC18 OIUH_DEC18DEC18DEC18
C_GL_OR_LVL_1_NOOIUH_CHAR3 OIUH_CHAR3CHAR3CHAR3
C_OR1_OR_LVL_1_NMOIUH_CHAR40 OIUH_CHAR40CHAR40CHAR40
C_GL_ACCT_PERD_DTOIUH_CHAR10 OIUH_CHAR10CHAR10CHAR10H_OIU_RV_CT
C_GL_ACCT_NOOIUH_CHAR10 OIUH_CHAR10CHAR10CHAR10H_OIU_RV_CT
C_COA_ACCT_NMOIUH_CHAR30 OIUH_CHAR30CHAR30CHAR30
C_GL_TRANS_AMJE Transaction Amount OIUH_TRANS_AMTCURR11(2) OIUH_CURR11_2
C_GL_TRANS_QYJE Transaction Quantity OIUH_TRANS_QUANTITYDEC11(2) OIUH_DEC11_2
C_GL_GR_AMGross Amount (Value) OIUH_GROSS_AMOUNTCURR11(2) OIUH_CURR11_2
C_GL_GR_QYGross Quantity OIUH_GROSS_QTYDEC11(2) OIUH_DEC11_2
C_GL_WL_NOOIUH_CHAR6 OIUH_CHAR6CHAR6CHAR6
C_GL_WC_NOOIUH_CHAR2 OIUH_CHAR2CHAR2CHAR2
C_WC_WC_NMOIUH_CHAR35 OIUH_CHAR35CHAR35CHAR35
C_GL_PR_NOOIUH_CHAR8 OIUH_CHAR8CHAR8CHAR8
C_GL_DOI_NOOIUH_CHAR5 OIUH_CHAR5CHAR5CHAR5
C_DI_DI_NMOIUH_CHAR30 OIUH_CHAR30CHAR30CHAR30
C_GL_PD_CDOIUH_CHAR3 OIUH_CHAR3CHAR3CHAR3
C_A_TT_ELEM_DEOIUH_CHAR50 OIUH_CHAR50CHAR50CHAR50
C_GL_SA_DTOIUH_CHAR10 OIUH_CHAR10CHAR10CHAR10H_OIU_RV_CT
C_GL_CT_NOContract ID OIUH_CONTRACT_IDCHAR6CHAR6
C_GL_CT_TYPE_CDOIUH_CHAR2 OIUH_CHAR2CHAR2CHAR2
C_B_TT_ELEM_DEOIUH_CHAR50 OIUH_CHAR50CHAR50CHAR50
C_GL_DN_NOOIUH_CHAR4 OIUH_CHAR4CHAR4CHAR4
C_GL_SUB_NWK_NOOIUH_CHAR4 OIUH_CHAR4CHAR4CHAR4
C_DN_DN_DEOIUH_CHAR25 OIUH_CHAR25CHAR25CHAR25
C_C_TT_ELEM_DEOIUH_CHAR50 OIUH_CHAR50CHAR50CHAR50
C_STSL_OWN_NOOIUH_CHAR6 OIUH_CHAR6CHAR6CHAR6
C_STSL_OWN_SEQ_NOOIUH_CHAR2 OIUH_CHAR2CHAR2CHAR2
C_BA_NM_1OIUH_CHAR38 OIUH_CHAR38CHAR38CHAR38
C_STSL_PRDR_NOOIUH_CHAR6 OIUH_CHAR6CHAR6CHAR6
C_STSL_PRDR_SEQ_NOOIUH_CHAR2 OIUH_CHAR2CHAR2CHAR2
C_STSL_OWN_INT_DECM_QYOIUH_DEC9_8 OIUH_DEC9_8DEC9(8) OIUH_DEC9_8
C_STSL_OWN_INT_TYPE_CDOIUH_CHAR2 OIUH_CHAR2CHAR2CHAR2
C_STSL_OWN_INT_SEQ_NOOIUH_CHAR2 OIUH_CHAR2CHAR2CHAR2
C_D_TT_ELEM_DEOIUH_CHAR50 OIUH_CHAR50CHAR50CHAR50
C_E_TT_ELEM_DEOIUH_CHAR50 OIUH_CHAR50CHAR50CHAR50
C_F_TT_ELEM_DEOIUH_CHAR50 OIUH_CHAR50CHAR50CHAR50
C_G_TT_ELEM_DEOIUH_CHAR50 OIUH_CHAR50CHAR50CHAR50
C_STSL_OWN_BAL_DECM_QYOIUH_DEC9_8 OIUH_DEC9_8DEC9(8) OIUH_DEC9_8
C_STSL_NET_TRANSP_AMLocal amount OIUH_CURR11_2CURR11(2) OIUH_CURR11_2
C_STSL_NET_OTH_MK_AMLocal amount OIUH_CURR11_2CURR11(2) OIUH_CURR11_2
C_STSL_AES_FLOIUH_CHAR1 OIUH_CHAR1CHAR1CHAR1
C_H_TT_ELEM_DEOIUH_CHAR50 OIUH_CHAR50CHAR50CHAR50
C_STSL_TXN_VAL_AMLocal amount OIUH_CURR11_2CURR11(2) OIUH_CURR11_2
C_STSL_GR_PVR_AMOIUH_DEC11_2 OIUH_DEC11_2DEC11(2) OIUH_DEC11_2
C_STSL_OWN_PVR_AMOIUH_DEC11_2 OIUH_DEC11_2DEC11(2) OIUH_DEC11_2
C_STSL_RBUR_DECM_PCOIUH_DEC9_8 OIUH_DEC9_8DEC9(8) OIUH_DEC9_8
C_K_TT_ELEM_DEOIUH_CHAR50 OIUH_CHAR50CHAR50CHAR50
C_GL_SA_MP_NOOIUH_CHAR60 OIUH_CHAR60CHAR60CHAR60
C_MP_MP_DEOIUH_CHAR30 OIUH_CHAR30CHAR30CHAR30
C_LEDGER_LEVELOIUH_CHAR18 OIUH_CHAR18CHAR18CHAR18
C_GL_PR_DOI_NOOIUH_CHAR14 OIUH_CHAR14CHAR14CHAR14
C_GL_DN_SUB_NWK_NOOIUH_CHAR9 OIUH_CHAR9CHAR9CHAR9
O_INT_1_AMOwner internal mkt amt 1 OIU_O_INT_1_AMCURR11(2) OIUH_CURR11_2
O_INT_2_AMOwner internal mkt amt 2 OIU_O_INT_2_AMCURR11(2) OIUH_CURR11_2
O_INT_3_AMOwner internal mkt amt 3 OIU_O_INT_3_AMCURR11(2) OIUH_CURR11_2
O_INT_4_AMOwner internal mkt amt 4 OIU_O_INT_4_AMCURR11(2) OIUH_CURR11_2
O_INT_5_AMOwner internal mkt amt 5 OIU_O_INT_5_AMCURR11(2) OIUH_CURR11_2
O_INT_6_AMOwner internal mkt amt 6 OIU_O_INT_6_AMCURR11(2) OIUH_CURR11_2
O_INT_7_AMOwner internal mkt amt 7 OIU_O_INT_7_AMCURR11(2) OIUH_CURR11_2
O_INT_8_AMOwner internal mkt amt 8 OIU_O_INT_8_AMCURR11(2) OIUH_CURR11_2
O_INT_9_AMOwner internal mkt amt 9 OIU_O_INT_9_AMCURR11(2) OIUH_CURR11_2
O_INT_10_AMOwner internal mkt amt10 OIU_O_INT_10_AMCURR11(2) OIUH_CURR11_2
O_EXT_1_AMOwner external mkt amt 1 OIU_O_EXT_1_AMCURR11(2) OIUH_CURR11_2
O_EXT_2_AMOwner external mkt amt 2 OIU_O_EXT_2_AMCURR11(2) OIUH_CURR11_2
O_EXT_3_AMOwner external mkt amt 3 OIU_O_EXT_3_AMCURR11(2) OIUH_CURR11_2
O_EXT_4_AMOwner external mkt amt 4 OIU_O_EXT_4_AMCURR11(2) OIUH_CURR11_2
O_EXT_5_AMOwner external mkt amt 5 OIU_O_EXT_5_AMCURR11(2) OIUH_CURR11_2
O_EXT_6_AMOwner external mkt amt 6 OIU_O_EXT_6_AMCURR11(2) OIUH_CURR11_2
O_EXT_7_AMOwner external mkt amt 7 OIU_O_EXT_7_AMCURR11(2) OIUH_CURR11_2
O_EXT_8_AMOwner external mkt amt 8 OIU_O_EXT_8_AMCURR11(2) OIUH_CURR11_2
O_EXT_9_AMOwner external mkt amt 9 OIU_O_EXT_9_AMCURR11(2) OIUH_CURR11_2
O_EXT_10_AMOwner external mkt amt10 OIU_O_EXT_10_AMCURR11(2) OIUH_CURR11_2
G_INT_1_AMGross internal mkt amt 1 OIU_G_INT_1_AMCURR11(2) OIUH_CURR11_2
G_INT_2_AMGross internal mkt amt 2 OIU_G_INT_2_AMCURR11(2) OIUH_CURR11_2
G_INT_3_AMGross internal mkt amt 3 OIU_G_INT_3_AMCURR11(2) OIUH_CURR11_2
G_INT_4_AMGross internal mkt amt 4 OIU_G_INT_4_AMCURR11(2) OIUH_CURR11_2
G_INT_5_AMGross internal mkt amt 5 OIU_G_INT_5_AMCURR11(2) OIUH_CURR11_2
G_INT_6_AMGross internal mkt amt 6 OIU_G_INT_6_AMCURR11(2) OIUH_CURR11_2
G_INT_7_AMGross internal mkt amt 7 OIU_G_INT_7_AMCURR11(2) OIUH_CURR11_2
G_INT_8_AMGross internal mkt amt 8 OIU_G_INT_8_AMCURR11(2) OIUH_CURR11_2
G_INT_9_AMGross internal mkt amt 9 OIU_G_INT_9_AMCURR11(2) OIUH_CURR11_2
G_INT_10_AMGross internal mkt amt10 OIU_G_INT_10_AMCURR11(2) OIUH_CURR11_2
G_EXT_1_AMGross external mkt amt 1 OIU_G_EXT_1_AMCURR11(2) OIUH_CURR11_2
G_EXT_2_AMGross external mkt amt 2 OIU_G_EXT_2_AMCURR11(2) OIUH_CURR11_2
G_EXT_3_AMGross external mkt amt 3 OIU_G_EXT_3_AMCURR11(2) OIUH_CURR11_2
G_EXT_4_AMGross external mkt amt 4 OIU_G_EXT_4_AMCURR11(2) OIUH_CURR11_2
G_EXT_5_AMGross external mkt amt 5 OIU_G_EXT_5_AMCURR11(2) OIUH_CURR11_2
G_EXT_6_AMGross external mkt amt 6 OIU_G_EXT_6_AMCURR11(2) OIUH_CURR11_2
G_EXT_7_AMGross external mkt amt 7 OIU_G_EXT_7_AMCURR11(2) OIUH_CURR11_2
G_EXT_8_AMGross external mkt amt 8 OIU_G_EXT_8_AMCURR11(2) OIUH_CURR11_2
G_EXT_9_AMGross external mkt amt 9 OIU_G_EXT_9_AMCURR11(2) OIUH_CURR11_2
G_EXT_10_AMGross external mkt amt 10 OIU_G_EXT_10_AMCURR11(2) OIUH_CURR11_2

Key field Non-key field



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

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

How to access SAP table OIUH_AFRVTSTSLBYQBE

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