ROXPLN0028 SAP (Generated Table for View /BEV1/EM_SD_SLS) Structure details

Dictionary Type: Structure
Description: Generated Table for View /BEV1/EM_SD_SLS




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




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

ROXPLN0028 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 /BEV1/EM_SD_SLS" 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_ROXPLN0028 TYPE ROXPLN0028.

The ROXPLN0028 table consists of various fields, each holding specific information or linking keys about Generated Table for View /BEV1/EM_SD_SLS data available in SAP. These include KTOINH (Customer Numbers), PERIODE (Booking Entry Period for Empties), VKORG (Sales Organization), VTWEG (Distribution Channel).. 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: Cannot Be Enhanced


SAP ROXPLN0028 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 MANDTCLNT3Assigned to domainMANDT
KTOINHCustomer Numbers KUNNRCHAR10KNA1ALPHAKUNNRKUNC_KUNNR
PERIODEBooking Entry Period for Empties /BEV1/EMPERIODNUMC6NUM6
VKORGSales Organization VKORGCHAR4TVKOVKORGVKOC_VKORG
VTWEGDistribution Channel VTWEGCHAR2TVTWVTWEGVTWC_VTWEG
SPARTDivision SPARTCHAR2TSPASPARTSPAC_SPART
KUNAGSold-to party KUNAGCHAR10KNA1ALPHAKUNNRVAG
KUNWEShip-to party KUNWECHAR10KNA1ALPHAKUNNR
KUNREBill-to party KUNRECHAR10KNA1ALPHAKUNNRKUN
KUNRGPayer KUNRGCHAR10KNA1ALPHAKUNNR
LGGRPEmpties Group /BEV1/EMLGGRPCHAR4/BEV1/EMGRP/BEV1/EMLGGRP
MATNRMaterial Number MATNRCHAR18MARAMATN1MATNRMATS_MAT1
WAERSCurrency Key WAERSCUKY5TCURCWAERSFWS
BOQ1Quantity Field of the Old Balance /BEV1/EMBOQUANTQUAN15(3) MENGV15_3
BOV1Value Field of the Old Balance /BEV1/EMBOVALUECURR19(2) WERTV10
BOQ2Quantity Field of the Old Balance /BEV1/EMBOQUANTQUAN15(3) MENGV15_3
BOV2Value Field of the Old Balance /BEV1/EMBOVALUECURR19(2) WERTV10
BOQ3Quantity Field of the Old Balance /BEV1/EMBOQUANTQUAN15(3) MENGV15_3
BOV3Value Field of the Old Balance /BEV1/EMBOVALUECURR19(2) WERTV10
BOQ4Quantity Field of the Old Balance /BEV1/EMBOQUANTQUAN15(3) MENGV15_3
BOV4Value Field of the Old Balance /BEV1/EMBOVALUECURR19(2) WERTV10
BOQ5Quantity Field of the Old Balance /BEV1/EMBOQUANTQUAN15(3) MENGV15_3
BOV5Value Field of the Old Balance /BEV1/EMBOVALUECURR19(2) WERTV10
TOQ1Quantity Field for Sales /BEV1/EMTOQUANTQUAN15(3) MENGV15_3
TOV1Value Field for Sales /BEV1/EMTOVALUECURR19(2) WERTV10
TOQ2Quantity Field for Sales /BEV1/EMTOQUANTQUAN15(3) MENGV15_3
TOV2Value Field for Sales /BEV1/EMTOVALUECURR19(2) WERTV10
TOQ3Quantity Field for Sales /BEV1/EMTOQUANTQUAN15(3) MENGV15_3
TOV3Value Field for Sales /BEV1/EMTOVALUECURR19(2) WERTV10
TOQ4Quantity Field for Sales /BEV1/EMTOQUANTQUAN15(3) MENGV15_3
TOV4Value Field for Sales /BEV1/EMTOVALUECURR19(2) WERTV10
TOQ5Quantity Field for Sales /BEV1/EMTOQUANTQUAN15(3) MENGV15_3
TOV5Value Field for Sales /BEV1/EMTOVALUECURR19(2) WERTV10
BNQ1Quantity Field of the New Balance /BEV1/EMBNQUANTQUAN15(3) MENGV15_3
BNV1Value Field of the New Balance /BEV1/EMBNVALUECURR19(2) WERTV10
BNQ2Quantity Field of the New Balance /BEV1/EMBNQUANTQUAN15(3) MENGV15_3
BNV2Value Field of the New Balance /BEV1/EMBNVALUECURR19(2) WERTV10
BNQ3Quantity Field of the New Balance /BEV1/EMBNQUANTQUAN15(3) MENGV15_3
BNV3Value Field of the New Balance /BEV1/EMBNVALUECURR19(2) WERTV10
BNQ4Quantity Field of the New Balance /BEV1/EMBNQUANTQUAN15(3) MENGV15_3
BNV4Value Field of the New Balance /BEV1/EMBNVALUECURR19(2) WERTV10
BNQ5Quantity Field of the New Balance /BEV1/EMBNQUANTQUAN15(3) MENGV15_3
BNV5Value Field of the New Balance /BEV1/EMBNVALUECURR19(2) WERTV10
AEDATChanged On AEDATDATS8DATUM
AEZETTime last change was made AEZETTIMS6UZEIT
MEINSBase Unit of Measure MEINSUNIT3Assigned to domainCUNITMEINS

Key field Non-key field



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

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

How to access SAP table ROXPLN0028

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