QBEFU SAP (View for Stock Posting from the Usage Decision) Structure details
Description: View for Stock Posting from the Usage Decision
Structure field list including key, data, relationships and ABAP select examples
QBEFU 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 for Stock Posting from the Usage Decision" 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_QBEFU TYPE QBEFU.
The QBEFU table consists of various fields, each holding specific information or linking keys about View for Stock Posting from the Usage Decision data available in SAP. These include MATNR (Material Number), WERKS (Plant), LGORT (Storage Location), LGTYP_SP (Storage 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 QBEFU 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 |
MNGNR | No. of Quantity Field for Interface Table QBEFU | QMNGNR | INT4 | 10 | INT4 | ||||
MATNR | Material Number | MATNR | CHAR | 18 | Assigned to domain | MATN1 | MATNR | MAT | S_MAT1 |
WERKS | Plant | WERKS_D | CHAR | 4 | Assigned to domain | WERKS | WRK | H_T001W_C | |
LGORT | Storage Location | LGORT_D | CHAR | 4 | Assigned to domain | LGORT | LAG | ||
LGTYP_SP | Storage Type | LGTYP | CHAR | 3 | Assigned to domain | LGTYP | LGT | H_T301 | |
LGPLA_SP | Storage Bin | LGPLA | CHAR | 10 | Assigned to domain | LGPLA | LGP | LAG1 | |
UMLGT_SP | Storage Type | LGTYP | CHAR | 3 | Assigned to domain | LGTYP | LGT | H_T301 | |
UMLGP_SP | Storage Bin | LGPLA | CHAR | 10 | Assigned to domain | LGPLA | LGP | LAG1 | |
CHARG | Batch Number | CHARG_D | CHAR | 10 | Assigned to domain | CHARG | CHA | ||
SOBKZ | Special Stock Indicator | SOBKZ | CHAR | 1 | Assigned to domain | SOBKZ | |||
LIFNR | Account Number of Vendor or Creditor | LIFNR | CHAR | 10 | Assigned to domain | ALPHA | LIFNR | LIF | KRED_C |
BWART | Movement Type (Inventory Management) | BWART | CHAR | 3 | Assigned to domain | BWART | BWA | ||
MENGE | Quantity | MENGE_D | QUAN | 13(3) | MENG13 | ||||
MEINS | Base Unit of Measure | MEINS | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
UMMAT | Receiving/Issuing Material | UMMAT | CHAR | 18 | Assigned to domain | MATN1 | MATNR | ||
UMWRK | Receiving/Issuing Plant | UMWRK | CHAR | 4 | Assigned to domain | WERKS | |||
UMLGO | Receiving/Issuing Storage Location | UMLGO | CHAR | 4 | Assigned to domain | LGORT | |||
UMCHA | Receiving/Issuing Batch | UMCHA | CHAR | 10 | Assigned to domain | CHARG | |||
KOSTL | Cost Center | KOSTL | CHAR | 10 | Assigned to domain | ALPHA | KOSTL | KOS | |
AUFNR | Order Number | AUFNR | CHAR | 12 | Assigned to domain | ALPHA | AUFNR | ANR | |
AUFPS | Item Number of Reservation/Dependent Requirement | RSPOS | NUMC | 4 | RSPOS | RPO | |||
ANLN1 | Main Asset Number | ANLN1 | CHAR | 12 | Assigned to domain | ALPHA | ANLN1 | AN1 | |
ANLN2 | Asset Subnumber | ANLN2 | CHAR | 4 | Assigned to domain | ALPHA | ANLN2 | AN2 | |
PS_PSP_PNR | Work Breakdown Structure Element (WBS Element) | PS_PSP_PNR | NUMC | 8 | Assigned to domain | KONPR | PS_POSNR | ||
NPLNR | Network Number for Account Assignment | NPLNR | CHAR | 12 | Assigned to domain | ALPHA | AUFNR | NET | |
AUFPL | Routing number of operations in the order | CO_AUFPL | NUMC | 10 | AUFPL | ||||
APLZL | Internal counter | CIM_COUNT | NUMC | 8 | CIM_COUNT | ||||
KUNNR | Account Number of Customer | EKUNN | CHAR | 10 | Assigned to domain | ALPHA | KUNNR | KUN | |
KDAUF | Sales Order Number | KDAUF | CHAR | 10 | Assigned to domain | ALPHA | VBELN | AUN | |
KDPOS | Item Number in Sales Order | KDPOS | NUMC | 6 | NUM06 | KPO | |||
IMKEY | Internal Key for Real Estate Object | IMKEY | CHAR | 8 | IMKEY | ||||
DABRZ | Reference Date for Settlement | DABRBEZ | DATS | 8 | DDAT | ||||
KSTRG | Cost Object | KSTRG | CHAR | 12 | Assigned to domain | KSTRG | KTR | ||
PAOBJNR | Profitability Segment Number (CO-PA) | RKEOBJNR | NUMC | 10 | RKEOBJNR | ||||
PRCTR | Profit Center | PRCTR | CHAR | 10 | Assigned to domain | ALPHA | PRCTR | PRC | PRCTR_EMPTY |
GSBER | Business Area | GSBER | CHAR | 4 | Assigned to domain | GSBER | GSB | ||
KONTO | G/L Account Number | SAKNR | CHAR | 10 | Assigned to domain | ALPHA | SAKNR | SAK | C_SAKNR |
BEAKZ | Indicator: Line already processed | BEAKZ_WA | CHAR | 1 | XFELD | ||||
YZEIL | Item in Material Document | MBLPO | NUMC | 4 | MBLPO | POS | |||
MSGTY | Message Type | MSGTY | CHAR | 1 | MSGAR | ||||
MSGID | Message identification | MSGID | CHAR | 20 | Assigned to domain | ARBGB | |||
MSGNO | System Message Number | MSGNO | CHAR | 3 | Assigned to domain | MSGNR | |||
MSGV1 | Message variable 01 | MSGV1 | CHAR | 50 | CHAR50 | ||||
MSGV2 | Message variable 02 | MSGV2 | CHAR | 50 | CHAR50 | ||||
MSGV3 | Message variable 03 | MSGV3 | CHAR | 50 | CHAR50 | ||||
MSGV4 | Message variable 04 | MSGV4 | CHAR | 50 | CHAR50 | ||||
MBLNR | Number of Material Document | MBLNR | CHAR | 10 | ALPHA | BELNR | MBN | ||
MJAHR | Material Document Year | MJAHR | NUMC | 4 | GJAHR | GJAHR | MJA | ||
ZEILE | Item in Material Document | MBLPO | NUMC | 4 | MBLPO | POS | |||
CPUDT | Day On Which Accounting Document Was Entered | CPUDT | DATS | 8 | DATUM | ||||
CPUTM | Time of Entry | CPUTM | TIMS | 6 | UZEIT | ||||
PRUEFLOS | Inspection Lot Number | QPLOS | NUMC | 12 | Assigned to domain | QPLOS | QLS | QALS | |
SCRTEXT_M | Medium Field Label | SCRTEXT_M | CHAR | 20 | SCRTEXT_M | ||||
BPMNG | Quantity in Purchase Order Price Unit | BPMNG | QUAN | 13(3) | MENG13 | ||||
BPRME | Order Price Unit (Purchasing) | BBPRM | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
KZBEW | Movement Indicator | KZBEW | CHAR | 1 | KZBEW | ||||
ELIKZ | 'Delivery Completed' Indicator | ELIKZ | CHAR | 1 | XFELD | ||||
INSMK | Stock Type | MB_INSMK | CHAR | 1 | MB_INSMK | ||||
ABLAD | Unloading Point | ABLAD | CHAR | 25 | TEXT25 | ||||
GRUND | Reason for Movement | MB_GRBEW | NUMC | 4 | Assigned to domain | MB_GRBEW | |||
SGTXT | Item Text | SGTXT | CHAR | 50 | TEXT50 | ||||
EBELN | Purchasing Document Number | EBELN | CHAR | 10 | Assigned to domain | ALPHA | EBELN | BES | MEKK_C |
EBELP | Item Number of Purchasing Document | EBELP | NUMC | 5 | Assigned to domain | EBELP | BSP | ||
TBFKZ | Indicator: No Transfer Requirement Created | LVS_TBFKZ | CHAR | 1 | XFELD | ||||
TAFKZ | Indicator: do not cal up automatic TO creation | LVS_TAFKZ | CHAR | 1 | XFELD | ||||
TBBEL | Material doc. no. of transfer requirement to be cancelled | LVS_TBBEL | CHAR | 10 | ALPHA | BELNR | MBN | ||
TBBPO | Material doc. item of transf.reqmnt item to be cancelled | LVS_TBBPO | NUMC | 4 | MBLPO | POS | |||
TBBJR | Material doc. year of transfer requirement to be cancelled | LVS_TBBJR | NUMC | 4 | GJAHR | GJAHR | MJA | ||
LFBJA | Fiscal Year of a Reference Document | LFBJA | NUMC | 4 | GJAHR | GJAHR | |||
LFBNR | Document No. of a Reference Document | LFBNR | CHAR | 10 | ALPHA | BELNR | |||
LFPOS | Item of a Reference Document | LFPOS | NUMC | 4 | MBLPO | ||||
UMBAR | Valuation Type of Transfer Batch | UMBAR | CHAR | 10 | Assigned to domain | BWTAR |
Key field | Non-key field |
How do I retrieve data from SAP structure QBEFU using ABAP code?
As QBEFU 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 QBEFU as there is no data to select.How to access SAP table QBEFU
Within an ECC or HANA version of SAP you can also view further information about QBEFU and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects