_DEFECTAFFECTEDOBJECT

_DEFECTAFFECTEDOBJECT is an SAP database table in S/4HANA. It contains 14 fields.

Fields (14)

KeyField CDS FieldsUsed in Views
KEY DefectAffectedObject DefectAffectedObject 1
KEY DefectInternalID DefectInternalID 1
Batch Batch 1
Defect Defect 1
DefectAffcdObjIsDefective DefectAffcdObjIsDefective 1
DefectAffcdObjQuantityUnit DefectAffcdObjQuantityUnit 1
DefectAffectedObjectQuantity DefectAffectedObjectQuantity 1
DefectAffectedObjectType DefectAffectedObjectType 1
Material Material 1
QltyTaskFllwUpActionSts QltyTaskFllwUpActionSts 1
QltyTaskFollowUpAction QltyTaskFollowUpAction 1
QltyTskFllwUpActnSimlnRslt QltyTskFllwUpActnSimlnRslt 1
QualityTask QualityTask 1
QualityTaskInternalId QualityTaskInternalId 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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE _DEFECTAFFECTEDOBJECT (
    DEFECTAFFECTEDOBJECT,
    DEFECTINTERNALID,
    BATCH,
    DEFECT,
    DEFECTAFFCDOBJISDEFECTIVE,
    DEFECTAFFCDOBJQUANTITYUNIT,
    DEFECTAFFECTEDOBJECTQUANTITY,
    DEFECTAFFECTEDOBJECTTYPE,
    MATERIAL,
    QLTYTASKFLLWUPACTIONSTS,
    QLTYTASKFOLLOWUPACTION,
    QLTYTSKFLLWUPACTNSIMLNRSLT,
    QUALITYTASK,
    QUALITYTASKINTERNALID,
    PRIMARY KEY (DEFECTAFFECTEDOBJECT, DEFECTINTERNALID)
);