I_QUALITYINPROCUREMENTTP

CDS View
32 Fields 4 CDS Views

Quality Info Record in Procurement

I_QUALITYINPROCUREMENTTP is a CDS View in S/4HANA. Quality Info Record in Procurement. It contains 32 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
A_QualityInProcurement view_entity from COMPOSITE Quality Info Record Data
C_QltyInProcurementManage view from CONSUMPTION Manage Quality Info Record in Procmt
C_QltyInProcurementObjPage view from CONSUMPTION Quality Info Record in Procurement
R_QualityInProcurementTP view_entity from TRANSACTIONAL Quality Info Record Data

Fields (32)

KeyField CDS FieldsUsed in Views
KEY Material Material 2
KEY QltyInProcmtIntID QltyInProcmtIntID 2
_Material _Material 2
_Plant _Plant 2
_ProcurementBlock _ProcurementBlock 1
_Supplier _Supplier 2
BaseUnit BaseUnit 2
BlockReason BlockReason,QltyInProcmtBlockReasonText 2
ChangedDateTime ChangedDateTime 2
CreatedByUser CreatedByUser 1
CreationDate CreationDate 1
InspectionLotType InspectionLotType 2
IsDeleted IsDeleted 2
LastChangeDate LastChangeDate 1
LastChangedByUser LastChangedByUser 1
Plant Plant 2
ProcurementBlock ProcurementBlock 2
ProdnPieceApprovalIsRequired ProdnPieceApprovalIsRequired 1
ProductionPieceApproval ProductionPieceApproval 2
ProductionPieceApprovalLevel ProductionPieceApprovalLevel 2
ProductionPieceApprovalStatus ProductionPieceApprovalStatus 2
QltyInProcmtCertfnValidTo QltyInProcmtCertfnValidTo 2
QltyInProcmtCertificateCtrl QltyInProcmtCertificateCtrl 2
QltyInProcmtHasLongText QltyInProcmtHasLongText 1
QltyInProcmtInspControl QltyInProcmtInspControl 2
QltyInProcmtLotCrtnLeadTime QltyInProcmtLotCrtnLeadTime 2
QltyInProcmtReleaseValidTo QltyInProcmtReleaseValidTo 2
QltyInProcmtRelQtyIsActive QltyInProcmtRelQtyIsActive 1
QualityManagementSystem QualityManagementSystem 2
ReleasedQuantity ReleasedQuantity 2
StatusProfile StatusProfile 1
Supplier Supplier 2

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.

-- Quality Info Record in Procurement
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_QUALITYINPROCUREMENTTP (
    MATERIAL,
    QLTYINPROCMTINTID,
    _MATERIAL,
    _PLANT,
    _PROCUREMENTBLOCK,
    _SUPPLIER,
    BASEUNIT,
    BLOCKREASON,
    CHANGEDDATETIME,
    CREATEDBYUSER,
    CREATIONDATE,
    INSPECTIONLOTTYPE,
    ISDELETED,
    LASTCHANGEDATE,
    LASTCHANGEDBYUSER,
    PLANT,
    PROCUREMENTBLOCK,
    PRODNPIECEAPPROVALISREQUIRED,
    PRODUCTIONPIECEAPPROVAL,
    PRODUCTIONPIECEAPPROVALLEVEL,
    PRODUCTIONPIECEAPPROVALSTATUS,
    QLTYINPROCMTCERTFNVALIDTO,
    QLTYINPROCMTCERTIFICATECTRL,
    QLTYINPROCMTHASLONGTEXT,
    QLTYINPROCMTINSPCONTROL,
    QLTYINPROCMTLOTCRTNLEADTIME,
    QLTYINPROCMTRELEASEVALIDTO,
    QLTYINPROCMTRELQTYISACTIVE,
    QUALITYMANAGEMENTSYSTEM,
    RELEASEDQUANTITY,
    STATUSPROFILE,
    SUPPLIER,
    PRIMARY KEY (MATERIAL, QLTYINPROCMTINTID)
);

Learn More