C_QualityCertificateEmail

Quality Certificate Email | view: CQLTYCERTEMAIL | TRAN | Extraction: Not supported | Component: Quality Certificates
Tables used: LIKP, LIPS
Column Name Description
DeliveryDocument FK Delivery
DeliveryDocumentItem Delivery Item
Column Name Description
Column Name Description
Column Name Description
Column Name Description
OverallGoodsMovementStatus Goods Movement Status (All Items) Show values
OverallPickingStatus Picking Status/Putaway Status (All Items) Show values
SDDocumentCategory SD Document Category Show values
Column Name Description Domain name
MaterialByCustomer Customer Material IDNEX
Master Data Relations Join Conditions
Delivery item category
  • Client
  • Delivery item category
  • C_QUALITYCERTIFICATEEMAIL.MANDT == TVPT.MANDT
  • C_QUALITYCERTIFICATEEMAIL.DELIVERYDOCUMENTITEMCATEGORY == TVPT.PSTYV
Delivery Type
  • Delivery Type
  • Client
  • C_QUALITYCERTIFICATEEMAIL.DELIVERYDOCUMENTTYPE == TVLK.LFART
  • C_QUALITYCERTIFICATEEMAIL.MANDT == TVLK.MANDT
Distribution Channel
  • Client
  • Distribution Channel
  • C_QUALITYCERTIFICATEEMAIL.MANDT == TVTW.MANDT
  • C_QUALITYCERTIFICATEEMAIL.DISTRIBUTIONCHANNEL == TVTW.VTWEG
Division
  • Client
  • Division
  • C_QUALITYCERTIFICATEEMAIL.MANDT == TSPA.MANDT
  • C_QUALITYCERTIFICATEEMAIL.DIVISION == TSPA.SPART
Material Number
  • Material Number
  • Client
  • C_QUALITYCERTIFICATEEMAIL.MATERIAL == MARA.MATNR
  • C_QUALITYCERTIFICATEEMAIL.MANDT == MARA.MANDT
Material Group
  • Material Group
  • Client
  • C_QUALITYCERTIFICATEEMAIL.MATERIALGROUP == T023.MATKL
  • C_QUALITYCERTIFICATEEMAIL.MANDT == T023.MANDT
Material type
  • Material type
  • Client
  • C_QUALITYCERTIFICATEEMAIL.MATERIALTYPEPRIMARY == T134.MTART
  • C_QUALITYCERTIFICATEEMAIL.MANDT == T134.MANDT
Plant
  • Client
  • Plant
  • C_QUALITYCERTIFICATEEMAIL.MANDT == T001W.MANDT
  • C_QUALITYCERTIFICATEEMAIL.PLANT == T001W.WERKS
Sales Organization
  • Client
  • Sales Organization
  • C_QUALITYCERTIFICATEEMAIL.MANDT == TVKO.MANDT
  • C_QUALITYCERTIFICATEEMAIL.SALESORGANIZATION == TVKO.VKORG
Shipping Point / Receiving Point
  • Client
  • Shipping Point / Receiving Point
  • C_QUALITYCERTIFICATEEMAIL.MANDT == TVST.MANDT
  • C_QUALITYCERTIFICATEEMAIL.SHIPPINGPOINT == TVST.VSTEL
Ship-to Party
  • Ship-to Party
  • Client
  • C_QUALITYCERTIFICATEEMAIL.SHIPTOPARTY == KNA1.KUNNR
  • C_QUALITYCERTIFICATEEMAIL.MANDT == KNA1.MANDT
Sold-to Party
  • Sold-to Party
  • Client
  • C_QUALITYCERTIFICATEEMAIL.SOLDTOPARTY == KNA1.KUNNR
  • C_QUALITYCERTIFICATEEMAIL.MANDT == KNA1.MANDT