ROIUPR_ARCH_ALVOL_RD_ALV1 SAP (Strucutre for ROIUPR_ARCH_ALVOL_RD) Structure details
Description: Strucutre for ROIUPR_ARCH_ALVOL_RD
Related tables to ROIUPR_ARCH_ALVOL_RD_ALV1
Access table ROIUPR_ARCH_ALVOL_RD_ALV1
Structure field list including key, data, relationships and ABAP select examples
ROIUPR_ARCH_ALVOL_RD_ALV1 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 "Strucutre for ROIUPR_ARCH_ALVOL_RD" 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_ROIUPR_ARCH_ALVOL_RD_ALV1 TYPE ROIUPR_ARCH_ALVOL_RD_ALV1.
The ROIUPR_ARCH_ALVOL_RD_ALV1 table consists of various fields, each holding specific information or linking keys about Strucutre for ROIUPR_ARCH_ALVOL_RD data available in SAP. These include DOC_YEAR (Fiscal Year), WL_NO (Well ID number), WC_NO (Well Completion Number), DN_NO (Delivery network 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 (character-type or numeric)
SAP ROIUPR_ARCH_ALVOL_RD_ALV1 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 |
WCDVLH_NO | Well Completion Delivery Volume Header Number | OIU_WCDVLH_NO | CHAR | 10 | ALPHA | OIU_DOCNR | OIU_DOCNR | ||
DOC_YEAR | Fiscal Year | GJAHR | NUMC | 4 | GJAHR | GJAHR | GJR | ||
WL_NO | Well ID number | OIU_WL_NO | CHAR | 15 | Assigned to domain | ALPHA | OIU_WL_NO | OIU_WELL | H_OIU_PR_WELL |
WC_NO | Well Completion Number | OIU_WC_NO | CHAR | 5 | Assigned to domain | ALPHA | OIU_WC_NO | OIU_WC | H_OIU_PR_WC |
DN_NO | Delivery network number | OIU_DN_NO | CHAR | 20 | Assigned to domain | ALPHA | OIU_DN_NO | OIU_DN | H_OIU_PR_DN |
EFF_FROM_DT | Effective from date | OIU_EFF_FROM_DT | DATS | 8 | DATUM | OIU_EFD | |||
EFF_TO_DT | Effective To Date | OIU_EFF_TO_DT | DATS | 8 | DATUM | OIU_ETD | |||
PRD_DT | Production date | OIU_PRD_DT | DATS | 8 | DATUM | OIU_PRD_DATE | |||
PRD_MATNR | Production Material | OIU_PRD_MATNR | CHAR | 18 | Assigned to domain | MATN1 | MATNR | OIU_PRD_MATNR | H_OIU_CM_MAT |
MATNR | Material Number | MATNR | CHAR | 18 | Assigned to domain | MATN1 | MATNR | MAT | S_MAT1 |
FREQ_CD | Frequency | OIU_FREQ_CD | CHAR | 1 | OIU_FREQ_CD | OIU_FRQ | |||
TKBTRY_MP_NO | Tank battery measurement point number | OIU_TKBTRY_MP_NO | CHAR | 20 | Assigned to domain | ALPHA | OIU_MP_NO | ||
VT_CD | Volume type code | OIU_VT_CD | CHAR | 2 | Assigned to domain | OIU_VL_TYPE_CD | OIU_VTCD | ||
VC_CD | Volume class code | OIU_VC_CD | CHAR | 1 | OIU_VC_CD | OIU_VCCD | |||
VS_CD | Volume Source Code | OIU_VS_CD | CHAR | 1 | Assigned to domain | OIU_VS_CD | OIU_VS_CD | ||
TRNSP_NO | Transporter number | OIU_TRNSP_NO | CHAR | 10 | Assigned to domain | ALPHA | KUNNR | OIU_TRNSP_NO | |
TRNSP_REF_NO | Transporter Reference Number | OIU_TRNSP_REF_NO | CHAR | 25 | OIU_TEXT25 | OIU_TRNSP_R | |||
REC_TYPE_CD | Record type code | OIU_REC_TYPE_CD | CHAR | 4 | OIU_REC_TYPE_CD | ||||
DAYS_PROD | Days produced | OIU_DAYS_PROD | NUMC | 2 | OIU_DAYS_PROD | ||||
PRD_HRS | Production hours | OIU_PRD_HRS | NUMC | 3 | OIU_PRD_HRS | ||||
TKT_NO | Ticket number | OIU_TKT_NO | CHAR | 7 | OIU_TKT_NO | OIU_TKT_NO | |||
TKT_TIMESTAMP | Ticket Timestamp (Date) | OIU_TKT_TIMESTP | DEC | 15 | TZNTSTMPS | ||||
ORIG_MP_NO | Original measurement point number | OIU_ORIG_MP_NO | CHAR | 20 | Assigned to domain | ALPHA | OIU_MP_NO | OIU_ORIG_MP_NO | |
ORIG_MP_DOC_NO | Original MP document no | OIU_ORIG_MP_DOC_NO | CHAR | 10 | ALPHA | BELNR | |||
ORIG_MP_DOC_YEAR | Original document year | OIU_ORIG_MP_DOC_YEAR | NUMC | 4 | GJAHR | GJAHR | |||
THEO_U | Theoretical Unit | OIU_THEO_U | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
THEO | Theoretical Volume | OIU_THEO | QUAN | 13(3) | MENGE | ||||
CONV_GRP | Conversion Group (Oil, Natural Gas,..) | OIB_UMRSL | CHAR | 4 | Assigned to domain | OIB_UMRSL | |||
STD_VOL_U | Standard volume unit | OIU_STD_VOL_U | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
STD_VOL | Standard volume | OIU_STD_VOL | QUAN | 13(3) | MENGE | ||||
ENERGY_U | Energy quantity unit | OIU_ENERGY_U | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
ENERGY | Energy quantity | OIU_ENERGY | QUAN | 13(3) | MENGE | ||||
HEAT_VAL_U | Heating Value Unit | OIU_HEAT_VAL_U | UNIT | 3 | Assigned to domain | CUNIT | MEINS | OUMH | |
HEAT_VAL | Heating value | OIU_HEAT_VAL | QUAN | 13(3) | MENGE | ||||
BASE_DENSITY | Oil/gas density at standard/base conditions | OIB_BDICH | FLTP | 16(16) | OIB_DICHT | ||||
BASE_DENSITY_U | Unit for densities at standard/base conditions | OIB_BDNEH | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
DENTYP | Density Type | OIB_DNTYP | CHAR | 1 | OIB_DNTYP | ||||
MOL_VOLUME | Gas mol volume | OIU_MOL_VOLUME | QUAN | 13(3) | MENGE | ||||
INVT_DT | Inventory date | OIU_INV_DT | DATS | 8 | DATUM | ||||
XREF_WL_NO | Cross-Reference Well Number | OIU_XREF_WL_NO | CHAR | 15 | Assigned to domain | ALPHA | OIU_WL_NO | ||
XREF_WC_NO | Cross-Reference Wellcompletion Number | OIU_XREF_WC_NO | CHAR | 5 | Assigned to domain | ALPHA | OIU_WC_NO | ||
ORIG_NO | Original WCDVL No (Well Completion Daily Volume) | OIU_ORIG_NO | NUMC | 12 | OIU_SYS_NO | ||||
ORIG_DOC_YEAR | Fiscal Year | GJAHR | NUMC | 4 | GJAHR | GJAHR | GJR | ||
OIU_CRUSER | Name of Person who Created the Object | ERNAM | CHAR | 12 | USNAM | ||||
OIU_TIMESTAMP | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | TZNTSTMPS | DEC | 15 | TZNTSTMPS |
Key field | Non-key field |
How do I retrieve data from SAP structure ROIUPR_ARCH_ALVOL_RD_ALV1 using ABAP code?
As ROIUPR_ARCH_ALVOL_RD_ALV1 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 ROIUPR_ARCH_ALVOL_RD_ALV1 as there is no data to select.How to access SAP table ROIUPR_ARCH_ALVOL_RD_ALV1
Within an ECC or HANA version of SAP you can also view further information about ROIUPR_ARCH_ALVOL_RD_ALV1 and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects