ROIU_SB_CTR_MPWC SAP (Maintenance Structure: OIU_SB_CTRMP, CTRWC, CTROB) Structure details
Description: Maintenance Structure: OIU_SB_CTRMP, CTRWC, CTROB
Related tables to ROIU_SB_CTR_MPWC
Access table ROIU_SB_CTR_MPWC
Structure field list including key, data, relationships and ABAP select examples
ROIU_SB_CTR_MPWC 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 "Maintenance Structure: OIU_SB_CTRMP, CTRWC, CTROB" 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_ROIU_SB_CTR_MPWC TYPE ROIU_SB_CTR_MPWC.
The ROIU_SB_CTR_MPWC table consists of various fields, each holding specific information or linking keys about Maintenance Structure: OIU_SB_CTRMP, CTRWC, CTROB data available in SAP. These include UOMGR_DE (Description of the unit of measure group), OB_VOL_U (Observed Volume Unit), OB_VOL (Observed Volume), OB_TEMP_U (Unit of Temperature).. 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 ROIU_SB_CTR_MPWC 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 |
UOMGR | Gas Allocation Basis UOM | OIU_CA_UOMGR | CHAR | 3 | Assigned to domain | OIU_ME_UOMGR | OIU_UOMGR | ||
UOMGR_DE | Description of the unit of measure group | OIU_ME_UOMGR_TX | CHAR | 40 | TEXT40 | ||||
OB_VOL_U | Observed Volume Unit | OIU_OB_VOL_U | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
OB_VOL | Observed Volume | OIU_OB_VOL | QUAN | 13(3) | MENGE | ||||
OB_TEMP_U | Unit of Temperature | OIU_TEMP_U | UNIT | 3 | T006 | CUNIT | MEINS | ||
OB_TEMP | Temperature | OIU_TEMP | QUAN | 13(3) | MENGE | ||||
OB_PS_BASE_U | Observed Pressure Base Unit | OIU_OB_PS_BASE_U | UNIT | 3 | T006 | CUNIT | MEINS | ||
OB_PS_BASE | Observed Pressure Based Volume | OIU_OB_PS_BASE | QUAN | 13(3) | MENGE | ||||
OB_HEAT_VAL_U | Observed Heating Value Unit | OIU_OB_HEAT_VAL_U | UNIT | 3 | T006 | CUNIT | MEINS | ||
OB_HEAT_VAL | Observed Heating Value | OIU_OB_HEAT_VAL | QUAN | 13(3) | MENGE | ||||
OB_HEAT_VAL_TYP | Heating value class (calorific value class) | OIB_HVCLS | CHAR | 2 | OIB_HVCLS | ||||
OB_ENERGY_U | Oberserved Energy Unit | OIU_OB_ENERGY_U | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
OB_ENERGY | Observed Energy | OIU_OB_ENERGY | QUAN | 13(3) | MENGE | ||||
MANDT | Client | MANDT | CLNT | 3 | Assigned to domain | MANDT | |||
DN_NO | Delivery network number | OIU_DN_NO | CHAR | 20 | OIU_PR_DN | ALPHA | OIU_DN_NO | OIU_DN | H_OIU_PR_DN |
SA_DT | Sales date | OIU_SA_DT | DATS | 8 | DATS | OIU_PRD_DATE | |||
WL_NO | Well ID number | OIU_WL_NO | CHAR | 15 | OIU_PR_WELL | ALPHA | OIU_WL_NO | OIU_WELL | H_OIU_PR_WELL |
WC_NO | Well Completion Number | OIU_WC_NO | CHAR | 5 | OIU_PR_WC | ALPHA | OIU_WC_NO | OIU_WC | H_OIU_PR_WC |
ORIG_MP_NO | Original measurement point number | OIU_ORIG_MP_NO | CHAR | 20 | OIU_PR_MP | ALPHA | OIU_MP_NO | OIU_ORIG_MP_NO | |
TRNSP_NO | Transporter number | OIU_TRNSP_NO | CHAR | 10 | KNA1 | ALPHA | KUNNR | OIU_TRNSP_NO | |
MATNR | Material Number | MATNR | CHAR | 18 | OIU_CM_MAT_PRCD | MATN1 | MATNR | MAT | S_MAT1 |
FREQ_CD | Frequency | OIU_FREQ_CD | CHAR | 1 | OIU_FREQ_CD | OIU_FRQ | |||
CT_NO | Contract Number | OIU_CT_NO | CHAR | 10 | OIU_RV_CT | ALPHA | OIUCM_CONTRACT_NUMBER | OIU_CID | |
VC_CD | Volume class code | OIU_VC_CD | CHAR | 1 | OIU_VC_CD | OIU_VCCD | |||
STD_VOL_U | Standard volume unit | OIU_STD_VOL_U | UNIT | 3 | T006 | CUNIT | MEINS | ||
STD_VOL | Standard volume | OIU_STD_VOL | QUAN | 13(3) | MENGE | ||||
STD_HEAT_VAL_U | Standardized Heating Value Unit | OIU_STD_HEAT_VAL_U | UNIT | 3 | T006 | CUNIT | MEINS | ||
STD_HEAT_VAL | Standardized Heating Value | OIU_STD_HEAT_VAL | QUAN | 13(3) | MENGE | ||||
STD_ENERGY_U | Standard Energy UoM | OIU_STD_ENERGY_U | UNIT | 3 | T006 | CUNIT | MEINS | ||
STD_ENERGY | Standard Energy | OIU_STD_ENERGY | QUAN | 13(3) | MENGE | ||||
QY_U | Quantity Unit | OIU_QY_U | UNIT | 3 | T006 | CUNIT | MEINS | ||
ENTL_QY | Entitled Quantity | OIU_ENTL_QY | QUAN | 13(3) | MENGE | ||||
ADJ_ENTL_QY | Adjusted Entitlement (Volumetric or Energy) | OIU_ADJ_ENTL_QY | QUAN | 13(3) | MENGE | ||||
PHASE_1_QY | Phase One Allocation Energy Quantity | OIU_PHASE_1_QY | DEC | 13(3) | OIU_VOLUME_SIGN | ||||
PHASE_2_QY | Phase Two Allocation Energy Quantity | OIU_PHASE_2_QY | DEC | 13(3) | OIU_VOLUME_SIGN | ||||
PHASE_3_QY | Phase Three Allocation Energy Quantity | OIU_PHASE_3_QY | DEC | 13(3) | OIU_VOLUME_SIGN | ||||
PHASE_4_QY | Phase Four Allocation Energy Quantity | OIU_PHASE_4_QY | DEC | 13(3) | OIU_VOLUME_SIGN | ||||
PHASE_5_QY | Phase Five Allocation Energy Quantity | OIU_PHASE_5_QY | DEC | 13(3) | OIU_VOLUME_SIGN | ||||
ME_DOCNR | Meas. document number | OIU_ME_DOCNR | CHAR | 10 | ALPHA | BELNR | OIU_ME_DOCNR | ||
ME_DOCYR | Meas. document year | OIU_ME_DOCYR | NUMC | 4 | GJAHR | GJAHR | OIU_ME_DOCYR | ||
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 | ||||
MP_NO | Measurement point number | OIU_MP_NO | CHAR | 20 | Assigned to domain | ALPHA | OIU_MP_NO | OIU_MP | H_OIU_PR_MP |
MP_DE | Measurement point description | OIU_MP_DE | CHAR | 35 | OIU_TEXT35 | OIU_MP_DE | |||
DN_DE | Delivery network description | OIU_DN_DE | CHAR | 35 | OIU_TEXT35 | ||||
WC_NM | Well completion name | OIU_WC_NM | CHAR | 35 | OIU_TEXT35 | ||||
ORIG_MP_DE | Measurement point description | OIU_MP_DE | CHAR | 35 | OIU_TEXT35 | OIU_MP_DE | |||
CT_TYPE_CD | Contract Type | OIU_CT_TYPE_CD | CHAR | 2 | Assigned to domain | OIU_CT_TYPE_CD | OIU_CTY | ||
CT_TYPE_DE | Contract Type Description | OIU_CT_TYPE_DE | CHAR | 50 | OIU_TEXT50 | ||||
MK_REP_NO | Marketing Representative No | OIU_MK_REP_NO | CHAR | 10 | Assigned to domain | ALPHA | KUNNR | OIU_MK_REP | |
MK_REP_ISQ_NO | Marketing Representative Interest Sequence No | OIU_MK_REP_ISQ_NO | CHAR | 2 | ALPHA | OIU_MK_REP_ISQ_NO | OIU_MK_REP_ISQ | ||
MK_REP_NM | Name 1 | NAME1_GP | CHAR | 35 | NAME | ||||
DEST_SALE_CD | Plant Destination Of Product Sale Codes | OIU_DEST_SALE_CD | CHAR | 1 | OIU_DEST_SALE_CD | ||||
DEST_SALE_TX | Destination Sale Description | OIU_DEST_SALE_TX | CHAR | 10 | CHAR10 | ||||
TRNSP_NM | Name 1 | NAME1_GP | CHAR | 35 | NAME | ||||
MAKTX | Material Description (Short Text) | MAKTX | CHAR | 40 | TEXT40 | ||||
FREQ_CD_TX | Frequency Code Text | OIU_FREQ_CD_TX | CHAR | 16 | CHAR16 | ||||
SA_MONTH | Sales Month (YYYYMM) | OIU_SALES_MONTH | ACCP | 6 | PERI | OIU_SALE_DT | OIU_PM | ||
REF_SA_MONTH | Reference Sales Month (YYYYMM) | OIU_SALES_MONTH_REF | ACCP | 6 | PERI | OIU_SALE_DT | OIU_R_PM | ||
REF_SA_DT | Reference Production Date | OIU_PROD_DT_REF | DATS | 8 | DATUM | OIU_R_PRD_DATE | |||
REF_DN_NO | Reference delivery network number | OIU_DN_NO_REF | CHAR | 20 | Assigned to domain | ALPHA | OIU_DN_NO | OIU_DN_REF | |
REF_DN_DE | Delivery network description | OIU_DN_DE | CHAR | 35 | OIU_TEXT35 | ||||
REF_WL_NO | Reference well ID number | OIU_WL_NO_REF | CHAR | 15 | Assigned to domain | ALPHA | OIU_WL_NO | OIU_R_WELL | |
REF_WC_NO | Reference well completion number | OIU_WC_NO_REF | CHAR | 5 | Assigned to domain | ALPHA | OIU_WC_NO | OIU_R_WC | |
REF_WC_NM | Well completion name | OIU_WC_NM | CHAR | 35 | OIU_TEXT35 | ||||
REF_MP_NO | Reference measurement point number | OIU_MP_NO_REF | CHAR | 20 | Assigned to domain | ALPHA | OIU_MP_NO | OIU_R_MP | |
REF_MP_DE | Measurement point description | OIU_MP_DE | CHAR | 35 | OIU_TEXT35 | OIU_MP_DE | |||
REF_ORIG_MP_NO | Referenced Originating Measurement Point | OIU_ORIG_MP_NO_REF | CHAR | 20 | Assigned to domain | ALPHA | OIU_MP_NO | OIU_ORIG_MP_NO_REF | |
REF_ORIG_MP_DE | Measurement point description | OIU_MP_DE | CHAR | 35 | OIU_TEXT35 | OIU_MP_DE | |||
REF_FREQ_CD | Reference Frequency code | OIU_FREQ_CD_REF | CHAR | 1 | OIU_FREQ_CD | OIU_R_FRQ | |||
REF_FREQ_CD_TX | Frequency Code Text | OIU_FREQ_CD_TX | CHAR | 16 | CHAR16 | ||||
REF_MATNR | Reference material | REF_MATNR | CHAR | 18 | Assigned to domain | MATN1 | MATNR | RMA | MAT1 |
REF_MAKTX | Material Description (Short Text) | MAKTX | CHAR | 40 | TEXT40 | ||||
REF_TRNSP_NO | Reference Transporter number | OIU_TRNSP_NO_REF | CHAR | 10 | Assigned to domain | ALPHA | KUNNR | OIU_R_TRNSP_NO | |
REF_TRNSP_NM | Name | NAME1 | CHAR | 30 | TEXT30 | ||||
BASE_DENSITY | Observed Denisty | OIU_OB_DENSITY | QUAN | 13(3) | MENGE | ||||
BASE_DENSITY_U | Unit for densities at standard/base conditions | OIB_BDNEH | UNIT | 3 | T006 | CUNIT | MEINS | ||
DENTYP | Density Type | OIB_DNTYP | CHAR | 1 | OIB_DNTYP | ||||
XXDBACTION | Database Action Flag | OIU_DBACTION | CHAR | 1 | CHAR1 | ||||
MSEHI | Unit of Measurement | MSEHI | UNIT | 3 | Assigned to domain | CUNIT | MEINS |
Key field | Non-key field |
How do I retrieve data from SAP structure ROIU_SB_CTR_MPWC using ABAP code?
As ROIU_SB_CTR_MPWC 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 ROIU_SB_CTR_MPWC as there is no data to select.How to access SAP table ROIU_SB_CTR_MPWC
Within an ECC or HANA version of SAP you can also view further information about ROIU_SB_CTR_MPWC 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