I_QLTYPROCMTCERTTP

CDS View
33 Fields 2 CDS Views

Certificate Receipt

I_QLTYPROCMTCERTTP is a CDS View in S/4HANA. Certificate Receipt. It contains 33 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
C_QltyProcmtCertInspLot view inner CONSUMPTION Certificate Receipt
C_QltyProcmtCertMng view from CONSUMPTION Certificate Receipts

Fields (33)

KeyField CDS FieldsUsed in Views
KEY QualityProcurementCertificate QualityProcurementCertificate 2
_Material _Material 1
_MaterialDocumentItem _MaterialDocumentItem 1
_MaterialDocumentYear _MaterialDocumentYear 1
_Plant _Plant 1
_PurchasingDocument _PurchasingDocument 1
_PurchasingDocumentItem _PurchasingDocumentItem 1
_Supplier _Supplier 1
Batch Batch 1
BatchBySupplier BatchBySupplier 1
DeliveryNote DeliveryNote 1
GoodsReceiptPostingDate GoodsReceiptPostingDate 1
IsBusinessPurposeCompleted IsBusinessPurposeCompleted 2
Material Material 1
MaterialDocument MaterialDocument 1
MaterialDocumentItem MaterialDocumentItem 1
MaterialDocumentYear MaterialDocumentYear 1
Plant Plant 2
PurchaseOrder PurchaseOrder 1
PurchaseOrderItem PurchaseOrderItem 1
QltyProcmtCertChgdBy QltyProcmtCertChgdBy 1
QltyProcmtCertChgDte QltyProcmtCertChgDte 1
QltyProcmtCertChgDteTme QltyProcmtCertChgDteTme 1
QltyProcmtCertChgTme QltyProcmtCertChgTme 1
QltyProcmtCertCrtedByUsr QltyProcmtCertCrtedByUsr 1
QltyProcmtCertCrtnDateTime QltyProcmtCertCrtnDateTime 1
QltyProcmtCertCrtnDte QltyProcmtCertCrtnDte 1
QltyProcmtCertCrtnTme QltyProcmtCertCrtnTme 1
QltyProcmtCertCrtnTmeZn QltyProcmtCertCrtnTmeZn 1
QltyProcmtCertReceiptDate QltyProcmtCertReceiptDate 1
QltyProcmtCertStatus QltyProcmtCertStatus 1
QualityCertificateType QualityCertificateType 2
Supplier Supplier 1

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Certificate Receipt
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_QLTYPROCMTCERTTP (
    QUALITYPROCUREMENTCERTIFICATE,
    _MATERIAL,
    _MATERIALDOCUMENTITEM,
    _MATERIALDOCUMENTYEAR,
    _PLANT,
    _PURCHASINGDOCUMENT,
    _PURCHASINGDOCUMENTITEM,
    _SUPPLIER,
    BATCH,
    BATCHBYSUPPLIER,
    DELIVERYNOTE,
    GOODSRECEIPTPOSTINGDATE,
    ISBUSINESSPURPOSECOMPLETED,
    MATERIAL,
    MATERIALDOCUMENT,
    MATERIALDOCUMENTITEM,
    MATERIALDOCUMENTYEAR,
    PLANT,
    PURCHASEORDER,
    PURCHASEORDERITEM,
    QLTYPROCMTCERTCHGDBY,
    QLTYPROCMTCERTCHGDTE,
    QLTYPROCMTCERTCHGDTETME,
    QLTYPROCMTCERTCHGTME,
    QLTYPROCMTCERTCRTEDBYUSR,
    QLTYPROCMTCERTCRTNDATETIME,
    QLTYPROCMTCERTCRTNDTE,
    QLTYPROCMTCERTCRTNTME,
    QLTYPROCMTCERTCRTNTMEZN,
    QLTYPROCMTCERTRECEIPTDATE,
    QLTYPROCMTCERTSTATUS,
    QUALITYCERTIFICATETYPE,
    SUPPLIER,
    PRIMARY KEY (QUALITYPROCUREMENTCERTIFICATE)
);

Learn More