MMVBAK SAP (Purchase Order Item + Sales Document Header Data) Structure details
Description: Purchase Order Item + Sales Document Header Data
Structure field list including key, data, relationships and ABAP select examples
MMVBAK 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 "Purchase Order Item + Sales Document Header Data" 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_MMVBAK TYPE MMVBAK.
The MMVBAK table consists of various fields, each holding specific information or linking keys about Purchase Order Item + Sales Document Header Data data available in SAP. These include MANDT (Client), VBELN (Sales Document), ERDAT (Date on Which Record Was Created), ERZET (Entry time).. 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 MMVBAK 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 |
EBELP | Item Number of Purchasing Document | EBELP | NUMC | 5 | Assigned to domain | EBELP | BSP | ||
MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
VBELN | Sales Document | VBELN_VA | CHAR | 10 | VBUK | ALPHA | VBELN | AUN | |
ERDAT | Date on Which Record Was Created | ERDAT | DATS | 8 | DATUM | ||||
ERZET | Entry time | ERZET | TIMS | 6 | UZEIT | ||||
ERNAM | Name of Person who Created the Object | ERNAM | CHAR | 12 | USNAM | ||||
ANGDT | Quotation/Inquiry is valid from | ANGDT_V | DATS | 8 | DATUM | ||||
BNDDT | Date until which bid/quotation is binding (valid-to date) | BNDDT | DATS | 8 | DATUM | ||||
AUDAT | Document Date (Date Received/Sent) | AUDAT | DATS | 8 | DATUM | ||||
VBTYP | SD document category | VBTYP | CHAR | 1 | VBTYP | ||||
TRVOG | Transaction group | TRVOG | CHAR | 1 | TRVOG | VTV | |||
AUART | Sales Document Type | AUART | CHAR | 4 | TVAK | AUART | AUART | AAT | |
AUGRU | Order reason (reason for the business transaction) | AUGRU | CHAR | 3 | TVAU | AUGRU | |||
GWLDT | Warranty Date | GWLDT | DATS | 8 | DATUM | ||||
SUBMI | Collective number (SD) | SUBMI_SD | CHAR | 10 | CHAR10 | ||||
LIFSK | Delivery block (document header) | LIFSK | CHAR | 2 | TVLS | LIFSP | |||
FAKSK | Billing block in SD document | FAKSK | CHAR | 2 | TVFS | FAKSP | |||
NETWR | Net Value of the Sales Order in Document Currency | NETWR_AK | CURR | 15(2) | WERTV8 | ||||
WAERK | SD Document Currency | WAERK | CUKY | 5 | TCURC | WAERS | FWS | ||
VKORG | Sales Organization | VKORG | CHAR | 4 | TVKO | VKORG | VKO | C_VKORG | |
VTWEG | Distribution Channel | VTWEG | CHAR | 2 | TVKOV | VTWEG | VTW | C_VTWEG | |
SPART | Division | SPART | CHAR | 2 | TVTA | SPART | SPA | C_SPART | |
VKGRP | Sales Group | VKGRP | CHAR | 3 | TVBVK | VKGRP | VKG | ||
VKBUR | Sales Office | VKBUR | CHAR | 4 | TVKBZ | VKBUR | VKB | ||
GSBER | Business Area | GSBER | CHAR | 4 | TGSB | GSBER | GSB | ||
GSKST | Business area from cost center | GSKST | CHAR | 4 | TGSB | GSBER | |||
GUEBG | Valid-from date (outline agreements, product proposals) | GUEBG | DATS | 8 | DATUM | ||||
GUEEN | Valid-to date (outline agreements, product proposals) | GUEEN | DATS | 8 | DATUM | ||||
KNUMV | Number of the document condition | KNUMV | CHAR | 10 | KNUMV | ||||
VDATU | Requested delivery date | EDATU_VBAK | DATS | 8 | DATUM | ||||
VPRGR | Proposed date type | PRGRS_VBAK | CHAR | 1 | PRGRS | ||||
AUTLF | Complete delivery defined for each sales order? | AUTLF | CHAR | 1 | XFELD | ||||
VBKLA | Original system with release and transaction control | VBKLA | CHAR | 9 | CHAR9 | ||||
VBKLT | SD document indicator | VBKLT | CHAR | 1 | VBKLT | ||||
KALSM | Sales and Distribution: Pricing Procedure in Pricing | KALSMASD | CHAR | 6 | T683 | KALSM | |||
VSBED | Shipping Conditions | VSBED | CHAR | 2 | TVSB | VSBED | |||
FKARA | Proposed billing type for an order-related billing document | FKARA | CHAR | 4 | TVFK | FKART | |||
AWAHR | Sales probability | AWAHR_AK | NUMC | 3 | AWAHR | ||||
KTEXT | Search term for product proposal | KTEXT_V | CHAR | 40 | TEXT40 | ||||
BSTNK | Customer purchase order number | BSTNK | CHAR | 20 | BSTNK | ||||
BSARK | Customer purchase order type | BSARK | CHAR | 4 | T176 | BSARK | |||
BSTDK | Customer purchase order date | BSTDK | DATS | 8 | DATUM | ||||
BSTZD | Purchase order number supplement | BSTZD | CHAR | 4 | BSTZD | ||||
IHREZ | Your Reference | IHREZ | CHAR | 12 | TEXT12 | ||||
BNAME | Name of orderer | BNAME_V | CHAR | 35 | NAME | ||||
TELF1 | Telephone Number | TELF1_VP | CHAR | 16 | TELF1 | ||||
MAHZA | Number of contacts from the customer | MAHZA | DEC | 3 | PACK2 | ||||
MAHDT | Last customer contact date | MAHDT | DATS | 8 | DATUM | ||||
KUNNR | Sold-to party | KUNAG | CHAR | 10 | KNA1 | ALPHA | KUNNR | VAG | |
KOSTL | Cost Center | KOSTL | CHAR | 10 | Assigned to domain | ALPHA | KOSTL | KOS | |
STAFO | Update group for statistics update | STAFO | CHAR | 6 | Assigned to domain | ALPHA | STAFO | MCF | |
STWAE | Statistics currency | STWAE | CUKY | 5 | TCURC | WAERS | |||
AEDAT | Changed On | AEDAT | DATS | 8 | DATUM | ||||
KVGR1 | Customer group 1 | KVGR1 | CHAR | 3 | TVV1 | KVGR1 | |||
KVGR2 | Customer group 2 | KVGR2 | CHAR | 3 | TVV2 | KVGR2 | |||
KVGR3 | Customer group 3 | KVGR3 | CHAR | 3 | TVV3 | KVGR3 | |||
KVGR4 | Customer group 4 | KVGR4 | CHAR | 3 | TVV4 | KVGR4 | |||
KVGR5 | Customer group 5 | KVGR5 | CHAR | 3 | TVV5 | KVGR5 | |||
KNUMA | Agreement (various conditions grouped together) | KNUMA | CHAR | 10 | KONA | ALPHA | KNUMA | VMBO | |
KOKRS | Controlling Area | KOKRS | CHAR | 4 | TKA01 | CACCD | CAC | ||
PS_PSP_PNR | Work Breakdown Structure Element (WBS Element) | PS_PSP_PNR | NUMC | 8 | PRPS | KONPR | PS_POSNR | ||
KURST | Exchange Rate Type | KURST | CHAR | 4 | TCURV | KURST | KUT | ||
KKBER | Credit control area | KKBER | CHAR | 4 | T014 | KKBER | KKB | ||
KNKLI | Customer's account number with credit limit reference | KNKLI | CHAR | 10 | KNA1 | ALPHA | KUNNR | ||
GRUPP | Customer Credit Group | GRUPP_CM | CHAR | 4 | Assigned to domain | GRUPP_CM | |||
SBGRP | Credit representative group for credit management | SBGRP_CM | CHAR | 3 | T024B | SBGRP_CM | KBG | ||
CTLPC | Credit management: Risk category | CTLPC_CM | CHAR | 3 | T691A | CTLPC_CM | |||
CMWAE | Currency key of credit control area | WAERS_CM | CUKY | 5 | TCURC | WAERS | |||
CMFRE | Release date of the document determined by credit management | CMFRE | DATS | 8 | DATUM | ||||
CMNUP | Date of next credit check of document | CMNUP | DATS | 8 | DATUM | ||||
CMNGV | Next date | CMNGV | DATS | 8 | DATUM | ||||
AMTBL | Released credit value of the document | AMTBL_CM | CURR | 15(2) | WERTV8 | ||||
HITYP_PR | Hierarchy type for pricing | HITYP_PR | CHAR | 1 | THIT | HITYP | |||
ABRVW | Usage Indicator | ABRVW | CHAR | 3 | TVLV | ABRVW | |||
ABDIS | MRP for delivery schedule types | ABDIS | CHAR | 1 | ABRAB | ||||
VGBEL | Document number of the reference document | VGBEL | CHAR | 10 | VBUK | ALPHA | VBELN | ||
OBJNR | Object number at header level | OBJKO | CHAR | 22 | ONR00 | J_OBJNR | |||
BUKRS_VF | Company code to be billed | BUKRS_VF | CHAR | 4 | T001 | BUKRS | BUK | ||
TAXK1 | Alternative tax classification | TAXK1_AK | CHAR | 1 | Assigned to domain | TAXKD | |||
TAXK2 | Tax classification 2 for customer | TAXK2 | CHAR | 1 | Assigned to domain | TAXKD | |||
TAXK3 | Tax classification 3 for customer | TAXK3 | CHAR | 1 | Assigned to domain | TAXKD | |||
TAXK4 | Tax Classification 4 Customer | TAXK4 | CHAR | 1 | Assigned to domain | TAXKD | |||
TAXK5 | Tax classification 5 for customer | TAXK5 | CHAR | 1 | Assigned to domain | TAXKD | |||
TAXK6 | Tax classification 6 for customer | TAXK6 | CHAR | 1 | Assigned to domain | TAXKD | |||
TAXK7 | Tax classification 7 for customer | TAXK7 | CHAR | 1 | Assigned to domain | TAXKD | |||
TAXK8 | Tax classification 8 for customer | TAXK8 | CHAR | 1 | Assigned to domain | TAXKD | |||
TAXK9 | Tax classification 9 for customer | TAXK9 | CHAR | 1 | Assigned to domain | TAXKD | |||
XBLNR | Reference Document Number | XBLNR_V1 | CHAR | 16 | XBLNR1 | ||||
ZUONR | Assignment number | ORDNR_V | CHAR | 18 | ZUONR | ||||
VGTYP | Document category of preceding SD document | VBTYP_V | CHAR | 1 | VBTYP | ||||
KALSM_CH | Search procedure for batch determination | KALSMA_CH | CHAR | 6 | T683 | KALSM | |||
AGRZR | Accrual period for order-related billing docs.to be accrued | AGRZR | NUMC | 2 | NUM2 | ||||
AUFNR | Order Number | AUFNR | CHAR | 12 | AUFK | ALPHA | AUFNR | ANR | |
QMNUM | Notification No | QMNUM | CHAR | 12 | QMEL | ALPHA | QMNUM | IQM | |
VBELN_GRP | Mster contract number | VBELN_GRP | CHAR | 10 | Assigned to domain | ALPHA | VBELN | ||
SCHEME_GRP | Referencing requirement: Procedure | SCHEME_GRP | CHAR | 4 | TVGRPS | SCHEME_GRP | |||
ABRUF_PART | Check partner authorizations | ABRUF_PART | CHAR | 1 | ABRUF_PART | ||||
ABHOD | Pick up date | ABHOD | DATS | 8 | DATUM | ||||
ABHOV | Pick up time | ABHOZ | TIMS | 6 | UZEIT | ||||
ABHOB | Pick up time | ABHOZ | TIMS | 6 | UZEIT | ||||
RPLNR | Number of payment card plan type | RPLNR | CHAR | 10 | FPLA | FPLNR | |||
VZEIT | Proposed schedule line time (local with ref. to sales org.) | EZEIT_VBAK | TIMS | 6 | TIME_SAORG | ||||
STCEG_L | Tax Destination Country | LAND1TX | CHAR | 3 | T005 | LAND1 | LND | ||
LANDTX | Tax departure country | LANDTX | CHAR | 3 | T005 | LAND1 | LND | ||
XEGDR | Indicator: Triangular deal within the EU ? | XEGDR | CHAR | 1 | XFELD | ||||
ENQUEUE_GRP | Block master contr. until all lower level contracts updated | ENQUEUE_GRP | CHAR | 1 | ENQUEUE_GRP | ||||
DAT_FZAU | Cml delivery order qty date | DAT_FZAU | DATS | 8 | DATUM | ||||
FMBDAT | Material Staging/Availability Date | MBDAT | DATS | 8 | DATUM | ||||
VSNMR_V | Sales document version number | VSNMR_V | CHAR | 12 | VSNMR | ||||
HANDLE | International unique key for VBAK-VBELN | TSEGGUID_VBAK | CHAR | 22 | SYSUUID_22 | ||||
PROLI | Dangerous Goods Management Profile in SD Documents | ADGE_PROLI | CHAR | 3 | TDGC5 | ADGD_PROLI | TDGC5_PROLI_01 | ||
CONT_DG | Indicator: Document contains dangerous goods | ADGE_NCDG | CHAR | 1 | X | ||||
CRM_GUID | Character field, length 70 | CHAR70 | CHAR | 70 | CHAR70 | ||||
UPD_TMSTMP | UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) | TIMESTAMPL | DEC | 21(7) | TZNTSTMPL | ||||
MSR_ID | Process Identification Number | MSR_PROCESS_ID | CHAR | 10 | ALPHA | MSR_PROCESS_ID | |||
TM_CTRL_KEY | Control Key for Document Transfer to TM | TM_CTRL_KEY | CHAR | 4 | |||||
HANDOVERLOC | Location for a physical handover of goods | HANDOVER_LOC | CHAR | 10 | ALPHA | HANDOVER_LOC | |||
.INCLU--AP | 0 | ||||||||
FPART | Billing/Invoicing Plan Type | FPART | CHAR | 2 | TFPLA | FPART | |||
VCLASSIFIC | Contract classification SD customizing | /SAPHT/SW_CONTRCLASS | CHAR | 1 | /SAPHT/SW_CONTRCLASS | ||||
.INCLU--AP | 0 | ||||||||
/XLSO/SO_VALD_FM | Field of type DATS | DATS | DATS | 8 | DATS | ||||
/XLSO/SO_VALD_TO | Field of type DATS | DATS | DATS | 8 | DATS | ||||
/XLSO/PAYMENT_OP | Payment Method | /XLSO/E_PAY_METHOD | CHAR | 2 | /XLSO/D_PAY_METHOD | ||||
/XLSO/TRANS_CTXT | Transaction Context GUID | /XLSO/E_TRANS_CTXT | NUMC | 8 | /XLSO/D_TRANS_CTXT | ||||
/XLSO/CATALOG_ID | Product catalog number | WMINR | CHAR | 10 | Assigned to domain | WMINR | WMI | WPC1 | |
/XLSO/VARIANT_ID | Product catalog variant | WMVARD | CHAR | 3 | Assigned to domain | WMVAR | |||
.INCLU--AP | 0 | ||||||||
AD01FAREG | Rule for billing | AD01FAREG | CHAR | 1 | AD01FAREG | ||||
AD01BASDOC | Initial document | AD01BASDOC | CHAR | 10 | Assigned to domain | ALPHA | VBELN | ||
.INCLU--AP | 0 | ||||||||
LASTVCHR | Last voucher number | AD04LVCHNR | NUMC | 8 | AD04VCHNR | ||||
.INCLU--AP | 0 | ||||||||
PLC | PACKAGING LEVEL CODE | ADSPCM_PLC | CHAR | 1 | CHAR1 | ||||
SMB | SUPPLY MANAG. BRANCH INDICATOR | ADSPCM_SMB | CHAR | 6 | CHAR6 | ||||
ECC | EVIDENCE CONTROL CODE | ADSPCM_ECC | CHAR | 7 | CHAR7 | ||||
IPP | INITIAL PROVISIONING PROJECT NUMBER | ADSPCM_IPP | CHAR | 9 | CHAR9 | ||||
CUR | CURRENCY CODE | ADSPCM_CUR | CHAR | 3 | CHAR3 | ||||
ECO | Economic Conditions for Spec2000M | ADSPCM_ECO | CHAR | 13 | CHAR13 | ||||
PCO | PRICE CONDITION | ADSPCM_PCO | CHAR | 3 | CHAR3 | ||||
DPT | DELIVERY POINT | ADSPCM_DPT | CHAR | 15 | CHAR15 | ||||
TOP | TYPE OF PRICE | ADSPCM_TOP | CHAR | 2 | CHAR2 | ||||
SUS | SUPPLIER | ADSPCM_SUS | CHAR | 5 | CHAR5 | ||||
PCN | Prime Contract Number for Spec2000M | ADSPCM_PCN | CHAR | 16 | CHAR16 | ||||
TRU | CUSTOMER TAX REGISTRATION NUMBER | ADSPCM_TRU | CHAR | 20 | CHAR20 | ||||
PCY | Provisioning Category | ADSPCM_PCY | CHAR | 3 | CHAR3 | ||||
PCD | Procurement Code | ADSPCM_PCD | CHAR | 2 | CHAR2 | ||||
PBN | Procurement Budget Number | ADSPCM_PBN | CHAR | 14 | CHAR14 | ||||
AMN | AMENDMENT NUMBER | ADSPCM_AMN | CHAR | 3 | CHAR3 | ||||
DNO | DIVERSION NUMBER | ADSPCM_DNO | CHAR | 12 | CHAR12 | ||||
.INCLU--AP | 0 | ||||||||
PSM_BUDAT | Posting Date in the Document | PSM_BUDAT | DATS | 8 | DATUM | ||||
.INCLU--AP | 0 | ||||||||
SWENR | Business Entity Number | HB_SWENR | CHAR | 8 | VIOB01 | SWENR | SWENR | WEH | |
SMENR | Number of Sales Unit | HB_SMENR | CHAR | 8 | VIMI01 | SMENR | SMENR | MEH | |
PHASE | Sales Phase | HB_SPHSE | CHAR | 11 | HBSSPH | HBS_PHASE | |||
MTLAUR | Marker for Low Income Housing | HB_MTLAUR | CHAR | 1 | CHBSNCM | HBS_MTLAUR | |||
STAGE | Construction Stage | HB_STAGE | INT4 | 10 | INT4 | ||||
HB_CONT_REASON | Contingency data | HB_CONT | CHAR | 2 | HBSCREASON | CHAR2 | |||
HB_EXPDATE | Expiration date | HB_EXP | DATS | 8 | DATS | ||||
HB_RESDATE | Resolution date | HB_RES | DATS | 8 | DATS | ||||
.INCLU--AP | 0 | ||||||||
J_3GKBAUL | ETM-Relevant Indicator | J_3GKBAUL | CHAR | 1 | J_3GKBAUL | ||||
.INCLU--AP | 0 | ||||||||
MILL_APPL_ID | Application ID Category for Configuration | MILL_APPL_ID | CHAR | 2 | MILL_APPL_ID | ||||
.INCLU--AP | 0 | ||||||||
TAS | Treasury Account Symbol | FMFG_TAS | CHAR | 30 | CHAR30 | ||||
BETC | Business Event Type Code | FMFG_BETC | CHAR | 10 | CHAR10 | ||||
MOD_ALLOW | Modification Allowed | FMFG_MOD_ALLOW | CHAR | 1 | CHAR1 | ||||
CANCEL_ALLOW | Cancellation Allowed | FMFG_CANCEL_ALLOW | CHAR | 1 | CHAR1 | ||||
PAY_METHOD | List of the Payment Methods to be Considered | DZWELS | CHAR | 10 | ZWELS | ||||
BPN | Business Partner Number | FMFG_BPN | CHAR | 6 | T880 | ALPHA | RCOMP | ||
REP_FREQ | Reporting Frequency | FMFG_REP_FREQ | CHAR | 3 | CHAR3 | ||||
.INCLU--AP | 0 | ||||||||
LOGSYSB | Logical system with which document was created | LOGSYSB | CHAR | 10 | Assigned to domain | ALPHA | LOGSYS | ||
.INCLU--AP | 0 | ||||||||
KALCD | Procedure for Campaign Determination | KALCD | CHAR | 6 | Assigned to domain | KALSM | |||
MULTI | Multiple Campaigns/Trade Promotions Active Indicator | CMPC_MULT_CAMPAIGN | CHAR | 1 | CMPGN_MULT_CAMPAIGN | ||||
.INCLU--AP | 0 | ||||||||
SPPAYM | Payment Form for Special Payment Method | SPPAYM | CHAR | 2 | SPPAYM | ||||
.INCLU--AP | 0 | ||||||||
WTYSC_CLM_HDR | Claim header | WTYSC_CLM_HDR | CHAR | 16 | WTYSC_CLM_HDR | ||||
.INCLU--AP | 0 |
Key field | Non-key field |
How do I retrieve data from SAP structure MMVBAK using ABAP code?
As MMVBAK 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 MMVBAK as there is no data to select.How to access SAP table MMVBAK
Within an ECC or HANA version of SAP you can also view further information about MMVBAK 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