I_SRVCDOCQUALIFICATION

CDS View

CRMS4 Qualification Details

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

CDS Views using this table (6)

ViewTypeJoinVDMDescription
A_BusSolnQtanItemQualification view_entity from CONSUMPTION Solution Quotation Qualification item Details
A_BusSolnQtanQualification view_entity from CONSUMPTION Solution Quotation Qualification header Details
A_SrvcOrdItemQualification view_entity from COMPOSITE Srvc Order Item Qualification Details
A_SrvcOrdQualification view_entity from CONSUMPTION Srvc Order Header Qualification Details
R_SrvcOrdItemQualificationTP view_entity from TRANSACTIONAL Service Order Item Qualification - TP
R_SrvcOrdQualificationTP view_entity from TRANSACTIONAL Service Order Qualification - TP

Fields (9)

KeyField CDS FieldsUsed in Views
KEY ServiceDocumentItem BusSolutionQuotationItem,ServiceDocumentItem,ServiceOrderItem 3
KEY ServiceObjectType ServiceObjectType 1
KEY ServiceOrder BusinessSolutionQuotation,ServiceOrder 4
KEY SrvcDocQualification SrvcDocQualification 6
SrvcDocQualifnIsMandatory SrvcDocQualifnIsMandatory 6
SrvcDocQualifnProficiencyValue SrvcDocQualifnProficiencyValue 6
SrvcDocQualifnValdtyEndDteTme SrvcDocQualifnValdtyEndDteTme 6
SrvcDocQualifnValdtyStrtDteTme SrvcDocQualifnValdtyStrtDteTme 6
SrvcDocQualifnWeightingValue SrvcDocQualifnWeightingValue 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,
    SERVICEOBJECTTYPE,
    SERVICEORDER,
    SRVCDOCQUALIFICATION,
    SRVCDOCQUALIFNISMANDATORY,
    SRVCDOCQUALIFNPROFICIENCYVALUE,
    SRVCDOCQUALIFNVALDTYENDDTETME,
    SRVCDOCQUALIFNVALDTYSTRTDTETME,
    SRVCDOCQUALIFNWEIGHTINGVALUE,
    PRIMARY KEY (SERVICEDOCUMENTITEM, SERVICEOBJECTTYPE, SERVICEORDER, SRVCDOCQUALIFICATION)
);