ROXXB40071 SAP (Generated Table for View V_RFMATGRP_MD9) Structure details

Dictionary Type: Structure
Description: Generated Table for View V_RFMATGRP_MD9




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




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

ROXXB40071 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 "Generated Table for View V_RFMATGRP_MD9" 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_ROXXB40071 TYPE ROXXB40071.

The ROXXB40071 table consists of various fields, each holding specific information or linking keys about Generated Table for View V_RFMATGRP_MD9 data available in SAP. These include NODE (Hierarchy Node), DATE_FROM (Validity Start Date of Assignment in Article Hierarchy), DATE_TO (Validity End Date of Assignment in Article Hierarchy), ROLE (Category Role).. 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: Not classified


SAP ROXXB40071 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
MANDTClient MANDTCLNT3T000MANDT
NODEHierarchy Node WRF_STRUC_NODECHAR18WRF_NODESRTNODEWRF_MATGRP_CSHLP
DATE_FROMValidity Start Date of Assignment in Article Hierarchy WRF_DATE_FROMDATS8DATSRTDAY
DATE_TOValidity End Date of Assignment in Article Hierarchy WRF_DATE_TODATS8DATS
ROLECategory Role WRF_CATROLECHAR20WRF_MATGRP_ROLEWRF_CDT_ROLEWRF_MATGRP_ROLE
STRATEGYNode Strategy WRF_CATSTRATEGYCHAR20WRF_MATGRP_STRAWRF_CDT_STRATEGYWRF_MATGRP_STRATEGY
HIER_IDHierarchy WRF_HIER_CNTCHAR2WRF_MATGRP_HIERWRF_HIERCNTRTHIERWRF_HIERID_STATUS
PARENTHierarchy Node WRF_STRUC_NODECHAR18WRF_NODESRTNODEWRF_MATGRP_CSHLP
HIERNODE1Hierarchy Node 1 WRF_HIER_NODE1CHAR18WRF_CM_CDT
HIERNODE2Hierarchy Node 2 WRF_HIER_NODE2CHAR18WRF_CM_CDT
HIERNODE3Hierarchy Node 3 WRF_HIER_NODE3CHAR18WRF_CM_CDT
HIERNODE4Hierarchy Node 4 WRF_HIER_NODE4CHAR18WRF_CM_CDT
HIERNODE5Hierarchy Node 5 WRF_HIER_NODE5CHAR18WRF_CM_CDT
HIERNODE6Hierarchy Node 6 WRF_HIER_NODE6CHAR18WRF_CM_CDT
HIERNODE7Hierarchy Node 7 WRF_HIER_NODE7CHAR18WRF_CM_CDT
HIERNODE8Hierarchy Node 8 WRF_HIER_NODE8CHAR18WRF_CM_CDT
VKORGSales Organization VKORGCHAR4Assigned to domainVKORGVKOC_VKORG
VTWEGDistribution Channel VTWEGCHAR2Assigned to domainVTWEGVTWC_VTWEG
TREE_LEVELHierarchy Level WRF_CDT_LEVELNUMC2NUMC2RTLEVELWRF_TREE_LEVEL
SHLFSPCCM: Shelf Space WRF_CM_SHFSPCQUAN9(3) MENG9
LINSPCCM: Contact Area WRF_CM_LINSPCQUAN9(3) MENG9
SPACEUNITCM: Shelf-Space Unit WRF_CM_SPCUNITUNIT3T006CUNITMEINS
LINUNITCM: Unit of Contact Area WRF_CM_LINUNITUNIT3T006CUNITMEINS
STORESCM: Number of Stores with Articles from the Category WRF_CM_STORESNUMC9NUM9
CHKDATECM: Space Management Key Date WRF_CM_CHKDATEDATS8DATE
TIMESTAMPUTC Time Stamp in Short Form (YYYYMMDDhhmmss) RSTIMESTMPDEC15TZNTSTMPS
DELETEFLAGDeletion Indicator WRF_DELETECHAR1WRF_DELE
EPRGRPrice point group EPRGRCHAR6TWPKEPRGREPG
PRODUCTCLFGoods Schedule Line WRF_PRDCLFCHAR2WRF_PRDCLF
PRICE_GROUPPrice Level Group PRICE_GROUPCHAR6WRF_PRGRPPRICE_GROUP
REFERENCEReference Node WRF_CDT_REFCHAR18WRF_NODESWRF_MATGRP_CSHLP_REF
RESPONSIBILITYResponsibility WRF_RESPCHAR20WCHAR20WRF_MATGRP_RESP

Key field Non-key field



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

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

How to access SAP table ROXXB40071

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