QCERT_TS_BATCH SAP (Quality Certificate Data at Batch Level) Structure details

Dictionary Type: Structure
Description: Quality Certificate Data at Batch Level




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




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

QCERT_TS_BATCH 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 "Quality Certificate Data at Batch Level" 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_QCERT_TS_BATCH TYPE QCERT_TS_BATCH.

The QCERT_TS_BATCH table consists of various fields, each holding specific information or linking keys about Quality Certificate Data at Batch Level data available in SAP. These include VBDPL (), VBELN (Sales and Distribution Document Number), POSNR (Item number of the SD document), POSEX (Item Number of the Underlying Purchase Order).. 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 (Deep)


SAP QCERT_TS_BATCH 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
KZBATCHX and Blank QKZCHAR1QKZ
VBDPL 0
VBELNSales and Distribution Document Number VBELNCHAR10ALPHAVBELNAUN
POSNRItem number of the SD document POSNRNUMC6POSNR
POSEXItem Number of the Underlying Purchase Order POSEXCHAR6ALPHAPOSEX
MATNRMaterial Number MATNRCHAR18MATN1MATNRMATS_MAT1
MATWAMaterial entered MATWACHAR18MATN1MATNRMAT
IDNKDMaterial Number Used by Customer MATNR_KUCHAR35IDNEX
ARKTXShort text for sales order item ARKTXCHAR40TEXT40
WERKSPlant WERKS_DCHAR4WERKSWRKH_T001W_C
LGORTStorage Location LGORT_DCHAR4LGORTLAG
VTWEGDistribution Channel VTWEGCHAR2VTWEGVTWC_VTWEG
SPARTDivision SPARTCHAR2SPARTSPAC_SPART
VKBURSales Office VKBURCHAR4VKBURVKB
CHARGBatch Number CHARG_DCHAR10CHARGCHA
SERNRBOM explosion number SERNRCHAR8SERNR
HERKLCountry of origin of the material HERKLCHAR3LAND1LND
HERKRRegion of origin of material (non-preferential origin) HERKRCHAR3REGIO
STAWNCommodity Code/Import Code Number for Foreign Trade STAWNCHAR17STAWN
BRGEWGross weight BRGEW_15QUAN15(3) MENG15
NTGEWNet weight NTGEW_15QUAN15(3) MENG15
GEWEIWeight Unit GEWEIUNIT3CUNITMEINS
LFIMGActual quantity delivered (in sales units) LFIMGQUAN13(3) MENG13
VRKMESales unit VRKMEUNIT3CUNITMEINS
MBDATMaterial Staging/Availability Date MBDATDATS8DATUM
VBELN_VAUFOrder VBELN_VAUFCHAR10ALPHAVBELNAUF
POSNR_VAUFSales Document Item POSNR_VANUMC6POSNRAPO
AUDAT_VAUFSales order date AUDAT_VAUFDATS8DATUM
BSTDKCustomer purchase order date BSTDKDATS8DATUM
BSTNKCustomer purchase order number BSTNKCHAR20BSTNK
BSTZDPurchase order number supplement BSTZDCHAR4BSTZD
IHREZYour Reference IHREZCHAR12TEXT12
INCO1Incoterms (Part 1) INCO1CHAR3INCO1
INCO2Incoterms (Part 2) INCO2CHAR28INCO2
INCO1_BEZIncoterm description INCO1_BEZCHAR30TEXT30
TDNAMEName TDOBNAMECHAR70TDOBNAME
UEPOSHigher-level item in bill of material structures UEPOSNUMC6POSNR
VOLUMVolume VOLUM_15QUAN15(3) MENG15
VOLEHVolume unit VOLEHUNIT3CUNITMEINS
EAN11International Article Number (EAN/UPC) EAN11CHAR18EAN11EAN11EAN
EXARTBusiness Transaction Type for Foreign Trade EXARTCHAR2EXARTEXA
EXART_BEZDescription BEZEI20CHAR20TEXT20
GRWRTStatistical value for foreign trade GRWRTCURR13(2) GRWRT
VGBELDocument number of the reference document VGBELCHAR10ALPHAVBELN
VGPOSItem number of the reference item VGPOSNUMC6POSNR
VGTYPActivity or element category VGTYPCHAR3VORG_TYP
SORTKRISort Criterion SORTKRICHAR20CHAR20
LGMNGActual quantity delivered in stockkeeping units LGMNGQUAN13(3) MENG13
KCMENGCumulative batch quantity of all split items (in StckUnit) KCMENGQUAN15(3) MENG15
MEINSBase Unit of Measure MEINSUNIT3CUNITMEINS
UECHAHigher-Level Item of Batch Split Item UECHANUMC6POSNR
KCBRGEWCumulative gross weight of all batch split items KCBRGEWQUAN15(3) MENG15
KCNTGEWCumulative net weight of all batch split items KCNTGEWQUAN15(3) MENG15
KCGEWEIWeight unit for weight of all batch split items KCGEWEIUNIT3CUNITMEINS
KCVOLUMCumulative volume of all batch split items KCVOLUMQUAN15(3) MENG15
KCVOLEHVolume Unit for Volume of all Batch Split Items KCVOLEHUNIT3CUNITMEINS
KNUMH_CHNumber of condition record from batch determination KNUMH_CHCHAR10KNUMB
UMVKZNumerator (factor) for conversion of sales quantity into SKU UMVKZDEC5UMBSZ
UMVKNDenominator (Divisor) for Conversion of Sales Qty into SKU UMVKNDEC5UMBSN
CUOBJConfiguration CUOBJ_VANUMC18CUOBJ
CUOBJ_CHInternal object number of the batch classification CUOBJ_CHNUMC18CUOBJ
SHKZGReturns Item SHKZG_VACHAR1XFELD
PCKPFPacking control PCKPFCHAR1PCKPF
ABRVWUsage Indicator ABRVWCHAR3ABRVW
ABARTRelease type ABARTCHAR1ABART
ABRLIInternal delivery schedule number ABRLINUMC4ABRLI
AESKDCustomer Engineering Change Status AESKDCHAR17AESKD
EMPSTReceiving point EMPSTCHAR25TEXT25
ABTNRDepartment number ABTNRCHAR4ABTNR
POSARItem type POSARCHAR1POSAR
PSTYVDelivery item category PSTYV_VLCHAR4PSTYV
TPRELIndicator: Relevance for transport of deliv. item categories TPRELCHAR1XFELD
KZWI1Subtotal 1 from pricing procedure for condition KZWI1CURR13(2) WERTV7
KPEINCondition pricing unit KPEINDEC5KPEIN
KMEINCondition unit KMEINUNIT3CUNITMEINS
NETPRNet price NETPRCURR11(2) WERTV6
NETWRNet Value in Document Currency NETWRCURR15(2) WERTV8
ANZSNNumber of serial numbers ANZSNINT410INT4
AKTNRCOUPON WAKTIONCHAR10ALPHAWAKTIONWAK
SUGRDReason for material substitution SUGRDCHAR4SUGRDVDG
SUDRUOriginal entry will be printed SUDRUCHAR1XFELD
VBRSTCustomer point of consumption VBRSTCHAR14CHAR14
USR01_VBLBAdditional data field 1 for delivery schedules USR01_DCHAR35TEXT35
USR02_VBLBAdditional data field 2 for delivery schedules USR02_DCHAR35TEXT35
USR03_VBLBAdditional data field 3 for delivery schedules USR03_DCHAR35TEXT35
USR04_VBLB Additional data field 4 for delivery schedules USR04_DCHAR10CHAR10
USR05_VBLBAdditional data field 5 for delivery schedules USR05_DCHAR10CHAR10
PREFEPreference indicator in export/import PREFECHAR1PREFE
LABNKCustomer number for forecast / JIT dlv. sched. LABNKCHAR17TEXT17
ABRDTDelivery Schedule Date ABRDTDATS8DATUM
KZUMWEnvironmentally Relevant KZUMWCHAR1XFELD
PROFLDangerous Goods Indicator Profile ADGE_PROFLCHAR3ADGD_PROFL
IDGPARelevant for Dangerous Goods Documents ADGE_IDGPACHAR1X
IDGCHRelevant for Dangerous Goods Checks ADGE_IDGCHCHAR1X
DGNTGEWDangerous goods - net weight ADGE_NTGEWQUAN15(3) MENG15
DGBRGEWDangerous Goods - Gross Weight ADGE_BRGEWQUAN15(3) MENG15
DGGEWEIWeight Unit GEWEIUNIT3CUNITMEINS
DGVOLUMDangerous goods - volume ADGE_VOLUMQUAN15(3) MENG15
DGVOLEHVolume unit VOLEHUNIT3CUNITMEINS
DGARANDExemption ADGE_KARNCHAR1X
DGREPQUIndicator: Reportable quantity ADGE_IRQACHAR1X
DGPULIMPacked Under 450 l ADGE_IPULCHAR1X
DGPASListed Goods ADGE_PASCHAR1X
DGMDDATSelection date dangerous goods master data ADGE_MDDATDATS8DATUM
BSTKDCustomer purchase order number BSTKDCHAR35BSTKD
BSARKCustomer purchase order type BSARKCHAR4BSARK
BSTKD_EShip-to Party's Purchase Order Number BSTKD_ECHAR35BSTKD
BSTDK_EShip-to party's PO date BSTDK_EDATS8DATUM
BSARK_EShip-to party purchase order type BSARK_ECHAR4BSARK
IHREZ_EShip-to party character IHREZ_ECHAR12TEXT12
POSEX_EItem Number of the Underlying Purchase Order POSEX_ECHAR6ALPHAPOSEX
VBKLTSD document indicator VBKLTCHAR1VBKLT
MATKLMaterial Group MATKLCHAR9MATKLMKLS_WBWG
MTARTMaterial Type MTARTCHAR4MTARTMTA
PRODHProduct hierarchy PRODH_DCHAR18PRODHVPR
QMNUMNotification No QMNUMCHAR12ALPHAQMNUMIQM
QMDATDate of Notification QMDATDATS8DATUM
MSR_IDProcess Identification Number MSR_PROCESS_IDCHAR10ALPHAMSR_PROCESS_ID
MSR_ITEMItem Number MSR_PROCESS_ITEMNUMC6MSR_PROCESS_ITEM
RMA_CUSTOMERCustomer RMA Number MSR_CRMA_NRCHAR20MSR_RMA_NR
MSR_RET_REASONReturn Reason MSR_RETURNS_REASONCHAR3MSR_RETURNS_REASON
MSR_RET_REASON_TEXTReturn Reason Description MSR_RET_REASON_TEXTCHAR60TEXT60
MSR_MAT_RECEIVEDMaterial Received MSR_MATERIAL_RECEIVEDCHAR1XFELD
MSR_FU_CODEFollow-Up Activity Code MSR_FU_CODECHAR4MSR_FU_CODE
MSR_FU_CODE_TEXTFollow-Up Activity Description MSR_FU_CODE_TEXTCHAR60TEXT60
MSR_FORW_VENDORAccount Number of Vendor or Creditor LIFNRCHAR10ALPHALIFNRLIFKRED_C
MSR_FWV_TITLEForm-of-Address Key AD_TITLECHAR4AD_TITLE
MSR_FWV_ADDRNUMAddress number AD_ADDRNUMCHAR10ALPHAAD_ADDRNUMADR
MSR_FWV_NAME1Name 1 AD_NAME1CHAR40TEXT40
MSR_FWV_NAME2Name 2 AD_NAME2CHAR40TEXT40
MSR_FWV_NAME3Name 3 AD_NAME3CHAR40TEXT40
MSR_FWV_NAME4Name 4 AD_NAME4CHAR40TEXT40
MSR_FWV_STREETStreet AD_STREETCHAR60TEXT60CLSTRTNAME
MSR_FWV_PO_BOXPO Box AD_POBXCHAR10CHAR10
MSR_FWV_PO_BOX_LOCPO Box city AD_POBXLOCCHAR40TEXT40CITY_NAME
MSR_FWV_CITY_CODE2City PO box code (City file) AD_CIT2NUMCHAR12ALPHACITY_CODE
MSR_FWV_COUNTRYCountry Key LAND1CHAR3LAND1LND
MSR_FWV_LANGULanguage Key SPRASLANG1ISOLASPRASSPRH_T002
MSR_FWV_POST_CODE1City postal code AD_PSTCD1CHAR10CHAR10
MSR_FWV_CITY1City AD_CITY1CHAR40TEXT40CLCITYNAME
MSR_FWV_CITY2District AD_CITY2CHAR40TEXT40CITY_PART
MSR_FWV_REGIONSTATE (State, Province, County) REGIOCHAR3REGIO
RMA_VENDORVendor RMA Number MSR_VRMA_NRCHAR20MSR_RMA_NR
MSR_REFUND_CODEReturns Refund Code MSR_RETURNS_REFUND_CODECHAR3MSR_RETURNS_REFUND_CODE
MSR_REFUND_CODE_TEXTRefund Code Description MSR_REFUND_CODE_TEXTCHAR60TEXT60
MSR_FORW_PLANT1Plant WERKS_DCHAR4WERKSWRKH_T001W_C
MSR_PLANT1_TXTName NAME1CHAR30TEXT30
MSR_FORW_PLANT2Plant WERKS_DCHAR4WERKSWRKH_T001W_C
MSR_PLANT2_TXTName NAME1CHAR30TEXT30
MSR_FORW_PLANT3Plant WERKS_DCHAR4WERKSWRKH_T001W_C
MSR_PLANT3_TXTName NAME1CHAR30TEXT30
DUMMYDummy function in length 1 DUMMYCHAR1DUMMY
.INCLU--AP 0
/BEV1/EMMVGR1Material group 1 MVGR1CHAR3MVGR1
/BEV1/EMMVGR2Material group 2 MVGR2CHAR3MVGR2
/BEV1/EMMVGR3Material group 3 MVGR3CHAR3MVGR3
/BEV1/EMMVGR4Material group 4 MVGR4CHAR3MVGR4
/BEV1/EMMVGR5Material group 5 MVGR5CHAR3MVGR5
/BEV1/EMNEUPOSItem number of the SD document POSNRNUMC6POSNR
.INCLU--AP 0
LIFEXPOSExternal item number LIFEXPOSNUMC6POSNR
MCHAR 0
ZEILCLine Number DZEILENUMC3ZEILEPOS
MATNRMaterial Number MATNRCHAR18MATN1MATNRMATS_MAT1
WERKSPlant WERKS_DCHAR4WERKSWRKH_T001W_C
LGORTStorage Location LGORT_DCHAR4LGORTLAG
CHARGBatch Number CHARG_DCHAR10CHARGCHA
BWTARValuation Type BWTAR_DCHAR10BWTARBWT
CLABSValuated Unrestricted-Use Stock LABSTQUAN13(3) MENG13V
MENGEQuantity MENGE_DQUAN13(3) MENG13
MEINSBase Unit of Measure MEINSUNIT3CUNITMEINS
ERFMGQuantity MENGE_DQUAN13(3) MENG13
ERFMEBase Unit of Measure MEINSUNIT3CUNITMEINS
ZUSTDBatch in Restricted-Use Stock DZUSTDCHAR1XFELD
ZUSCHBatch status key DZUSCHCHAR1ZUSCH
BSTARStock type BSTARCHAR1BSTAR
SPERCPhysical Inventory Blocking Indicator SPERRCHAR1SPERR
XSELKItem selected (selected, chosen, ...) XSELPCHAR1XFELD
KZICLPhysical inventory indicator for whse stock in current year KZILLCHAR3INVKZ
KZVCLPhysical inventory indicator for whse stock in current year KZILLCHAR3INVKZ
KZICQPhysical inventory indicator for whse stock in current year KZILLCHAR3INVKZ
KZVCQPhysical inventory indicator for whse stock in current year KZILLCHAR3INVKZ
KZICSPhysical inventory indicator for whse stock in current year KZILLCHAR3INVKZ
KZVCSPhysical inventory indicator for whse stock in current year KZILLCHAR3INVKZ
VERABAvailability date VERABDATS8DATUM
VFDATShelf Life Expiration or Best-Before Date VFDATDATS8DATUM
LVOCADeletion Flag for All Data on a Batch at a Plant LVOCACHAR1XFELD
HERKRRegion of origin of material (non-preferential origin) HERKRCHAR3REGIO
HERKLCountry of origin of the material HERKLCHAR3LAND1LND
MTVERExport/import material group MTVERCHAR4MTVER
LIFCHVendor Account Number ELIFNCHAR10ALPHALIFNRLIFKRED_C
LICHAVendor Batch Number LICHNCHAR15LICHN
QNDATNext Inspection Date QNPDATDATS8DATUM
ZAEDTDate of last status change DZAEDTDATS8DATUM
FVDT1Date for unrestricted use FVDATDATS8DATUM
FVDT2Date for unrestricted use FVDATDATS8DATUM
FVDT3Date for unrestricted use FVDATDATS8DATUM
FVDT4Date for unrestricted use FVDATDATS8DATUM
FVDT5Date for unrestricted use FVDATDATS8DATUM
FVDT6Date for unrestricted use FVDATDATS8DATUM
LVOCBDeletion Flag for All Data on a Batch Stock LVOCBCHAR1XFELD
HSDATDate of Manufacture HSDATDATS8DATUM
LWEDTDate of last goods receipt LWEDTDATS8DATUM
ERSDACreated On ERSDADATS8DATUM
LOT_TAB 0

Key field Non-key field



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

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

How to access SAP table QCERT_TS_BATCH

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