AV03R_SELECT_SALES SAP (Structure for Selection of Sales Data in Backlog Functions) Structure details

Dictionary Type: Structure
Description: Structure for Selection of Sales Data in Backlog Functions




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




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

AV03R_SELECT_SALES 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 "Structure for Selection of Sales Data in Backlog Functions" 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_AV03R_SELECT_SALES TYPE AV03R_SELECT_SALES.

The AV03R_SELECT_SALES table consists of various fields, each holding specific information or linking keys about Structure for Selection of Sales Data in Backlog Functions data available in SAP. These include POSNR (Sales Document Item), MATNR (Material Number), WERKS (Plant (Own or External)), BEDAE (Requirements type).. 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 AV03R_SELECT_SALES 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
VBELNSales Document VBELN_VACHAR10Assigned to domainALPHAVBELNAUN
POSNRSales Document Item POSNR_VANUMC6Assigned to domainPOSNRAPO
MATNRMaterial Number MATNRCHAR18Assigned to domainMATN1MATNRMATS_MAT1
WERKSPlant (Own or External) WERKS_EXTCHAR4Assigned to domainWERKSWRKSH_T001W_EXTS
BEDAERequirements type BEDAECHAR4Assigned to domainBEDAEBDA
ERDATDate on Which Record Was Created ERDATDATS8DATUM
FIXMGDelivery date and quantity fixed FIXMGCHAR1XFELD
LPRIODelivery Priority LPRIONUMC2Assigned to domainLPRIO
PROSAID for material determination PROSACHAR1PROSA
PSTYVSales document item category PSTYVCHAR4Assigned to domainPSTYV
SOBKZSpecial Stock Indicator SOBKZCHAR1Assigned to domainSOBKZ
SUMBDSumming up of requirements SUMBDCHAR1SUMBD
UEPOSHigher-level item in bill of material structures UEPOSNUMC6Assigned to domainPOSNR
UEPVWID for higher-level item usage UEPVWCHAR1UEPVW
AUARTSales Document Type AUARTCHAR4Assigned to domainAUARTAUARTAAT
KUNNRSold-to party KUNAGCHAR10Assigned to domainALPHAKUNNRVAG
VBTYPSD document category VBTYPCHAR1VBTYP
LFGSAOverall delivery status of the item LFGSACHAR1STATV
BESTAConfirmation Status of Document Item BESTACHAR1STATV
APOKZIndicator: Is material relevant for APO APOKZCHAR1APOKZ
EDATU_MINSchedule line date EDATUDATS8DATUM
SD_FIXED_ITEM_REQ_DETERMINE SD_FIXED_ITEM_REQ_DETERMINE0

Key field Non-key field



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

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

How to access SAP table AV03R_SELECT_SALES

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