BAPIORDERS SAP (View: Order Items for Material) Structure details

Dictionary Type: Structure
Description: View: Order Items for Material




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




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

BAPIORDERS 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 "View: Order Items for Material" 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_BAPIORDERS TYPE BAPIORDERS.

The BAPIORDERS table consists of various fields, each holding specific information or linking keys about View: Order Items for Material data available in SAP. These include ITM_NUMBER (Item number of the SD document), MATERIAL (Material Number), SHORT_TEXT (Short text for sales order item), DOC_TYPE (Sales Document 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: Can be enhanced (character-type or numeric)


SAP BAPIORDERS 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
SD_DOCSales and Distribution Document Number VBELNCHAR10VBUKALPHAVBELNAUN
ITM_NUMBERItem number of the SD document POSNRNUMC6VBUPPOSNR
MATERIALMaterial Number MATNRCHAR18MARAMATN1MATNRMATS_MAT1
SHORT_TEXTShort text for sales order item ARKTXCHAR40TEXT40
DOC_TYPESales Document Type AUARTCHAR4TVAKAUARTAUARTAAT
DOC_DATEDocument Date (Date Received/Sent) AUDATDATS8DATUM
REQ_QTYCumulative Order Quantity in Sales Units KWMENGQUAN15(3) MENG15
REQ_DATERequested delivery date WLDATDATS8DATUM
PURCH_NOCustomer purchase order number BSTNKCHAR20BSTNK
BATCHBatch Number CHARG_DCHAR10MCHACHARGCHA
VALID_FROMQuotation or contract valid from DATAB_VIDATS8DATUM
VALID_TOQuotation or contract valid to DATBI_VIDATS8DATUM
BILL_BLOCKBilling block in SD document FAKSKCHAR2TVFSFAKSP
DLV_BLOCKDelivery block (document header) LIFSKCHAR2TVLSLIFSP
SOLD_TOSold-to party KUNAGCHAR10KNA1ALPHAKUNNRVAG
NAMEName 1 NAME1_GPCHAR35NAME
EXCHG_RATEDirectly quoted exchange rate for pricing and statistics KURSK_PDEC9(5) PKURS
DLV_QTYActual quantity delivered (in sales units) LFIMGQUAN13(3) MENG13
BASE_UOMBase Unit of Measure MEINSUNIT3T006CUNITMEINS
NET_PRICENet price NETPRCURR11(2) WERTV6
COND_P_UNTCondition pricing unit KPEINDEC5KPEIN
COND_UNITCondition unit KMEINUNIT3T006CUNITMEINS
NET_VAL_HDNet Value of the Sales Order in Document Currency NETWR_AKCURR15(2) WERTV8
NET_VALUENet Value in Document Currency NETWRCURR15(2) WERTV8
DIVISIONDivision SPARTCHAR2TSPASPARTSPAC_SPART
DOC_STATUSDocument status STATSCHAR20TEXT20
SALES_GRPSales Group VKGRPCHAR3TVKGRVKGRPVKG
SALES_OFFSales Office VKBURCHAR4TVBURVKBURVKB
SALES_ORGSales Organization VKORGCHAR4TVKOVKORGVKOC_VKORG
SALES_UNITSales unit VRKMEUNIT3T006CUNITMEINS
SHIP_POINTShipping Point/Receiving Point VSTELCHAR4TVSTVSTELVST
DISTR_CHANDistribution Channel VTWEGCHAR2TVTWVTWEGVTWC_VTWEG
GI_DATEGoods Issue Date WADATDATS8DATUM
CURRENCYSD Document Currency WAERKCUKY5TCURCWAERSFWS
PLANTPlant WERKS_DCHAR4T001WWERKSWRKH_T001W_C
STORE_LOCStorage Location LGORT_DCHAR4T001LLGORTLAG
ORD_REASONOrder reason (reason for the business transaction) AUGRUCHAR3TVAUAUGRU
REASON_REJReason for rejection of quotations and sales orders ABGRUCHAR2ABGRU
B_UOM_ISOBase unit of measure in ISO code MEINS_ISOCHAR3T006IISOCD_UNIT
CD_UNT_ISOCondition unit of measure in UoM KVMEI_ISOCHAR3T006IISOCD_UNIT
S_UNIT_ISOSales unit in ISO code VRKME_ISOCHAR3T006IISOCD_UNIT
CURR_ISOISO code currency WAERS_ISOCHAR3ISOCD
PURCH_NO_CCustomer purchase order number BSTKDCHAR35BSTKD
EXCHG_RATE_VIndirectly quoted exchange rate for pricing and statistics KURSK_VDEC9(5) PKURS
MAT_EXTLong Material Number for MATERIAL Field MGV_MATERIAL_EXTERNALCHAR40MATNR_EXT
MAT_GUIDExternal GUID for MATERIAL Field MGV_MATERIAL_GUIDCHAR32MATNR_EGUID
MAT_VERSVersion Number for MATERIAL Field MGV_MATERIAL_VERSIONCHAR10MATNWMATNR_VERS
CREATION_DATEDate on Which Record Was Created ERDATDATS8DATUM
CREATION_TIMEEntry time ERZETTIMS6UZEIT
STATUS_DOCStatus of the document STATUS_VBCHAR1STATV

Key field Non-key field



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

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

How to access SAP table BAPIORDERS

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