SALES_ORDER_STATUS_EXT SAP (Extended Status Information for Sales Orders) Structure details

Dictionary Type: Structure
Description: Extended Status Information for Sales Orders




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




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

SALES_ORDER_STATUS_EXT 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 "Extended Status Information for Sales Orders" 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_SALES_ORDER_STATUS_EXT TYPE SALES_ORDER_STATUS_EXT.

The SALES_ORDER_STATUS_EXT table consists of various fields, each holding specific information or linking keys about Extended Status Information for Sales Orders data available in SAP. These include DOC_NUMBER (Sales Document), DOC_DATE (Document Date (Date Received/Sent)), PURCH_NO (Customer purchase order number), PRC_STAT_H (Overall processing status of document).. 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 SALES_ORDER_STATUS_EXT 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
DOC_NUMBERSales Document VBELN_VACHAR10VBUKALPHAVBELNAUN
DOC_DATEDocument Date (Date Received/Sent) AUDATDATS8DATUM
PURCH_NOCustomer purchase order number BSTNKCHAR20BSTNK
PRC_STAT_HOverall processing status of document GBSTKCHAR1STATV
DLV_STAT_HOverall delivery status for all items LKGSKCHAR1STATV
REQ_DATE_HRequested delivery date EDATU_VBAKDATS8DATUM
DLV_BLOCKDelivery block (document header) LIFSKCHAR2TVLSLIFSP
ITM_NUMBERSales Document Item POSNR_VANUMC6VBUPPOSNRAPO
MATERIALMaterial Number MATNRCHAR18MARAMATN1MATNRMATS_MAT1
SHORT_TEXTShort text for sales order item ARKTXCHAR40TEXT40
REQ_DATESchedule line date EDATUDATS8DATUM
REQ_QTYCumulative Order Quantity in Sales Units KWMENGQUAN15(3) MENG15
CUM_CF_QTYCumulative confirmed quantity in sales unit KBMENGQUAN15(3) MENG15
SALES_UNITSales unit VRKMEUNIT3T006CUNITMEINS
NET_VALUENet value of the order item in document currency NETWR_APCURR15(2) WERTV8
CURRENCYSD Document Currency WAERKCUKY5TCURCWAERSFWS
NET_PRICENet price NETPRCURR11(2) WERTV6
COND_P_UNTCondition pricing unit KPEINDEC5KPEIN
COND_UNITCondition unit KMEINUNIT3T006CUNITMEINS
DLV_STAT_IOverall delivery status of the item LFGSACHAR1STATV
DELIV_NUMBDelivery VBELN_VLCHAR10VBUKALPHAVBELNVL
DELIV_ITEMDelivery Item POSNR_VLNUMC6VBUPPOSNR
DELIV_DATEDelivery date LFDATDATS8DATUM
DLV_QTYActual quantity delivered (in sales units) LFIMGQUAN13(3) MENG13
REF_QTYReferenced quantity in base unit of measure RFMNGQUAN15(3) MENG15
S_UNIT_ISOSales unit in ISO code VRKME_ISOCHAR3T006IISOCD_UNIT
CD_UNT_ISOCondition unit of measure in UoM KVMEI_ISOCHAR3T006IISOCD_UNIT
CURR_ISOISO code currency WAERS_ISOCHAR3ISOCD
MATERIAL_EXTERNALLong Material Number for MATERIAL Field MGV_MATERIAL_EXTERNALCHAR40MATNR_EXT
MATERIAL_GUIDExternal GUID for MATERIAL Field MGV_MATERIAL_GUIDCHAR32MATNR_EGUID
MATERIAL_VERSIONVersion Number for MATERIAL Field MGV_MATERIAL_VERSIONCHAR10MATNWMATNR_VERS
PO_ITM_NOItem Number of the Underlying Purchase Order POSEXCHAR6ALPHAPOSEX
CREATION_DATEDate on Which Record Was Created ERDATDATS8DATUM
CREATION_TIMEEntry time ERZETTIMS6UZEIT
S_UNIT_DLVDelivery unit LIFMEUNIT3Assigned to domainCUNITMEINS
DLV_UNIT_ISOUnit of measure for delivery unit in ISO code SCHME_ISOCHAR3Assigned to domainISOCD_UNIT
REA_FOR_REReason for rejection of quotations and sales orders ABGRU_VACHAR2Assigned to domainABGRU_VA
PURCH_NO_CCustomer purchase order number BSTKDCHAR35BSTKD
CUSTOMERCustomer Numbers KUNNRCHAR10Assigned to domainALPHAKUNNRKUNC_KUNNR
NAME1Name 1 of organization BU_NAMEOR1CHAR40BU_NAME
NAME2Name 2 of organization BU_NAMEOR2CHAR40BU_NAME
NAME3Name 3 of organization BU_NAMEOR3CHAR40BU_NAME
NAME4Name 4 of organization BU_NAMEOR4CHAR40BU_NAME
LEGALFORMBP: Legal form of organization BU_LEGENTYCHAR2Assigned to domainBU_LEGENTYH_TB019
INDUSTRYSECTORIndustry sector BU_INDSECTCHAR10Assigned to domainBU_INDSECTH_TB023
FOUNDATIONDATEDate organization founded BU_FOUND_DATDATS8DATUM
LIQUIDATIONDATELiquidation date of organization BU_LIQUID_DATDATS8
LOC_NO_1International location number (part 1) BBBNRNUMC7NUM07
LOC_NO_2International location number (Part 2) BBSNRNUMC5NUM05
CHK_DIGITCheck digit for the international location number BUBKZNUMC1NUM01
LEGALORGLegal Entity of Organization BU_LEGAL_ORGCHAR2Assigned to domainBU_LEGAL_ORG

Key field Non-key field



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

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

How to access SAP table SALES_ORDER_STATUS_EXT

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