C_SrvcDocDateInformation

DDL: C_SRVCDOCDATEINFORMATION SQL: CSERVDOCAPPT Type: view CONSUMPTION
12 Fields 1 Data Sources 1 Associations

Date Information for Service Transaction

C_SrvcDocDateInformation is a Consumption CDS View that provides data about "Date Information for Service Transaction" in SAP S/4HANA. It reads from 1 data source (I_SrvcDocDateInformation) and exposes 12 fields with key fields SrvcMgmtObjectUUID, ServiceDocument, ServiceDocumentItem, SrvcDocAppointmentType. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_SrvcDocDateInformation _SrvcDateInfo from

Associations (1)

CardinalityTargetAliasCondition
[1..*] I_SrvcDocDurationUnitText _SrvcDocDurationUnitText $projection.SrvcDocDurationUnit = _SrvcDocDurationUnitText.SrvcDocDurationUnit and _SrvcDocDurationUnitText.Language = $session.system_language

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName CSERVDOCAPPT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
EndUserText.label Date Information for Service Transaction view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY SrvcMgmtObjectUUID SrvcMgmtObjectUUID
KEY ServiceDocument ServiceDocument Transaction ID
KEY ServiceDocumentItem ServiceDocumentItem Service Document
KEY SrvcDocAppointmentType SrvcDocAppointmentType Date Type
SrvcDocDurationTypeText SrvcDocDurationTypeText Date Type
SrvcDocApptStartDateTime SrvcDocApptStartDateTime Date/Time From
SrvcDocApptEndDateTime SrvcDocApptEndDateTime Date/Time To
ServiceObjectType ServiceObjectType Object Type
SrvcDocDurationCharValue SrvcDocDurationCharValue Duration
SrvcDocDurationUnit SrvcDocDurationUnit Unit
SrvcDocDurationUnitText _SrvcDocDurationUnitText SrvcDocDurationUnitText Unit
_SrvcDocDurationUnitText _SrvcDocDurationUnitText

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view C_SrvcDocDateInformation.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: CSERVDOCAPPT

CREATE VIEW C_SrvcDocDateInformation AS
SELECT
  SrvcMgmtObjectUUID,
  ServiceDocument,
  ServiceDocumentItem,
  SrvcDocAppointmentType,
  SrvcDocDurationTypeText,
  SrvcDocApptStartDateTime,
  SrvcDocApptEndDateTime,
  ServiceObjectType,
  SrvcDocDurationCharValue,
  SrvcDocDurationUnit,
  _SrvcDocDurationUnitText.SrvcDocDurationUnitText AS SrvcDocDurationUnitText
FROM I_SrvcDocDateInformation AS _SrvcDateInfo
LEFT OUTER JOIN I_SrvcDocDurationUnitText AS _SrvcDocDurationUnitText ON SrvcDocDurationUnit = _SrvcDocDurationUnitText.SrvcDocDurationUnit AND _SrvcDocDurationUnitText.Language = $session.system_language  -- association [1..*]
;

Learn More