QCERT_TS_BATCH SAP (Quality Certificate Data at Batch Level) Structure details
Description: Quality Certificate Data at Batch Level
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 |
KZBATCH | X and Blank | QKZ | CHAR | 1 | QKZ | ||||
VBDPL | 0 | ||||||||
VBELN | Sales and Distribution Document Number | VBELN | CHAR | 10 | ALPHA | VBELN | AUN | ||
POSNR | Item number of the SD document | POSNR | NUMC | 6 | POSNR | ||||
POSEX | Item Number of the Underlying Purchase Order | POSEX | CHAR | 6 | ALPHA | POSEX | |||
MATNR | Material Number | MATNR | CHAR | 18 | MATN1 | MATNR | MAT | S_MAT1 | |
MATWA | Material entered | MATWA | CHAR | 18 | MATN1 | MATNR | MAT | ||
IDNKD | Material Number Used by Customer | MATNR_KU | CHAR | 35 | IDNEX | ||||
ARKTX | Short text for sales order item | ARKTX | CHAR | 40 | TEXT40 | ||||
WERKS | Plant | WERKS_D | CHAR | 4 | WERKS | WRK | H_T001W_C | ||
LGORT | Storage Location | LGORT_D | CHAR | 4 | LGORT | LAG | |||
VTWEG | Distribution Channel | VTWEG | CHAR | 2 | VTWEG | VTW | C_VTWEG | ||
SPART | Division | SPART | CHAR | 2 | SPART | SPA | C_SPART | ||
VKBUR | Sales Office | VKBUR | CHAR | 4 | VKBUR | VKB | |||
CHARG | Batch Number | CHARG_D | CHAR | 10 | CHARG | CHA | |||
SERNR | BOM explosion number | SERNR | CHAR | 8 | SERNR | ||||
HERKL | Country of origin of the material | HERKL | CHAR | 3 | LAND1 | LND | |||
HERKR | Region of origin of material (non-preferential origin) | HERKR | CHAR | 3 | REGIO | ||||
STAWN | Commodity Code/Import Code Number for Foreign Trade | STAWN | CHAR | 17 | STAWN | ||||
BRGEW | Gross weight | BRGEW_15 | QUAN | 15(3) | MENG15 | ||||
NTGEW | Net weight | NTGEW_15 | QUAN | 15(3) | MENG15 | ||||
GEWEI | Weight Unit | GEWEI | UNIT | 3 | CUNIT | MEINS | |||
LFIMG | Actual quantity delivered (in sales units) | LFIMG | QUAN | 13(3) | MENG13 | ||||
VRKME | Sales unit | VRKME | UNIT | 3 | CUNIT | MEINS | |||
MBDAT | Material Staging/Availability Date | MBDAT | DATS | 8 | DATUM | ||||
VBELN_VAUF | Order | VBELN_VAUF | CHAR | 10 | ALPHA | VBELN | AUF | ||
POSNR_VAUF | Sales Document Item | POSNR_VA | NUMC | 6 | POSNR | APO | |||
AUDAT_VAUF | Sales order date | AUDAT_VAUF | DATS | 8 | DATUM | ||||
BSTDK | Customer purchase order date | BSTDK | DATS | 8 | DATUM | ||||
BSTNK | Customer purchase order number | BSTNK | CHAR | 20 | BSTNK | ||||
BSTZD | Purchase order number supplement | BSTZD | CHAR | 4 | BSTZD | ||||
IHREZ | Your Reference | IHREZ | CHAR | 12 | TEXT12 | ||||
INCO1 | Incoterms (Part 1) | INCO1 | CHAR | 3 | INCO1 | ||||
INCO2 | Incoterms (Part 2) | INCO2 | CHAR | 28 | INCO2 | ||||
INCO1_BEZ | Incoterm description | INCO1_BEZ | CHAR | 30 | TEXT30 | ||||
TDNAME | Name | TDOBNAME | CHAR | 70 | TDOBNAME | ||||
UEPOS | Higher-level item in bill of material structures | UEPOS | NUMC | 6 | POSNR | ||||
VOLUM | Volume | VOLUM_15 | QUAN | 15(3) | MENG15 | ||||
VOLEH | Volume unit | VOLEH | UNIT | 3 | CUNIT | MEINS | |||
EAN11 | International Article Number (EAN/UPC) | EAN11 | CHAR | 18 | EAN11 | EAN11 | EAN | ||
EXART | Business Transaction Type for Foreign Trade | EXART | CHAR | 2 | EXART | EXA | |||
EXART_BEZ | Description | BEZEI20 | CHAR | 20 | TEXT20 | ||||
GRWRT | Statistical value for foreign trade | GRWRT | CURR | 13(2) | GRWRT | ||||
VGBEL | Document number of the reference document | VGBEL | CHAR | 10 | ALPHA | VBELN | |||
VGPOS | Item number of the reference item | VGPOS | NUMC | 6 | POSNR | ||||
VGTYP | Activity or element category | VGTYP | CHAR | 3 | VORG_TYP | ||||
SORTKRI | Sort Criterion | SORTKRI | CHAR | 20 | CHAR20 | ||||
LGMNG | Actual quantity delivered in stockkeeping units | LGMNG | QUAN | 13(3) | MENG13 | ||||
KCMENG | Cumulative batch quantity of all split items (in StckUnit) | KCMENG | QUAN | 15(3) | MENG15 | ||||
MEINS | Base Unit of Measure | MEINS | UNIT | 3 | CUNIT | MEINS | |||
UECHA | Higher-Level Item of Batch Split Item | UECHA | NUMC | 6 | POSNR | ||||
KCBRGEW | Cumulative gross weight of all batch split items | KCBRGEW | QUAN | 15(3) | MENG15 | ||||
KCNTGEW | Cumulative net weight of all batch split items | KCNTGEW | QUAN | 15(3) | MENG15 | ||||
KCGEWEI | Weight unit for weight of all batch split items | KCGEWEI | UNIT | 3 | CUNIT | MEINS | |||
KCVOLUM | Cumulative volume of all batch split items | KCVOLUM | QUAN | 15(3) | MENG15 | ||||
KCVOLEH | Volume Unit for Volume of all Batch Split Items | KCVOLEH | UNIT | 3 | CUNIT | MEINS | |||
KNUMH_CH | Number of condition record from batch determination | KNUMH_CH | CHAR | 10 | KNUMB | ||||
UMVKZ | Numerator (factor) for conversion of sales quantity into SKU | UMVKZ | DEC | 5 | UMBSZ | ||||
UMVKN | Denominator (Divisor) for Conversion of Sales Qty into SKU | UMVKN | DEC | 5 | UMBSN | ||||
CUOBJ | Configuration | CUOBJ_VA | NUMC | 18 | CUOBJ | ||||
CUOBJ_CH | Internal object number of the batch classification | CUOBJ_CH | NUMC | 18 | CUOBJ | ||||
SHKZG | Returns Item | SHKZG_VA | CHAR | 1 | XFELD | ||||
PCKPF | Packing control | PCKPF | CHAR | 1 | PCKPF | ||||
ABRVW | Usage Indicator | ABRVW | CHAR | 3 | ABRVW | ||||
ABART | Release type | ABART | CHAR | 1 | ABART | ||||
ABRLI | Internal delivery schedule number | ABRLI | NUMC | 4 | ABRLI | ||||
AESKD | Customer Engineering Change Status | AESKD | CHAR | 17 | AESKD | ||||
EMPST | Receiving point | EMPST | CHAR | 25 | TEXT25 | ||||
ABTNR | Department number | ABTNR | CHAR | 4 | ABTNR | ||||
POSAR | Item type | POSAR | CHAR | 1 | POSAR | ||||
PSTYV | Delivery item category | PSTYV_VL | CHAR | 4 | PSTYV | ||||
TPREL | Indicator: Relevance for transport of deliv. item categories | TPREL | CHAR | 1 | XFELD | ||||
KZWI1 | Subtotal 1 from pricing procedure for condition | KZWI1 | CURR | 13(2) | WERTV7 | ||||
KPEIN | Condition pricing unit | KPEIN | DEC | 5 | KPEIN | ||||
KMEIN | Condition unit | KMEIN | UNIT | 3 | CUNIT | MEINS | |||
NETPR | Net price | NETPR | CURR | 11(2) | WERTV6 | ||||
NETWR | Net Value in Document Currency | NETWR | CURR | 15(2) | WERTV8 | ||||
ANZSN | Number of serial numbers | ANZSN | INT4 | 10 | INT4 | ||||
AKTNR | COUPON | WAKTION | CHAR | 10 | ALPHA | WAKTION | WAK | ||
SUGRD | Reason for material substitution | SUGRD | CHAR | 4 | SUGRD | VDG | |||
SUDRU | Original entry will be printed | SUDRU | CHAR | 1 | XFELD | ||||
VBRST | Customer point of consumption | VBRST | CHAR | 14 | CHAR14 | ||||
USR01_VBLB | Additional data field 1 for delivery schedules | USR01_D | CHAR | 35 | TEXT35 | ||||
USR02_VBLB | Additional data field 2 for delivery schedules | USR02_D | CHAR | 35 | TEXT35 | ||||
USR03_VBLB | Additional data field 3 for delivery schedules | USR03_D | CHAR | 35 | TEXT35 | ||||
USR04_VBLB | Additional data field 4 for delivery schedules | USR04_D | CHAR | 10 | CHAR10 | ||||
USR05_VBLB | Additional data field 5 for delivery schedules | USR05_D | CHAR | 10 | CHAR10 | ||||
PREFE | Preference indicator in export/import | PREFE | CHAR | 1 | PREFE | ||||
LABNK | Customer number for forecast / JIT dlv. sched. | LABNK | CHAR | 17 | TEXT17 | ||||
ABRDT | Delivery Schedule Date | ABRDT | DATS | 8 | DATUM | ||||
KZUMW | Environmentally Relevant | KZUMW | CHAR | 1 | XFELD | ||||
PROFL | Dangerous Goods Indicator Profile | ADGE_PROFL | CHAR | 3 | ADGD_PROFL | ||||
IDGPA | Relevant for Dangerous Goods Documents | ADGE_IDGPA | CHAR | 1 | X | ||||
IDGCH | Relevant for Dangerous Goods Checks | ADGE_IDGCH | CHAR | 1 | X | ||||
DGNTGEW | Dangerous goods - net weight | ADGE_NTGEW | QUAN | 15(3) | MENG15 | ||||
DGBRGEW | Dangerous Goods - Gross Weight | ADGE_BRGEW | QUAN | 15(3) | MENG15 | ||||
DGGEWEI | Weight Unit | GEWEI | UNIT | 3 | CUNIT | MEINS | |||
DGVOLUM | Dangerous goods - volume | ADGE_VOLUM | QUAN | 15(3) | MENG15 | ||||
DGVOLEH | Volume unit | VOLEH | UNIT | 3 | CUNIT | MEINS | |||
DGARAND | Exemption | ADGE_KARN | CHAR | 1 | X | ||||
DGREPQU | Indicator: Reportable quantity | ADGE_IRQA | CHAR | 1 | X | ||||
DGPULIM | Packed Under 450 l | ADGE_IPUL | CHAR | 1 | X | ||||
DGPAS | Listed Goods | ADGE_PAS | CHAR | 1 | X | ||||
DGMDDAT | Selection date dangerous goods master data | ADGE_MDDAT | DATS | 8 | DATUM | ||||
BSTKD | Customer purchase order number | BSTKD | CHAR | 35 | BSTKD | ||||
BSARK | Customer purchase order type | BSARK | CHAR | 4 | BSARK | ||||
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 | 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 | |||
VBKLT | SD document indicator | VBKLT | CHAR | 1 | VBKLT | ||||
MATKL | Material Group | MATKL | CHAR | 9 | MATKL | MKL | S_WBWG | ||
MTART | Material Type | MTART | CHAR | 4 | MTART | MTA | |||
PRODH | Product hierarchy | PRODH_D | CHAR | 18 | PRODH | VPR | |||
QMNUM | Notification No | QMNUM | CHAR | 12 | ALPHA | QMNUM | IQM | ||
QMDAT | Date of Notification | QMDAT | DATS | 8 | DATUM | ||||
MSR_ID | Process Identification Number | MSR_PROCESS_ID | CHAR | 10 | ALPHA | MSR_PROCESS_ID | |||
MSR_ITEM | Item Number | MSR_PROCESS_ITEM | NUMC | 6 | MSR_PROCESS_ITEM | ||||
RMA_CUSTOMER | Customer RMA Number | MSR_CRMA_NR | CHAR | 20 | MSR_RMA_NR | ||||
MSR_RET_REASON | Return Reason | MSR_RETURNS_REASON | CHAR | 3 | MSR_RETURNS_REASON | ||||
MSR_RET_REASON_TEXT | Return Reason Description | MSR_RET_REASON_TEXT | CHAR | 60 | TEXT60 | ||||
MSR_MAT_RECEIVED | Material Received | MSR_MATERIAL_RECEIVED | CHAR | 1 | XFELD | ||||
MSR_FU_CODE | Follow-Up Activity Code | MSR_FU_CODE | CHAR | 4 | MSR_FU_CODE | ||||
MSR_FU_CODE_TEXT | Follow-Up Activity Description | MSR_FU_CODE_TEXT | CHAR | 60 | TEXT60 | ||||
MSR_FORW_VENDOR | Account Number of Vendor or Creditor | LIFNR | CHAR | 10 | ALPHA | LIFNR | LIF | KRED_C | |
MSR_FWV_TITLE | Form-of-Address Key | AD_TITLE | CHAR | 4 | AD_TITLE | ||||
MSR_FWV_ADDRNUM | Address number | AD_ADDRNUM | CHAR | 10 | ALPHA | AD_ADDRNUM | ADR | ||
MSR_FWV_NAME1 | Name 1 | AD_NAME1 | CHAR | 40 | TEXT40 | ||||
MSR_FWV_NAME2 | Name 2 | AD_NAME2 | CHAR | 40 | TEXT40 | ||||
MSR_FWV_NAME3 | Name 3 | AD_NAME3 | CHAR | 40 | TEXT40 | ||||
MSR_FWV_NAME4 | Name 4 | AD_NAME4 | CHAR | 40 | TEXT40 | ||||
MSR_FWV_STREET | Street | AD_STREET | CHAR | 60 | TEXT60 | CLSTRTNAME | |||
MSR_FWV_PO_BOX | PO Box | AD_POBX | CHAR | 10 | CHAR10 | ||||
MSR_FWV_PO_BOX_LOC | PO Box city | AD_POBXLOC | CHAR | 40 | TEXT40 | CITY_NAME | |||
MSR_FWV_CITY_CODE2 | City PO box code (City file) | AD_CIT2NUM | CHAR | 12 | ALPHA | CITY_CODE | |||
MSR_FWV_COUNTRY | Country Key | LAND1 | CHAR | 3 | LAND1 | LND | |||
MSR_FWV_LANGU | Language Key | SPRAS | LANG | 1 | ISOLA | SPRAS | SPR | H_T002 | |
MSR_FWV_POST_CODE1 | City postal code | AD_PSTCD1 | CHAR | 10 | CHAR10 | ||||
MSR_FWV_CITY1 | City | AD_CITY1 | CHAR | 40 | TEXT40 | CLCITYNAME | |||
MSR_FWV_CITY2 | District | AD_CITY2 | CHAR | 40 | TEXT40 | CITY_PART | |||
MSR_FWV_REGION | STATE (State, Province, County) | REGIO | CHAR | 3 | REGIO | ||||
RMA_VENDOR | Vendor RMA Number | MSR_VRMA_NR | CHAR | 20 | MSR_RMA_NR | ||||
MSR_REFUND_CODE | Returns Refund Code | MSR_RETURNS_REFUND_CODE | CHAR | 3 | MSR_RETURNS_REFUND_CODE | ||||
MSR_REFUND_CODE_TEXT | Refund Code Description | MSR_REFUND_CODE_TEXT | CHAR | 60 | TEXT60 | ||||
MSR_FORW_PLANT1 | Plant | WERKS_D | CHAR | 4 | WERKS | WRK | H_T001W_C | ||
MSR_PLANT1_TXT | Name | NAME1 | CHAR | 30 | TEXT30 | ||||
MSR_FORW_PLANT2 | Plant | WERKS_D | CHAR | 4 | WERKS | WRK | H_T001W_C | ||
MSR_PLANT2_TXT | Name | NAME1 | CHAR | 30 | TEXT30 | ||||
MSR_FORW_PLANT3 | Plant | WERKS_D | CHAR | 4 | WERKS | WRK | H_T001W_C | ||
MSR_PLANT3_TXT | Name | NAME1 | CHAR | 30 | TEXT30 | ||||
DUMMY | Dummy function in length 1 | DUMMY | CHAR | 1 | DUMMY | ||||
.INCLU--AP | 0 | ||||||||
/BEV1/EMMVGR1 | Material group 1 | MVGR1 | CHAR | 3 | MVGR1 | ||||
/BEV1/EMMVGR2 | Material group 2 | MVGR2 | CHAR | 3 | MVGR2 | ||||
/BEV1/EMMVGR3 | Material group 3 | MVGR3 | CHAR | 3 | MVGR3 | ||||
/BEV1/EMMVGR4 | Material group 4 | MVGR4 | CHAR | 3 | MVGR4 | ||||
/BEV1/EMMVGR5 | Material group 5 | MVGR5 | CHAR | 3 | MVGR5 | ||||
/BEV1/EMNEUPOS | Item number of the SD document | POSNR | NUMC | 6 | POSNR | ||||
.INCLU--AP | 0 | ||||||||
LIFEXPOS | External item number | LIFEXPOS | NUMC | 6 | POSNR | ||||
MCHAR | 0 | ||||||||
ZEILC | Line Number | DZEILE | NUMC | 3 | ZEILE | POS | |||
MATNR | Material Number | MATNR | CHAR | 18 | MATN1 | MATNR | MAT | S_MAT1 | |
WERKS | Plant | WERKS_D | CHAR | 4 | WERKS | WRK | H_T001W_C | ||
LGORT | Storage Location | LGORT_D | CHAR | 4 | LGORT | LAG | |||
CHARG | Batch Number | CHARG_D | CHAR | 10 | CHARG | CHA | |||
BWTAR | Valuation Type | BWTAR_D | CHAR | 10 | BWTAR | BWT | |||
CLABS | Valuated Unrestricted-Use Stock | LABST | QUAN | 13(3) | MENG13V | ||||
MENGE | Quantity | MENGE_D | QUAN | 13(3) | MENG13 | ||||
MEINS | Base Unit of Measure | MEINS | UNIT | 3 | CUNIT | MEINS | |||
ERFMG | Quantity | MENGE_D | QUAN | 13(3) | MENG13 | ||||
ERFME | Base Unit of Measure | MEINS | UNIT | 3 | CUNIT | MEINS | |||
ZUSTD | Batch in Restricted-Use Stock | DZUSTD | CHAR | 1 | XFELD | ||||
ZUSCH | Batch status key | DZUSCH | CHAR | 1 | ZUSCH | ||||
BSTAR | Stock type | BSTAR | CHAR | 1 | BSTAR | ||||
SPERC | Physical Inventory Blocking Indicator | SPERR | CHAR | 1 | SPERR | ||||
XSELK | Item selected (selected, chosen, ...) | XSELP | CHAR | 1 | XFELD | ||||
KZICL | Physical inventory indicator for whse stock in current year | KZILL | CHAR | 3 | INVKZ | ||||
KZVCL | Physical inventory indicator for whse stock in current year | KZILL | CHAR | 3 | INVKZ | ||||
KZICQ | Physical inventory indicator for whse stock in current year | KZILL | CHAR | 3 | INVKZ | ||||
KZVCQ | Physical inventory indicator for whse stock in current year | KZILL | CHAR | 3 | INVKZ | ||||
KZICS | Physical inventory indicator for whse stock in current year | KZILL | CHAR | 3 | INVKZ | ||||
KZVCS | Physical inventory indicator for whse stock in current year | KZILL | CHAR | 3 | INVKZ | ||||
VERAB | Availability date | VERAB | DATS | 8 | DATUM | ||||
VFDAT | Shelf Life Expiration or Best-Before Date | VFDAT | DATS | 8 | DATUM | ||||
LVOCA | Deletion Flag for All Data on a Batch at a Plant | LVOCA | CHAR | 1 | XFELD | ||||
HERKR | Region of origin of material (non-preferential origin) | HERKR | CHAR | 3 | REGIO | ||||
HERKL | Country of origin of the material | HERKL | CHAR | 3 | LAND1 | LND | |||
MTVER | Export/import material group | MTVER | CHAR | 4 | MTVER | ||||
LIFCH | Vendor Account Number | ELIFN | CHAR | 10 | ALPHA | LIFNR | LIF | KRED_C | |
LICHA | Vendor Batch Number | LICHN | CHAR | 15 | LICHN | ||||
QNDAT | Next Inspection Date | QNPDAT | DATS | 8 | DATUM | ||||
ZAEDT | Date of last status change | DZAEDT | DATS | 8 | DATUM | ||||
FVDT1 | Date for unrestricted use | FVDAT | DATS | 8 | DATUM | ||||
FVDT2 | Date for unrestricted use | FVDAT | DATS | 8 | DATUM | ||||
FVDT3 | Date for unrestricted use | FVDAT | DATS | 8 | DATUM | ||||
FVDT4 | Date for unrestricted use | FVDAT | DATS | 8 | DATUM | ||||
FVDT5 | Date for unrestricted use | FVDAT | DATS | 8 | DATUM | ||||
FVDT6 | Date for unrestricted use | FVDAT | DATS | 8 | DATUM | ||||
LVOCB | Deletion Flag for All Data on a Batch Stock | LVOCB | CHAR | 1 | XFELD | ||||
HSDAT | Date of Manufacture | HSDAT | DATS | 8 | DATUM | ||||
LWEDT | Date of last goods receipt | LWEDT | DATS | 8 | DATUM | ||||
ERSDA | Created On | ERSDA | DATS | 8 | DATUM | ||||
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 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