/MIVE/S_SALES_SOI_DETAIL SAP (MIV Apps: Sales Order Item detail structure) Structure details

Dictionary Type: Structure
Description: MIV Apps: Sales Order Item detail structure




ABAP Code to SELECT data from /MIVE/S_SALES_SOI_DETAIL
Related tables to /MIVE/S_SALES_SOI_DETAIL
Access table /MIVE/S_SALES_SOI_DETAIL




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

/MIVE/S_SALES_SOI_DETAIL 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 "MIV Apps: Sales Order Item detail structure" 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_/MIVE/S_SALES_SOI_DETAIL TYPE /MIVE/S_SALES_SOI_DETAIL.

The /MIVE/S_SALES_SOI_DETAIL table consists of various fields, each holding specific information or linking keys about MIV Apps: Sales Order Item detail structure data available in SAP. These include SO_NUMBER_KEY (MIV Apps: Sales Order number), ITEM_NUMBER_KEY (MIV Apps: Sales Order Item number), SO_NUMBER (MIV Apps: Sales Order number), ITEM_NUMBER (MIV Apps: Sales Order Item number).. 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 /MIVE/S_SALES_SOI_DETAIL 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
SO_NUMBER_KEYMIV Apps: Sales Order number /MIVE/SALES_SO_NUMBERCHAR10ALPHA/MIVE/SALES_SO_NUMBER
ITEM_NUMBER_KEYMIV Apps: Sales Order Item number /MIVE/SALES_ITEM_NUMBERCHAR6ALPHA/MIVE/SALES_ITEM_NUMBER
SO_NUMBERMIV Apps: Sales Order number /MIVE/SALES_SO_NUMBERCHAR10ALPHA/MIVE/SALES_SO_NUMBER
ITEM_NUMBERMIV Apps: Sales Order Item number /MIVE/SALES_ITEM_NUMBERCHAR6ALPHA/MIVE/SALES_ITEM_NUMBER
MATERIAL_NUMBERMaterial Number MATNRCHAR18Assigned to domainMATN1MATNRMATS_MAT1
MATERIAL_TEXTMaterial Description (Short Text) MAKTXCHAR40TEXT40
QUANTITYMIV Apps: Sales Order order quantity /MIVE/SALES_ORDER_QUANTITYQUAN15(3) MENG15
QUANTITY_UOMMIV Apps: Sales generic unit of measure /MIVE/SALES_UOMUNIT3Assigned to domainCUNITMEINS
QUANTITY_UOM_TEXTMIV Apps: Sales generic unit of measure text /MIVE/SALES_UOM_TEXTCHAR30TEXT30
QUANTITY_FORMATTEDChar 80 CHAR80CHAR80CHAR80
STATUSMIV Apps: Sales Order status text /MIVE/SALES_STATUS_TEXTCHAR20TEXT20
VALUEMIV Apps: Sales Order order value /MIVE/SALES_ORDER_VALUECURR15(2) /MIVE/SALES_ORDER_VALUE
VALUE_CURRENCYMIV Apps: Sales Order currency /MIVE/SALES_CURRENCYCUKY5Assigned to domainWAERS
VALUE_CURRENCY_TEXTMIV Apps: Sales Order currency text /MIVE/SALES_CURRENCY_TEXTCHAR40TEXT40
VALUE_FORMATTEDChar 80 CHAR80CHAR80CHAR80
NET_WEIGHTMIV Apps: Sales Order weight /MIVE/SALES_ORDER_WEIGHTQUAN15(3) MENG15
GROSS_WEIGHTMIV Apps: Sales Order weight /MIVE/SALES_ORDER_WEIGHTQUAN15(3) MENG15
WEIGHT_UOMMIV Apps: Sales generic unit of measure /MIVE/SALES_UOMUNIT3Assigned to domainCUNITMEINS
WEIGHT_UOM_TEXTMIV Apps: Sales generic unit of measure text /MIVE/SALES_UOM_TEXTCHAR30TEXT30
NET_WEIGHT_FORMATTEDChar 80 CHAR80CHAR80CHAR80
GROSS_WEIGHT_FORMATTEDChar 80 CHAR80CHAR80CHAR80
VOLUMEMIV Apps: Sales Order weight /MIVE/SALES_ORDER_VOLUMEQUAN13(3) MENG13
VOLUME_UOMMIV Apps: Sales generic unit of measure /MIVE/SALES_UOMUNIT3Assigned to domainCUNITMEINS
VOLUME_UOM_TEXTMIV Apps: Sales generic unit of measure text /MIVE/SALES_UOM_TEXTCHAR30TEXT30
VOLUME_FORMATTEDChar 80 CHAR80CHAR80CHAR80
SOLDTO_IDMIV Apps: Sales Order Sold-To Party /MIVE/SALES_PARTNER_SOLDTOCHAR10Assigned to domainALPHAKUNNR
SOLDTO_NAMEMIV Apps: Sales Order partner name /MIVE/SALES_PARTNER_NAMECHAR40TEXT40
SOLDTO_CITYMIV Apps: Sales Order partner city /MIVE/SALES_PARTNER_CITYCHAR40TEXT40
SOLDTO_PCODEMIV Apps: Sales Order partner postal code /MIVE/SALES_PARTNER_PCODECHAR10CHAR10
SOLDTO_STREETMIV Apps: Sales Order Partner Street /MIVE/SALES_PARTNER_STREETCHAR60TEXT60
SOLDTO_HOUSE_NOMIV Apps: Sales Order Partner House number /MIVE/SALES_PARTNER_HOUSE_NOCHAR10TEXT10
SOLDTO_COUNTRY_TEXTMIV Apps: Sales Orde country text /MIVE/SALES_CUST_COUNTRY_TEXTCHAR40TEXT40
SHIPTO_IDMIV Apps: Sales Order Ship-to Party /MIVE/SALES_PARTNER_SHIPTOCHAR10Assigned to domainALPHAKUNNR
SHIPTO_NAMEMIV Apps: Sales Order partner name /MIVE/SALES_PARTNER_NAMECHAR40TEXT40
SHIPTO_CITYMIV Apps: Sales Order partner city /MIVE/SALES_PARTNER_CITYCHAR40TEXT40
SHIPTO_PCODEMIV Apps: Sales Order partner postal code /MIVE/SALES_PARTNER_PCODECHAR10CHAR10
SHIPTO_STREETMIV Apps: Sales Order Partner Street /MIVE/SALES_PARTNER_STREETCHAR60TEXT60
SHIPTO_HOUSE_NOMIV Apps: Sales Order Partner House number /MIVE/SALES_PARTNER_HOUSE_NOCHAR10TEXT10
SHIPTO_COUNTRY_TEXTMIV Apps: Sales Orde country text /MIVE/SALES_CUST_COUNTRY_TEXTCHAR40TEXT40

Key field Non-key field



How do I retrieve data from SAP structure /MIVE/S_SALES_SOI_DETAIL using ABAP code?

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

How to access SAP table /MIVE/S_SALES_SOI_DETAIL

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