MASSQUOTHEAD SAP (Generated Table for View) Table View details
Dictionary Type: Table View
Description: Generated Table for View
Description: Generated Table for View
Table View field list including key, data, relationships and ABAP select examples
MASSQUOTHEAD is a standard SAP Table View which is used to store Generated Table for View data and is available within R/3 SAP systems depending on the version and release level.
The MASSQUOTHEAD table consists of various fields, each holding specific information or linking keys about Generated Table for View data available in SAP. These include VBELN (Sales Document), POSNR (Item number of the SD 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: Not classified
SAP MASSQUOTHEAD table view 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 |
MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
VBELN | Sales Document | VBELN_VA | CHAR | 10 | VBUK | ALPHA | VBELN | AUN | |
POSNR | Item number of the SD document | POSNR | NUMC | 6 | VBUP | POSNR | |||
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 | ||||
BSTZD | Purchase order number supplement | BSTZD | CHAR | 4 | BSTZD | ||||
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 | ALPHA | KOSTL | KOS | ||
STAFO | Update group for statistics update | STAFO | CHAR | 6 | 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 | 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 | TAXKD | ||||
TAXK2 | Tax classification 2 for customer | TAXK2 | CHAR | 1 | TAXKD | ||||
TAXK3 | Tax classification 3 for customer | TAXK3 | CHAR | 1 | TAXKD | ||||
TAXK4 | Tax Classification 4 Customer | TAXK4 | CHAR | 1 | TAXKD | ||||
TAXK5 | Tax classification 5 for customer | TAXK5 | CHAR | 1 | TAXKD | ||||
TAXK6 | Tax classification 6 for customer | TAXK6 | CHAR | 1 | TAXKD | ||||
TAXK7 | Tax classification 7 for customer | TAXK7 | CHAR | 1 | TAXKD | ||||
TAXK8 | Tax classification 8 for customer | TAXK8 | CHAR | 1 | TAXKD | ||||
TAXK9 | Tax classification 9 for customer | TAXK9 | CHAR | 1 | 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 | 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 | ||||
KONDA | Price group (customer) | KONDA | CHAR | 2 | T188 | KONDA | VKA | ||
KDGRP | Customer group | KDGRP | CHAR | 2 | T151 | KDGRP | VKD | ||
BZIRK | Sales district | BZIRK | CHAR | 6 | T171 | BZIRK | BZI | ||
PLTYP | Price list type | PLTYP | CHAR | 2 | T189 | PLTYP | VPL | ||
INCO1 | Incoterms (Part 1) | INCO1 | CHAR | 3 | TINC | INCO1 | |||
INCO2 | Incoterms (Part 2) | INCO2 | CHAR | 28 | INCO2 | ||||
KZAZU | Order Combination Indicator | KZAZU_D | CHAR | 1 | XFELD | ||||
PERFK | Invoice dates (calendar identification) | PERFK | CHAR | 2 | TFACD | WFCID | |||
PERRL | Invoice list schedule (calendar identification) | PERRL | CHAR | 2 | TFACD | WFCID | |||
MRNKZ | Manual invoice maintenance | MRNKZ | CHAR | 1 | XFELD | ||||
KURRF | Exchange rate for FI postings | KURRF | DEC | 9(5) | KURRF | ||||
VALTG | Additional value days | VALTG | NUMC | 2 | TAGE2 | ||||
VALDT | Fixed value date | VALDT | DATS | 8 | DATUM | ||||
ZTERM | Terms of Payment Key | DZTERM | CHAR | 4 | ZTERM | ||||
ZLSCH | Payment Method | SCHZW_BSEG | CHAR | 1 | T042Z | ZLSCH | |||
KTGRD | Account assignment group for this customer | KTGRD | CHAR | 2 | TVKT | KTGRD | |||
KURSK | Exchange Rate for Price Determination | KURSK | DEC | 9(5) | EXCRT | KURRF | |||
PRSDT | Date for pricing and exchange rate | PRSDT | DATS | 8 | DATUM | ||||
FKDAT | Billing date for billing index and printout | FKDAT | DATS | 8 | DATUM | ||||
FBUDA | Date on which services rendered | FBUDA | DATS | 8 | DATUM | ||||
GJAHR | Fiscal Year | GJAHR | NUMC | 4 | GJAHR | GJAHR | GJR | ||
POPER | Posting period | POPER | NUMC | 3 | POPER | POPR | |||
STCUR | Exchange rate for statistics | STCUR | DEC | 9(5) | EXCRT | KURRF | |||
MSCHL | Dunning key | MSCHL | CHAR | 1 | T040 | MSCHL | |||
MANSP | Dunning block | MANSP | CHAR | 1 | T040S | MANSP | |||
FPLNR | Billing plan number / invoicing plan number | FPLNR | CHAR | 10 | FPLA | FPLNR | |||
WAKTION | COUPON | WAKTION | CHAR | 10 | WAKH | ALPHA | WAKTION | WAK | |
ABSSC | Payment guarantee procedure | ABSSCHE_CM | CHAR | 6 | T691M | ABSSCHE_CM | |||
LCNUM | Financial doc. processing: Internal financial doc. number | LCNUM | CHAR | 10 | AKKP | ALPHA | LCNUM | AKN | |
J_1AFITP | Tax type | J_1AFITP_D | CHAR | 2 | J_1AFITP | J_1AFITP | |||
J_1ARFZ | Reason for zero VAT | J_1ARFZVAT | CHAR | 1 | J_1ARFZ | J_1ARFZVAT | |||
J_1AREGIO | STATE (State, Province, County) | REGIO | CHAR | 3 | T005S | REGIO | |||
J_1AGICD | Activity Code for Gross Income Tax | J_1AGICD_D | CHAR | 2 | J_1AGICD | J_1AGICD2 | |||
J_1ADTYP | Distribution Type for Employment Tax | J_1ADTYP_D | CHAR | 2 | J_1ADTYP | J_1ADTYP | |||
J_1ATXREL | Tax relevant classification | J_1ATXREL_ | CHAR | 10 | J_1ATXREL | J_1ATXREL | |||
ABTNR | Department number | ABTNR | CHAR | 4 | TSAB | ABTNR | |||
EMPST | Receiving point | EMPST | CHAR | 25 | TEXT25 | ||||
BSTKD | Customer purchase order number | BSTKD | CHAR | 35 | BSTKD | ||||
BSTDK | Customer purchase order date | BSTDK | DATS | 8 | DATUM | ||||
BSARK | Customer purchase order type | BSARK | CHAR | 4 | T176 | BSARK | |||
IHREZ | Your Reference | IHREZ | CHAR | 12 | TEXT12 | ||||
BSTKD_E | Ship-to Party's Purchase Order Number | BSTKD_E | CHAR | 35 | BSTKD | ||||
BSTDK_E | Ship-to party's PO date | BSTDK_E | DATS | 8 | DATUM | ||||
BSARK_E | Ship-to party purchase order type | BSARK_E | CHAR | 4 | T176 | BSARK | |||
IHREZ_E | Ship-to party character | IHREZ_E | CHAR | 12 | TEXT12 | ||||
POSEX_E | Item Number of the Underlying Purchase Order | POSEX_E | CHAR | 6 | ALPHA | POSEX | |||
KURSK_DAT | Translation Date | WWERT_D | DATS | 8 | DATUM | ||||
KURRF_DAT | Translation Date | WWERT_D | DATS | 8 | DATUM | ||||
KDKG1 | Customer condition group 1 | KDKG1 | CHAR | 2 | TVKGG | KDKGR | |||
KDKG2 | Customer condition group 2 | KDKG2 | CHAR | 2 | TVKGG | KDKGR | |||
KDKG3 | Customer condition group 3 | KDKG3 | CHAR | 2 | TVKGG | KDKGR | |||
KDKG4 | Customer condition group 4 | KDKG4 | CHAR | 2 | TVKGG | KDKGR | |||
KDKG5 | Customer condition group 5 | KDKG5 | CHAR | 2 | TVKGG | KDKGR | |||
WKWAE | Value contract currency | WKWAE | CUKY | 5 | TCURC | WAERS | |||
WKKUR | Exchange rate in value contract currency | WKKUR | DEC | 9(5) | KURRF | ||||
AKWAE | Currency key for letter-of-credit procg in foreign trade | AKWAE | CUKY | 5 | TCURC | WAERS | FWS | ||
AKKUR | Exchange rate for letter-of-credit procg in foreign trade | AKKUR | DEC | 9(5) | KURRF | ||||
AKPRZ | Depreciation percentage for financial document processing | AKPRZ | DEC | 5(2) | PRZ32 | ||||
J_1AINDXP | Inflation Index | J_1AINDXP | CHAR | 5 | J_1AINFT20 | J_1AINDXP | |||
J_1AIDATEP | Indexing base date | J_1AIDATES | DATS | 8 | J_1AUDATEP | ||||
BSTKD_M | Customer PO number as matchcode field | BSTKD_M | CHAR | 35 | CHAR35 | ||||
DELCO | Agreed delivery time | DELCO | CHAR | 3 | TVDC | DELCO | |||
FFPRF | Dynamic Item Processor Profile | AD01PROFNR | CHAR | 8 | AD01C_PROF | AD01PROFNR | AD0 | DIP_PROFILE | |
BEMOT | Accounting Indicator | BEMOT | CHAR | 2 | TBMOT | BEMOT | |||
FAKTF | Billing form | FAKTF | CHAR | 2 | FAKTF | ||||
RRREL | Revenue recognition category | RR_RELTYP | CHAR | 1 | RR_RELTYP | ||||
ACDATV | Proposed start date for accrual period | RR_ACDATV | CHAR | 1 | RR_ACDATV | ||||
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 | ||||
VSART | Shipping type | VSARTTR | CHAR | 2 | T173 | VERSART | |||
TRATY | Means-of-Transport Type | TRATY | CHAR | 4 | TVTY | TRATY | |||
TRMTYP | Means of Transport | TRMTYP | CHAR | 18 | MARA | MATN1 | MATNR | ||
SDABW | Special processing indicator | SDABW | CHAR | 4 | TVSAK | SDABW | |||
WMINR | Product catalog number | WMINR | CHAR | 10 | WWMI | WMINR | WMI | WPC1 |
Key field | Non-key field |
How do I retrieve data from SAP table MASSQUOTHEAD using ABAP code
The following ABAP code Example will allow you to do a basic selection on MASSQUOTHEAD to SELECT all data from the tableDATA: WA_MASSQUOTHEAD TYPE MASSQUOTHEAD.
SELECT SINGLE *
FROM MASSQUOTHEAD
INTO CORRESPONDING FIELDS OF WA_MASSQUOTHEAD
WHERE...
How to access SAP table MASSQUOTHEAD
Within an ECC or HANA version of SAP you can also view further information about MASSQUOTHEAD 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