I_SRVCDOCQUALIFICATION

CDS View

CRMS4 Qualification Details

I_SRVCDOCQUALIFICATION is a CDS View in S/4HANA. CRMS4 Qualification Details. It contains 7 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
A_SrvcOrdItemQualification view_entity from COMPOSITE Srvc Order Item Qualification Details
A_SrvcOrdQualification view_entity from CONSUMPTION Srvc Order Header Qualification Details

Fields (7)

KeyField CDS FieldsUsed in Views
KEY ServiceDocumentItem ServiceDocumentItem 1
KEY ServiceOrder ServiceOrder 1
KEY SrvcDocQualification SrvcDocQualification 2
SrvcDocQualifnIsMandatory SrvcDocQualifnIsMandatory 2
SrvcDocQualifnProficiencyValue SrvcDocQualifnProficiencyValue 2
SrvcDocQualifnValdtyEndDteTme SrvcDocQualifnValdtyEndDteTme 2
SrvcDocQualifnValdtyStrtDteTme SrvcDocQualifnValdtyStrtDteTme 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.

-- CRMS4 Qualification Details
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_SRVCDOCQUALIFICATION (
    SERVICEDOCUMENTITEM,
    SERVICEORDER,
    SRVCDOCQUALIFICATION,
    SRVCDOCQUALIFNISMANDATORY,
    SRVCDOCQUALIFNPROFICIENCYVALUE,
    SRVCDOCQUALIFNVALDTYENDDTETME,
    SRVCDOCQUALIFNVALDTYSTRTDTETME,
    PRIMARY KEY (SERVICEDOCUMENTITEM, SERVICEORDER, SRVCDOCQUALIFICATION)
);