C_BatchCertificate

Worklist Page for Quality Certificate for Batches | view: CBATCHCERTI | Extraction: Not supported | Component: Certificate Creation
Tables used: MCH1MCHAMAKTT001WMARCTCUCH
Column Name Description
Batch Batch Number
Material FK Material Number
Plant Plant
Column Name Description
Column Name Description
Column Name Description
MatlBatchAvailabilityDate Availability date
ShelfLifeExpirationDate Shelf Life Expiration or Best-Before Date
ManufactureDate Date of Manufacture
NextInspectionDate Next Inspection Date
LastGoodsReceiptDate Date of last goods receipt
Column Name Description
BatchIsMarkedForDeletion Deletion Flag for All Data in a Batch Show values
MatlBatchIsInRstrcdUseStock Batch in Restricted-Use Stock Show values
IsSubordinateBatch Subordinate Batch Show values
QltyCertRecipientType Quality Certificate Message Partner Type Show values
Column Name Description Domain name
MaterialName Material Description
PlantName Plant Name
BatchBySupplier Supplier Batch Number LICHN
BatchIdentifyingPlant Plant WERKS
CreationDateTime Created On Timestamp TZNTSTMPL
LastChangeDateTime Last Change Timestamp TZNTSTMPL
ClfnObjectInternalID Internal object no.: Batch classification CUOBJ
BatchExtWhseMgmtInternalId Batch ID
StockSegment Stock Segment SGT_SRCA
InventoryValuationType Valuation Type BWTAR
BatchShortDescription Short text for batch TEXT40
Customer Customer Number KUNNR
CustomerName Name of Customer TEXT80
Country Country/Region Key LAND1
CityName City TEXT35
PostalCode Postal Code PSTLZ
EmailAddress E-Mail Address AD_SMTPADR
QltyCertificateProfile Certificate Profile ID QVORLNR
QualityCertificateType Certificate Type QZGTYP
QltyCertProfileVersion Version Number of Certificate Profile QVERSNR
QltyCertRecipientNumber Message partner NA_PARNR
Master Data Relations Join Conditions
Country/Region of Origin of Material (Non-Preferential Ori.)
  • Country/Region of Origin of Material (Non-Preferential Ori.)
  • Client
  • C_BATCHCERTIFICATE.COUNTRYOFORIGIN == T005.LAND1
  • C_BATCHCERTIFICATE.MANDT == T005.MANDT
Material Number
  • Client
  • Material Number
  • C_BATCHCERTIFICATE.MANDT == MARA.MANDT
  • C_BATCHCERTIFICATE.MATERIAL == MARA.MATNR
Region of Origin of Material (Non-Preferential Origin)
  • Country/Region of Origin of Material (Non-Preferential Ori.)
  • Client
  • Region of Origin of Material (Non-Preferential Origin)
  • C_BATCHCERTIFICATE.COUNTRYOFORIGIN == T005S.LAND1
  • C_BATCHCERTIFICATE.MANDT == T005S.MANDT
  • C_BATCHCERTIFICATE.REGIONOFORIGIN == T005S.BLAND
Vendor's account number
  • Vendor's account number
  • Client
  • C_BATCHCERTIFICATE.SUPPLIER == LFA1.LIFNR
  • C_BATCHCERTIFICATE.MANDT == LFA1.MANDT