P_SRVCTRANSACTIONISSUETIMESTMP

DDL: P_SRVCTRANSACTIONISSUETIMESTMP Type: view_entity COMPOSITE Package: CRMS4_ANALYTICS_SERVICE_ORDER
46 Fields 1 Data Sources

View for items with issue C001/C001 - No Confirmation

P_SRVCTRANSACTIONISSUETIMESTMP is a Composite CDS View that provides data about "View for items with issue C001/C001 - No Confirmation" in SAP S/4HANA. It reads from 1 data source (I_ServiceDocumentItemEnhcd) and exposes 46 fields with key fields ServiceObjectType, ServiceDocument, ServiceDocumentItem, CustMgmtIssue, SrvcConfIssue. Part of development package CRMS4_ANALYTICS_SERVICE_ORDER.

Data Sources (1)

SourceAliasJoin Type
I_ServiceDocumentItemEnhcd I_ServiceDocumentItemEnhcd from

Annotations (4)

NameValueLevelField
AbapCatalog.dataMaintenance #DISPLAY_ONLY view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.private true view
VDM.viewType #COMPOSITE view

Fields (46)

KeyFieldSource TableSource FieldDescription
KEY ServiceObjectType ServiceObjectType Object Type
KEY ServiceDocument ServiceDocument Transaction ID
KEY ServiceDocumentItem ServiceDocumentItem Service Document
KEY CustMgmtIssue
KEY SrvcConfIssue
ServiceDocumentType
Country
Region
ServiceRisk
ServiceDocumentProblemCategory
TransactionCurrency
SrvcOrdGrossAmount ServiceDocItemGrossAmount
Industry Industry Industry Sector
ServiceOrganization ServiceOrganization
SalesOrganization SalesOrganization Sales Organization
SalesOffice SalesOffice Sales Office
SalesGroup SalesGroup Sales Group
DistributionChannel DistributionChannel RefDistCh-Cust/Mat.
Division Division Internal Division ID
SoldToPartyCountry SoldToPartyCountry
SoldToPartyRegion SoldToPartyRegion
SoldToParty SoldToParty Sold-to Party
ResponsibleEmployee ResponsibleEmployee Employee Resp.
ContactPerson ContactPerson Contact Person Key
ServiceTeam ServiceTeam
ServiceEmployee ServiceEmployee
ServiceDocItemRejectionReason ServiceDocItemRejectionReason
ServiceDocumentItemStatus ServiceDocumentItemStatus
ServiceDocumentItemHasError ServiceDocumentItemHasError
BillingBlockReason BillingBlockReason
ServiceDocItemBillingStatus ServiceDocItemBillingStatus
SrvcDocItmIsReleasedForBilling SrvcDocItmIsReleasedForBilling
SrvcDocItemTransferStatus SrvcDocItemTransferStatus
RequestedServiceStartDateTime RequestedServiceStartDateTime
RequestedServiceEndDateTime RequestedServiceEndDateTime
PlannedServiceStartDateTime PlannedServiceStartDateTime
PlannedServiceEndDateTime PlannedServiceEndDateTime
SrvcDocItemSLADueByDateTime SrvcDocItemSLADueByDateTime
ResponseProfile ResponseProfile Response Prof.
ServiceProfile ServiceProfile Service Profile
ServiceFirstResponseByDateTime ServiceFirstResponseByDateTime
CurrentDate
RefBusinessSolutionOrder RefBusinessSolutionOrder
RefBusinessSolutionOrderItem RefBusinessSolutionOrderItem
RefInHouseRepairIsExisting RefInHouseRepairIsExisting
_TransactionCurrency _ServiceDocument _TransactionCurrency

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 P_SRVCTRANSACTIONISSUETIMESTMP.
-- 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.

CREATE VIEW P_SRVCTRANSACTIONISSUETIMESTMP AS
SELECT
  ServiceObjectType,
  ServiceDocument,
  ServiceDocumentItem,
  cast('E005' as crms4_service_issue) AS CustMgmtIssue,
  cast(' ' as crms4_srvc_conf_issue) AS SrvcConfIssue,
  I_ServiceDocumentItemEnhcd._ServiceDocument.ServiceDocumentType AS ServiceDocumentType,
  I_ServiceDocumentItemEnhcd._ServiceDocument.SoldToPartyCountry AS Country,
  I_ServiceDocumentItemEnhcd._ServiceDocument.Region AS Region,
  I_ServiceDocumentItemEnhcd._ServiceDocument.ServiceRisk AS ServiceRisk,
  I_ServiceDocumentItemEnhcd._ServiceDocument.ServiceDocumentProblemCategory AS ServiceDocumentProblemCategory,
  I_ServiceDocumentItemEnhcd._ServiceDocument.TransactionCurrency AS TransactionCurrency,
  ServiceDocItemGrossAmount AS SrvcOrdGrossAmount,
  Industry,
  ServiceOrganization,
  SalesOrganization,
  SalesOffice,
  SalesGroup,
  DistributionChannel,
  Division,
  SoldToPartyCountry,
  SoldToPartyRegion,
  SoldToParty,
  ResponsibleEmployee,
  ContactPerson,
  ServiceTeam,
  ServiceEmployee,
  ServiceDocItemRejectionReason,
  ServiceDocumentItemStatus,
  ServiceDocumentItemHasError,
  BillingBlockReason,
  ServiceDocItemBillingStatus,
  SrvcDocItmIsReleasedForBilling,
  SrvcDocItemTransferStatus,
  RequestedServiceStartDateTime,
  RequestedServiceEndDateTime,
  PlannedServiceStartDateTime,
  PlannedServiceEndDateTime,
  SrvcDocItemSLADueByDateTime,
  ResponseProfile,
  ServiceProfile,
  ServiceFirstResponseByDateTime,
  tstmp_current_utctimestamp() AS CurrentDate,
  RefBusinessSolutionOrder,
  RefBusinessSolutionOrderItem,
  RefInHouseRepairIsExisting,
  _ServiceDocument._TransactionCurrency AS _TransactionCurrency
FROM I_ServiceDocumentItemEnhcd
;

Learn More