P_UpcgSrvcContrItemDateConv

DDL: P_UPCGSRVCCONTRITEMDATECONV Type: view COMPOSITE
49 Fields 1 Data Sources

Date Conversion for contract dashboard

P_UpcgSrvcContrItemDateConv is a Composite CDS View that provides data about "Date Conversion for contract dashboard" in SAP S/4HANA. It reads from 1 data source (I_ServiceDocumentItemEnhcd) and exposes 49 fields with key fields ServiceObjectType, ServiceDocument, ServiceDocumentItem.

Data Sources (1)

SourceAliasJoin Type
I_ServiceDocumentItemEnhcd I_ServiceDocumentItemEnhcd from

Annotations (11)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName PUPCGSCIDATCONV view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
VDM.private true view
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XXL view
EndUserText.label Date Conversion for contract dashboard view

Fields (49)

KeyFieldSource TableSource FieldDescription
KEY ServiceObjectType ServiceObjectType Object Type
KEY ServiceDocument ServiceDocument Transaction ID
KEY ServiceDocumentItem ServiceDocumentItem Service Document
ServiceDocumentType ServiceDocumentType Transaction Type
ServiceDocumentDescription ServiceDocumentDescription
Product Product Product Sold
clientNULLasServiceContractItemStartDate
clientNULLasServiceContractItemEndDate
ServiceDocItemCreationDate ServiceDocItemCreationDate
PostingDate PostingDate Posting Date for GR
ServiceDocumentItemStatus ServiceDocumentItemStatus
ServiceDocumentItemCanclnParty ServiceDocumentItemCanclnParty
ServiceDocumentItmCanclnReason ServiceDocumentItmCanclnReason
ProfitCenter ProfitCenter Profit Center
ControllingArea ControllingArea Controlling Area
PurchaseOrderByCustomer PurchaseOrderByCustomer Purchase Order Number
SoldToParty SoldToParty Sold-to Party
ResponsibleEmployee ResponsibleEmployee Employee Resp.
RefBusinessSolutionOrder RefBusinessSolutionOrder
SoldToPartyCountry SoldToPartyCountry
SoldToPartyRegion SoldToPartyRegion
SalesOrganization SalesOrganization Sales Organization
DistributionChannel DistributionChannel RefDistCh-Cust/Mat.
Division Division Internal Division ID
SalesOffice SalesOffice Sales Office
SalesGroup SalesGroup Sales Group
ServiceDocumentItemNetAmount ServiceDocumentItemNetAmount
TransactionCurrency TransactionCurrency Transaction Currency
ServiceDocumentItemIsReleased ServiceDocumentItemIsReleased
ServiceDocumentTemplateType ServiceDocumentTemplateType
ServiceDocumentItemIsQuotation ServiceDocumentItemIsQuotation
_ServiceDocument _ServiceDocument
_ServiceObjType _ServiceObjType
_ServiceDocumentType _ServiceDocumentType
_Product _Product
_ServiceDocItemStatus _ServiceDocItemStatus
_SrvcDocItmLifecycleStatus _SrvcDocItmLifecycleStatus
_ProfitCenter _ProfitCenter
_ControllingArea _ControllingArea
_SoldToParty _SoldToParty
_RespEmployee _RespEmployee
_SoldToPartyCountry _SoldToPartyCountry
_SoldToPartyRegion _SoldToPartyRegion
_SalesOrganization _SalesOrganization
_DistributionChannel _DistributionChannel
_Division _Division
_SalesOffice _SalesOffice
_SalesGroup _SalesGroup
_TransactionCurrency _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_UpcgSrvcContrItemDateConv.
-- 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_UpcgSrvcContrItemDateConv AS
SELECT
  ServiceObjectType,
  ServiceDocument,
  ServiceDocumentItem,
  ServiceDocumentType,
  ServiceDocumentDescription,
  Product,
  tstmp_to_dats( ServiceContrItemStartDateTime, $session.user_timezone, $session.client, 'NULL' ) as ServiceContractItemStartDate AS clientNULLasServiceContractItemStartDate,
  tstmp_to_dats( ServiceContrItemEndDateTime, $session.user_timezone, $session.client, 'NULL' ) as ServiceContractItemEndDate AS clientNULLasServiceContractItemEndDate,
  ServiceDocItemCreationDate,
  PostingDate,
  ServiceDocumentItemStatus,
  ServiceDocumentItemCanclnParty,
  ServiceDocumentItmCanclnReason,
  ProfitCenter,
  ControllingArea,
  PurchaseOrderByCustomer,
  SoldToParty,
  ResponsibleEmployee,
  RefBusinessSolutionOrder,
  SoldToPartyCountry,
  SoldToPartyRegion,
  SalesOrganization,
  DistributionChannel,
  Division,
  SalesOffice,
  SalesGroup,
  ServiceDocumentItemNetAmount,
  TransactionCurrency,
  ServiceDocumentItemIsReleased,
  ServiceDocumentTemplateType,
  ServiceDocumentItemIsQuotation
FROM I_ServiceDocumentItemEnhcd
;

Learn More