ROIR_HLM_ALV1 SAP (Item Values for Location Master) Structure details
Description: Item Values for Location Master
Related tables to ROIR_HLM_ALV1
Access table ROIR_HLM_ALV1
Structure field list including key, data, relationships and ABAP select examples
ROIR_HLM_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 "Item Values for Location Master" 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_ROIR_HLM_ALV1 TYPE ROIR_HLM_ALV1.
The ROIR_HLM_ALV1 table consists of various fields, each holding specific information or linking keys about Item Values for Location Master data available in SAP. These include PBLNR (Business location identifier (IS-Oil MRN)), OBJPOS (Object counter), PARFN_PR (MRN business partner role / relation type), PARSTX_PR (Partner role short text (IS-Oil MRN)).. 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 ROIR_HLM_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 |
MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
PBLNR | Business location identifier (IS-Oil MRN) | OIF_PBLNR | CHAR | 10 | Assigned to domain | ALPHA | OIF_PBLNR | OI0 | OIFB |
OBJPOS | Object counter | OIF_OBJPOS | NUMC | 3 | OIF_OBJPOS | ||||
PARFN_PR | MRN business partner role / relation type | OIF_PARFN | CHAR | 4 | Assigned to domain | OIF_PARFN | |||
PARSTX_PR | Partner role short text (IS-Oil MRN) | OIF_PARSTX | CHAR | 15 | TXT15 | ||||
FTMDAT_PR | Partner role validity period: Start date (IS-Oil MRN) | OIF_FTMDAT | DATS | 8 | DATS | ||||
FTMTIM_PR | Partner role validity period - Start time (IS-Oil MRN) | OIF_FTMTIM | TIMS | 6 | TIME | ||||
TTMDAT_PR | Partner role validity period - end date (IS-Oil MRN) | OIF_TTMDAT | DATS | 8 | DATS | ||||
TTMTIM_PR | Partner role validity period - end time (IS-Oil MRN) | OIF_TTMTIM | TIMS | 6 | TIME | ||||
PARPOS_PR | Partner counter | OIF_PARPOS | NUMC | 3 | OIF_PARPOS | ||||
PARTNR_PR | Business partner ID (common) - IS-Oil MRN | OIF_PARTNR | CHAR | 10 | TEXT10 | ||||
PARNAM_PR | Partner name from business partner record (IS-Oil MRN) | OIF_PARNAM | CHAR | 35 | NAME | ||||
BLOIND_PR | Block Indicator | OIF_BLOIND | CHAR | 1 | XFELD | ||||
DELIND_PR | Deletion indicator | OIF_DELIND | CHAR | 1 | XFELD | ||||
PBEZ_PR | Relationship percentage | OIF_PBEZ | DEC | 10(7) | DEC3_7 | ||||
BBEZ_PR | Relationship amount | OIF_BBEZ | CURR | 13(2) | OIF_CURR13 | ||||
SBBEZ_PR | Currency Key | WAERS | CUKY | 5 | Assigned to domain | WAERS | FWS | ||
PARTC_PR | Technical characteristic for partner role | OIF_PARTC | CHAR | 2 | Assigned to domain | OIF_PARTC | |||
GENPAR_PR | Partner entry generated for role: IS-Oil MRN | OIF_GENPAR | CHAR | 1 | XFELD | ||||
GENINS_PR | Suppress location entry generation in partner - IS-Oil MRN | OIF_GENINS | CHAR | 1 | XFELD | ||||
MANDEL_PR | Location entry in partner was manually deleted (IS-Oil MRN) | OIF_MANDEL | CHAR | 1 | XFELD | ||||
VKORG_PR | Sales Organization | VKORG | CHAR | 4 | Assigned to domain | VKORG | VKO | C_VKORG | |
VTWEG_PR | Distribution Channel | VTWEG | CHAR | 2 | Assigned to domain | VTWEG | VTW | C_VTWEG | |
SPART_PR | Division | SPART | CHAR | 2 | Assigned to domain | SPART | SPA | C_SPART | |
ERDAT_PR | Date Record Created on (Date) | OIF_ERDAT | DATS | 8 | DATS | ||||
ERZEIT_PR | Time Record Created at (Time) | OIF_ERZEIT | TIMS | 6 | TIME | ||||
ERNAM_PR | User who Created Record | OIF_ERNAM | CHAR | 12 | USNAM | ||||
AEDAT_PR | Date Record Changed on (Date) | OIF_AEDAT | DATS | 8 | DATS | ||||
AEZEIT_PR | Time when Record Was Changed | OIF_AEZEIT | TIMS | 6 | TIME | ||||
AENAM_PR | User who Changed Record | OIF_AENAM | CHAR | 12 | USNAM | ||||
PSPID_PW | Project Definition | PS_PSPID | CHAR | 24 | ABPSN | PS_PSPID | PSP | PD_DUMMY | |
POSID_PW | Work Breakdown Structure Element (WBS Element) | PS_POSID | CHAR | 24 | PROJN | PS_POSID | PRO | ||
AUFNR_OR | Order Number | AUFNR | CHAR | 12 | Assigned to domain | ALPHA | AUFNR | ANR | |
KTEXT_OR | Description | AUFTEXT | CHAR | 40 | TEXT40 | ||||
AUART_OR | Order Type | AUFART | CHAR | 4 | Assigned to domain | AUFART | AAT | ||
TXT_OR | Text, 40 Characters Long | TEXT40 | CHAR | 40 | TEXT40 | ||||
CCINS_PC | Payment cards: Card type | CCINS | CHAR | 4 | Assigned to domain | CCINS | |||
DATAB_PC | Payment cards: Valid from | DATAB_CC | DATS | 8 | DATUM | ||||
DATBI_PC | Payment Cards: Valid To | DATBI_CC | DATS | 8 | DATUM | ||||
BUKRS_PC | Company Code | BUKRS | CHAR | 4 | Assigned to domain | BUKRS | BUK | C_T001 | |
BLPLACE_PC | SSR PC: Black list storage place | OIRE_BLPLACE | CHAR | 2 | Assigned to domain | OIRE_BLPLACE | |||
BLCHK_PC | SSR PC: Black list check amount | OIRE_BLCHK | CURR | 15(2) | OIRE_BLCHK | ||||
CHCHK_PC | SSR PC: Clearing house check amount | OIRE_CHCHK | CURR | 15(2) | OIRE_CHCHK | ||||
WAERS_PC | Currency Key | WAERS | CUKY | 5 | Assigned to domain | WAERS | FWS | ||
REASON_PC | SSR PC: Block reason | OIRE_REASON | NUMC | 3 | OIRE_REASON | ||||
SETTLID_PC | Factory Calendar | WFCID | CHAR | 2 | Assigned to domain | WFCID | FCI | ||
SSMID_PC | SSR PC: Service station merchant ID | OIRE_SSMID | CHAR | 20 | OIRE_SSMID | ||||
SSMIDTX_PC | SSR PC: Service station merchant ID text | OIRE_SSMIDTX | CHAR | 50 | OIRE_SSMIDTX | ||||
PCGROUP_PC | Location Payment Card Grouping | OIRE_LPCGROUP | CHAR | 4 | Assigned to domain | OIRE_LPCGROUP | |||
ERDAT_PC | Date Record Created on (Date) | OIF_ERDAT | DATS | 8 | DATS | ||||
ERTIM_PC | Time Record Created at (Time) | OIF_ERZEIT | TIMS | 6 | TIME | ||||
ERNAM_PC | User who Created Record | OIF_ERNAM | CHAR | 12 | USNAM | ||||
AEDAT_PC | Date Record Changed on (Date) | OIF_AEDAT | DATS | 8 | DATS | ||||
AETIM_PC | Time when Record Was Changed | OIF_AEZEIT | TIMS | 6 | TIME | ||||
AENAM_PC | User who Changed Record | OIF_AENAM | CHAR | 12 | USNAM |
Key field | Non-key field |
How do I retrieve data from SAP structure ROIR_HLM_ALV1 using ABAP code?
As ROIR_HLM_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 ROIR_HLM_ALV1 as there is no data to select.How to access SAP table ROIR_HLM_ALV1
Within an ECC or HANA version of SAP you can also view further information about ROIR_HLM_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