I_SERVICEDOCUMENTDURATION

CDS View
12 Fields 24 CDS Views

Service Transaction Duration

I_SERVICEDOCUMENTDURATION is a CDS View in S/4HANA. Service Transaction Duration. It contains 12 fields. 24 CDS views read from this table.

CDS Views using this table (24)

ViewTypeJoinVDMDescription
A_SrvcConfDuration view from COMPOSITE Service Confirmation Duration
A_SrvcConfItemDuration view from COMPOSITE Service Confirmation Item Duration
A_SrvcOrdDuration view from COMPOSITE Service Order Duration
A_SrvcOrdItemDuration view from COMPOSITE Service Order Item Duration
A_SrvcOrdTmplDuration view from COMPOSITE Service Order Template Duration
A_SrvcOrdTmplItemDuration view from COMPOSITE Service Order Template Item Duration
I_ServiceDocumentDurationEnhcd view_entity from COMPOSITE Service Transaction Duration Enhanced
I_SrvcDocDateInformation view union_all COMPOSITE Date Information for Service Transaction
I_SubscriptionContractDuration view_entity from COMPOSITE Duration of Subscription Contract
I_SubscrpnContrItmDurn view_entity from COMPOSITE Duration of Contract Item
I_SubscrpnOrdItemDuration view_entity from COMPOSITE Item Duration
R_BusSolnOrdItmDurationTP view_entity from TRANSACTIONAL Business Solution Order Item Duration - TP
R_SrvcConfDurationTP view_entity from TRANSACTIONAL Service Confirmation Duration - TP
R_SrvcConfItemDurationTP view_entity from TRANSACTIONAL Service Confirmation Item Duration - TP
R_SrvcContrDurationTP view_entity from TRANSACTIONAL Service Contract Duration - TP
R_SrvcContrItemDurationTP view_entity from TRANSACTIONAL Service Contract Item Duration - TP
R_SrvcContrTmplDurationTP view_entity from TRANSACTIONAL Service Contract Template Duration - TP
R_SrvcContrTmplItemDurationTP view_entity from TRANSACTIONAL Duration of SrvcContr Template Item - TP
R_SrvcOrdDurationTP view_entity from TRANSACTIONAL Service Order Duration - TP
R_SrvcOrdItemDurationTP view_entity from TRANSACTIONAL Service Order Item Duration - TP
R_SrvcOrdTmplDurationTP view_entity from TRANSACTIONAL Service Order Template Duration - TP
R_SrvcOrdTmplItemDurationTP view_entity from TRANSACTIONAL Service Order Tmpl Item Duration - TP
R_SrvcQtanDurationTP view_entity from TRANSACTIONAL Service Quotation Duration - TP
R_SrvcQtanItemDurationTP view_entity from TRANSACTIONAL Service Quotation Item Duration - TP

Fields (12)

KeyField CDS FieldsUsed in Views
KEY ServiceDocument BusinessSolutionOrder,ServiceConfirmation,ServiceContract,ServiceContractTemplate,ServiceDocument,ServiceOrder,ServiceOrderTemplate,ServiceQuotation,SubscriptionContract,SubscriptionOrder 22
KEY ServiceDocumentItem BusinessSolutionOrderItem,ServiceConfirmationItem,ServiceContractTemplateItem,ServiceDocumentItem,ServiceOrderItem,ServiceOrderTemplateItem,SubscriptionContractItem,SubscriptionOrderItem 12
KEY ServiceObjectType ServiceObjectType 2
KEY SrvcDocAppointmentType SrvcDocAppointmentType 1
KEY SrvcDocDurationType SrvcDocDurationType,SubscrpnContrTmeDurnType,SubscrpnOrdDurationType 22
KEY SrvcMgmtObjectUUID SrvcMgmtObjectUUID 1
_DurationText _DurationText 1
_ServiceObjType _ServiceObjType 1
SrvcDocApptEndDateTime SrvcDocApptEndDateTime 1
SrvcDocApptStartDateTime SrvcDocApptStartDateTime 1
SrvcDocDurationUnit SrvcDocDurationUnit,SubscrpnContrTimeDurnUnit,SubscrpnOrdDurationUnit 23
SrvcDocDurationValue SrvcDocDurationValue,SubscrpnContrTmeDurnValue,SubscrpnOrdDurationValue 22

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.

-- Service Transaction Duration
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_SERVICEDOCUMENTDURATION (
    SERVICEDOCUMENT,
    SERVICEDOCUMENTITEM,
    SERVICEOBJECTTYPE,
    SRVCDOCAPPOINTMENTTYPE,
    SRVCDOCDURATIONTYPE,
    SRVCMGMTOBJECTUUID,
    _DURATIONTEXT,
    _SERVICEOBJTYPE,
    SRVCDOCAPPTENDDATETIME,
    SRVCDOCAPPTSTARTDATETIME,
    SRVCDOCDURATIONUNIT,
    SRVCDOCDURATIONVALUE,
    PRIMARY KEY (SERVICEDOCUMENT, SERVICEDOCUMENTITEM, SERVICEOBJECTTYPE, SRVCDOCAPPOINTMENTTYPE, SRVCDOCDURATIONTYPE, SRVCMGMTOBJECTUUID)
);

Learn More