P_ServiceContractIssueKey

DDL: P_SERVICECONTRACTISSUEKEY Type: view COMPOSITE
195 Fields 5 Data Sources

P_ServiceContractIssueKey is a Composite CDS View in SAP S/4HANA. It reads from 5 data sources (I_BillingRequestItem, I_ServiceDocumentEnhcd, I_ServiceDocumentItemEnhcd, I_ServiceDocumentItemEnhcd, I_ServiceDocumentItemEnhcd) and exposes 195 fields with key fields ServiceObjectType, ServiceContract, ServiceContractItem, CustMgmtIssue, BillingRequestItem.

Data Sources (5)

SourceAliasJoin Type
I_BillingRequestItem BillgReqItm from
I_ServiceDocumentEnhcd SrvcContrHeader union_all
I_ServiceDocumentItemEnhcd SrvcContrItm left_outer
I_ServiceDocumentItemEnhcd SrvcContrItm union_all
I_ServiceDocumentItemEnhcd SrvcContrItm union_all

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName PSRVCONTRISSKEYS view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.private true view
VDM.viewType #COMPOSITE view

Fields (195)

KeyFieldSource TableSource FieldDescription
KEY ServiceObjectType I_BillingRequestItem ServiceObjectType Object Type
KEY ServiceContract I_BillingRequestItem ServiceDocument Transaction ID
KEY ServiceContractItem I_BillingRequestItem ServiceDocumentItem Service Document
KEY CustMgmtIssue
KEY BillingRequestItem I_BillingRequestItem BillingRequestItem Rec.No
TransactionCurrency I_BillingRequestItem TransactionCurrency Transaction Currency
ServiceContractType Transaction Type
ServiceContrItemStartDateTime
ServiceContrItemEndDateTime
ServiceContractItemNetAmount
ServiceContractItemGrossAmount
SrvcContrItemRnwlDuration
SrvcContrItemRnwlDurationUnit
SrvcContrItemExtensionDuration
SrvcContrItemExtnDurationUnit
ResponseProfile Response Prof.
ServiceProfile Service Profile
ServiceContractItemCategory
ServiceContractUUID
ServiceOrganization
SalesOrganization Sales Organization
SalesOffice Sales Office
SalesGroup Sales Group
DistributionChannel RefDistCh-Cust/Mat.
Division Internal Division ID
SalesOrganizationOrgUnitID
SalesOfficeOrgUnitID
SalesGroupOrgUnitID
SoldToPartyCountry
SoldToPartyRegion
SoldToParty Sold-to Party
ResponsibleEmployee Employee Resp.
ContactPerson Contact Person Key
ServiceContractItmCanclnReason
ServiceContractItemStatus
ServiceContractItemHasError
ServiceContractItemIsReleased
ServiceContractItemIsCanceled
BillingBlockReason I_BillingRequestItem BillingBlockReason Blocking Reason
ServiceDocItemBillingStatus
SrvcDocItmIsReleasedForBilling
BillgReqItemBillingStatus I_BillingRequestItem BillgReqItemBillingStatus Settlmnt Status
RefBusinessSolutionOrder
RefBusinessSolutionOrderItem
_ServiceOrganizationOrgUnit
_ServiceOrganizationOrgUnit_2
_SalesOrganizationOrgUnit_2
_SalesOfficeOrgUnit_2
ServiceObjectType Object Type
KEY ServiceContract I_ServiceDocumentItemEnhcd ServiceDocument Transaction ID
KEY ServiceContractItem I_ServiceDocumentItemEnhcd ServiceDocumentItem Service Document
KEY CustMgmtIssue
KEY BillingRequestItem Rec.No
TransactionCurrency I_ServiceDocumentItemEnhcd TransactionCurrency Transaction Currency
ServiceContractType Transaction Type
ServiceContrItemStartDateTime I_ServiceDocumentItemEnhcd ServiceContrItemStartDateTime
ServiceContrItemEndDateTime I_ServiceDocumentItemEnhcd ServiceContrItemEndDateTime
ServiceContractItemNetAmount I_ServiceDocumentItemEnhcd ServiceDocumentItemNetAmount
ServiceContractItemGrossAmount I_ServiceDocumentItemEnhcd ServiceDocItemGrossAmount
SrvcContrItemRnwlDuration I_ServiceDocumentItemEnhcd SrvcContrItemRnwlDuration
SrvcContrItemRnwlDurationUnit I_ServiceDocumentItemEnhcd SrvcContrItemRnwlDurationUnit
SrvcContrItemExtensionDuration I_ServiceDocumentItemEnhcd SrvcContrItemExtensionDuration
SrvcContrItemExtnDurationUnit I_ServiceDocumentItemEnhcd SrvcContrItemExtnDurationUnit
ResponseProfile I_ServiceDocumentItemEnhcd ResponseProfile Response Prof.
ServiceProfile I_ServiceDocumentItemEnhcd ServiceProfile Service Profile
ServiceContractItemCategory I_ServiceDocumentItemEnhcd ServiceDocItemCategory
ServiceContractUUID
ServiceOrganization I_ServiceDocumentItemEnhcd ServiceOrganization
SalesOrganization I_ServiceDocumentItemEnhcd SalesOrganization Sales Organization
SalesOffice I_ServiceDocumentItemEnhcd SalesOffice Sales Office
SalesGroup I_ServiceDocumentItemEnhcd SalesGroup Sales Group
DistributionChannel I_ServiceDocumentItemEnhcd DistributionChannel RefDistCh-Cust/Mat.
Division I_ServiceDocumentItemEnhcd Division Internal Division ID
SalesOrganizationOrgUnitID I_ServiceDocumentItemEnhcd SalesOrganizationOrgUnitID
SalesOfficeOrgUnitID I_ServiceDocumentItemEnhcd SalesOfficeOrgUnitID
SalesGroupOrgUnitID I_ServiceDocumentItemEnhcd SalesGroupOrgUnitID
SoldToPartyCountry I_ServiceDocumentItemEnhcd SoldToPartyCountry
SoldToPartyRegion I_ServiceDocumentItemEnhcd SoldToPartyRegion
SoldToParty I_ServiceDocumentItemEnhcd SoldToParty Sold-to Party
ResponsibleEmployee I_ServiceDocumentItemEnhcd ResponsibleEmployee Employee Resp.
ContactPerson I_ServiceDocumentItemEnhcd ContactPerson Contact Person Key
ServiceContractItmCanclnReason I_ServiceDocumentItemEnhcd ServiceDocItemRejectionReason
ServiceContractItemStatus I_ServiceDocumentItemEnhcd ServiceDocumentItemStatus
ServiceContractItemHasError I_ServiceDocumentItemEnhcd ServiceDocumentItemHasError
ServiceContractItemIsReleased I_ServiceDocumentItemEnhcd ServiceDocumentItemIsReleased
ServiceContractItemIsCanceled I_ServiceDocumentItemEnhcd ServiceDocumentItemIsRejected
BillingBlockReason Blocking Reason
ServiceDocItemBillingStatus I_ServiceDocumentItemEnhcd ServiceDocItemBillingStatus
SrvcDocItmIsReleasedForBilling I_ServiceDocumentItemEnhcd SrvcDocItmIsReleasedForBilling
BillgReqItemBillingStatus Settlmnt Status
BillgReqItemBillingDate
RefBusinessSolutionOrder I_ServiceDocumentItemEnhcd RefBusinessSolutionOrder
RefBusinessSolutionOrderItem I_ServiceDocumentItemEnhcd RefBusinessSolutionOrderItem
_ServiceOrganizationOrgUnit I_ServiceDocumentItemEnhcd _ServiceOrganizationOrgUnit
_ServiceOrganizationOrgUnit_2 I_ServiceDocumentItemEnhcd _ServiceOrganizationOrgUnit_2
_SalesOrganizationOrgUnit_2 I_ServiceDocumentItemEnhcd _SalesOrganizationOrgUnit_2
_SalesOfficeOrgUnit_2 I_ServiceDocumentItemEnhcd _SalesOfficeOrgUnit_2
ServiceObjectType Object Type
KEY ServiceContract I_ServiceDocumentEnhcd ServiceDocument Transaction ID
KEY ServiceContractItem Service Document
KEY CustMgmtIssue
KEY BillingRequestItem Rec.No
TransactionCurrency I_ServiceDocumentItemEnhcd TransactionCurrency Transaction Currency
ServiceContractType I_ServiceDocumentEnhcd ServiceDocumentType Transaction Type
ServiceContrItemStartDateTime I_ServiceDocumentEnhcd ServiceContractStartDateTime
ServiceContrItemEndDateTime I_ServiceDocumentEnhcd ServiceContractEndDateTime
ServiceContractItemNetAmount I_ServiceDocumentEnhcd ServiceDocNetAmount
ServiceContractItemGrossAmount I_ServiceDocumentEnhcd ServiceDocGrossAmount
SrvcContrItemRnwlDuration I_ServiceDocumentItemEnhcd SrvcContrItemRnwlDuration
SrvcContrItemRnwlDurationUnit I_ServiceDocumentItemEnhcd SrvcContrItemRnwlDurationUnit
SrvcContrItemExtensionDuration I_ServiceDocumentItemEnhcd SrvcContrItemExtensionDuration
SrvcContrItemExtnDurationUnit I_ServiceDocumentItemEnhcd SrvcContrItemExtnDurationUnit
ResponseProfile I_ServiceDocumentItemEnhcd ResponseProfile Response Prof.
ServiceProfile I_ServiceDocumentItemEnhcd ServiceProfile Service Profile
ServiceContractItemCategory I_ServiceDocumentItemEnhcd ServiceDocItemCategory
ServiceContractUUID
ServiceOrganization I_ServiceDocumentEnhcd ServiceOrganization
SalesOrganization I_ServiceDocumentEnhcd SalesOrganization Sales Organization
SalesOffice I_ServiceDocumentEnhcd SalesOffice Sales Office
SalesGroup I_ServiceDocumentEnhcd SalesGroup Sales Group
DistributionChannel I_ServiceDocumentEnhcd DistributionChannel RefDistCh-Cust/Mat.
Division I_ServiceDocumentEnhcd Division Internal Division ID
SalesOrganizationOrgUnitID I_ServiceDocumentEnhcd SalesOrganizationOrgUnitID
SalesOfficeOrgUnitID I_ServiceDocumentEnhcd SalesOfficeOrgUnitID
SalesGroupOrgUnitID I_ServiceDocumentEnhcd SalesGroupOrgUnitID
SoldToPartyCountry I_ServiceDocumentEnhcd SoldToPartyCountry
SoldToPartyRegion I_ServiceDocumentEnhcd SoldToPartyRegion
SoldToParty I_ServiceDocumentEnhcd SoldToParty Sold-to Party
ResponsibleEmployee I_ServiceDocumentEnhcd ResponsibleEmployee Employee Resp.
ContactPerson I_ServiceDocumentEnhcd ContactPerson Contact Person Key
ServiceContractItmCanclnReason I_ServiceDocumentEnhcd ServiceDocumentRejectionReason
ServiceContractItemStatus I_ServiceDocumentEnhcd ServiceDocumentStatus
ServiceContractItemHasError I_ServiceDocumentEnhcd ServiceDocumentHasError
ServiceContractItemIsReleased I_ServiceDocumentEnhcd ServiceDocumentIsReleased
ServiceContractItemIsCanceled I_ServiceDocumentEnhcd ServiceDocumentIsRejected
BillingBlockReason Blocking Reason
ServiceDocItemBillingStatus I_ServiceDocumentItemEnhcd ServiceDocItemBillingStatus
SrvcDocItmIsReleasedForBilling I_ServiceDocumentItemEnhcd SrvcDocItmIsReleasedForBilling
BillgReqItemBillingStatus Settlmnt Status
BillgReqItemBillingDate
RefBusinessSolutionOrder I_ServiceDocumentEnhcd RefBusinessSolutionOrder
RefBusinessSolutionOrderItem I_ServiceDocumentItemEnhcd RefBusinessSolutionOrderItem
_ServiceOrganizationOrgUnit I_ServiceDocumentEnhcd _ServiceOrganizationOrgUnit
_ServiceOrganizationOrgUnit_2 I_ServiceDocumentEnhcd _ServiceOrganizationOrgUnit_2
_SalesOrganizationOrgUnit_2 I_ServiceDocumentEnhcd _SalesOrganizationOrgUnit_2
_SalesOfficeOrgUnit_2 I_ServiceDocumentEnhcd _SalesOfficeOrgUnit_2
KEY ServiceContract ServiceDocument Transaction ID
KEY ServiceContractItem ServiceDocumentItem Service Document
KEY CustMgmtIssue
KEY BillingRequestItem Rec.No
TransactionCurrency I_ServiceDocumentItemEnhcd TransactionCurrency Transaction Currency
ServiceContractType Transaction Type
ServiceContrItemStartDateTime I_ServiceDocumentItemEnhcd ServiceContrItemStartDateTime
ServiceContrItemEndDateTime I_ServiceDocumentItemEnhcd ServiceContrItemEndDateTime
ServiceContractItemNetAmount I_ServiceDocumentItemEnhcd ServiceDocumentItemNetAmount
ServiceContractItemGrossAmount I_ServiceDocumentItemEnhcd ServiceDocItemGrossAmount
SrvcContrItemRnwlDuration I_ServiceDocumentItemEnhcd SrvcContrItemRnwlDuration
SrvcContrItemRnwlDurationUnit I_ServiceDocumentItemEnhcd SrvcContrItemRnwlDurationUnit
SrvcContrItemExtensionDuration I_ServiceDocumentItemEnhcd SrvcContrItemExtensionDuration
SrvcContrItemExtnDurationUnit I_ServiceDocumentItemEnhcd SrvcContrItemExtnDurationUnit
ResponseProfile I_ServiceDocumentItemEnhcd ResponseProfile Response Prof.
ServiceProfile I_ServiceDocumentItemEnhcd ServiceProfile Service Profile
ServiceContractItemCategory I_ServiceDocumentItemEnhcd ServiceDocItemCategory
ServiceContractUUID
ServiceOrganization I_ServiceDocumentItemEnhcd ServiceOrganization
SalesOrganization I_ServiceDocumentItemEnhcd SalesOrganization Sales Organization
SalesOffice I_ServiceDocumentItemEnhcd SalesOffice Sales Office
SalesGroup I_ServiceDocumentItemEnhcd SalesGroup Sales Group
DistributionChannel I_ServiceDocumentItemEnhcd DistributionChannel RefDistCh-Cust/Mat.
Division I_ServiceDocumentItemEnhcd Division Internal Division ID
SalesOrganizationOrgUnitID I_ServiceDocumentItemEnhcd SalesOrganizationOrgUnitID
SalesOfficeOrgUnitID I_ServiceDocumentItemEnhcd SalesOfficeOrgUnitID
SalesGroupOrgUnitID I_ServiceDocumentItemEnhcd SalesGroupOrgUnitID
SoldToPartyCountry I_ServiceDocumentItemEnhcd SoldToPartyCountry
SoldToPartyRegion I_ServiceDocumentItemEnhcd SoldToPartyRegion
SoldToParty I_ServiceDocumentItemEnhcd SoldToParty Sold-to Party
ResponsibleEmployee I_ServiceDocumentItemEnhcd ResponsibleEmployee Employee Resp.
ContactPerson I_ServiceDocumentItemEnhcd ContactPerson Contact Person Key
ServiceContractItmCanclnReason I_ServiceDocumentItemEnhcd ServiceDocItemRejectionReason
ServiceContractItemStatus I_ServiceDocumentItemEnhcd ServiceDocumentItemStatus
ServiceContractItemHasError I_ServiceDocumentItemEnhcd ServiceDocumentItemHasError
ServiceContractItemIsReleased I_ServiceDocumentItemEnhcd ServiceDocumentItemIsReleased
ServiceContractItemIsCanceled I_ServiceDocumentItemEnhcd ServiceDocumentItemIsRejected
BillingBlockReason Blocking Reason
ServiceDocItemBillingStatus I_ServiceDocumentItemEnhcd ServiceDocItemBillingStatus
SrvcDocItmIsReleasedForBilling I_ServiceDocumentItemEnhcd SrvcDocItmIsReleasedForBilling
BillgReqItemBillingStatus Settlmnt Status
BillgReqItemBillingDate
RefBusinessSolutionOrder I_ServiceDocumentItemEnhcd RefBusinessSolutionOrder
RefBusinessSolutionOrderItem I_ServiceDocumentItemEnhcd RefBusinessSolutionOrderItem
_ServiceOrganizationOrgUnit I_ServiceDocumentItemEnhcd _ServiceOrganizationOrgUnit
_ServiceOrganizationOrgUnit_2 I_ServiceDocumentItemEnhcd _ServiceOrganizationOrgUnit_2
_SalesOrganizationOrgUnit_2 I_ServiceDocumentItemEnhcd _SalesOrganizationOrgUnit_2
_SalesOfficeOrgUnit_2 I_ServiceDocumentItemEnhcd _SalesOfficeOrgUnit_2
_SalesGroupOrgUnit_2 I_ServiceDocumentItemEnhcd _SalesGroupOrgUnit_2

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_ServiceContractIssueKey.
-- 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_ServiceContractIssueKey AS
SELECT
  BillgReqItm.ServiceObjectType AS ServiceObjectType,
  BillgReqItm.ServiceDocument AS ServiceContract,
  BillgReqItm.ServiceDocumentItem AS ServiceContractItem,
  cast('B001' as crms4_service_issue preserving type ) AS CustMgmtIssue,
  BillgReqItm.BillingRequestItem AS BillingRequestItem,
  BillgReqItm.TransactionCurrency AS TransactionCurrency,
  BillgReqItm._ServiceDocItem._ServiceDocument.ServiceDocumentType AS ServiceContractType,
  BillgReqItm._ServiceDocItem.ServiceContrItemStartDateTime AS ServiceContrItemStartDateTime,
  BillgReqItm._ServiceDocItem.ServiceContrItemEndDateTime AS ServiceContrItemEndDateTime,
  BillgReqItm._ServiceDocItem.ServiceDocumentItemNetAmount AS ServiceContractItemNetAmount,
  BillgReqItm._ServiceDocItem.ServiceDocItemGrossAmount AS ServiceContractItemGrossAmount,
  BillgReqItm._ServiceDocItem.SrvcContrItemRnwlDuration AS SrvcContrItemRnwlDuration,
  BillgReqItm._ServiceDocItem.SrvcContrItemRnwlDurationUnit AS SrvcContrItemRnwlDurationUnit,
  BillgReqItm._ServiceDocItem.SrvcContrItemExtensionDuration AS SrvcContrItemExtensionDuration,
  BillgReqItm._ServiceDocItem.SrvcContrItemExtnDurationUnit AS SrvcContrItemExtnDurationUnit,
  BillgReqItm._ServiceDocItem.ResponseProfile AS ResponseProfile,
  BillgReqItm._ServiceDocItem.ServiceProfile AS ServiceProfile,
  BillgReqItm._ServiceDocItem.ServiceDocItemCategory AS ServiceContractItemCategory,
  bintohex( BillgReqItm._ServiceDocItem.ServiceDocumentUUID ) AS ServiceContractUUID,
  BillgReqItm._ServiceDocItem.ServiceOrganization AS ServiceOrganization,
  BillgReqItm._ServiceDocItem.SalesOrganization AS SalesOrganization,
  BillgReqItm._ServiceDocItem.SalesOffice AS SalesOffice,
  BillgReqItm._ServiceDocItem.SalesGroup AS SalesGroup,
  BillgReqItm._ServiceDocItem.DistributionChannel AS DistributionChannel,
  BillgReqItm._ServiceDocItem.Division AS Division,
  BillgReqItm._ServiceDocItem.SalesOrganizationOrgUnitID AS SalesOrganizationOrgUnitID,
  BillgReqItm._ServiceDocItem.SalesOfficeOrgUnitID AS SalesOfficeOrgUnitID,
  BillgReqItm._ServiceDocItem.SalesGroupOrgUnitID AS SalesGroupOrgUnitID,
  BillgReqItm._ServiceDocItem.SoldToPartyCountry AS SoldToPartyCountry,
  BillgReqItm._ServiceDocItem.SoldToPartyRegion AS SoldToPartyRegion,
  BillgReqItm._ServiceDocItem.SoldToParty AS SoldToParty,
  BillgReqItm._ServiceDocItem.ResponsibleEmployee AS ResponsibleEmployee,
  BillgReqItm._ServiceDocItem.ContactPerson AS ContactPerson,
  BillgReqItm._ServiceDocItem.ServiceDocItemRejectionReason AS ServiceContractItmCanclnReason,
  BillgReqItm._ServiceDocItem.ServiceDocumentItemStatus AS ServiceContractItemStatus,
  BillgReqItm._ServiceDocItem.ServiceDocumentItemHasError AS ServiceContractItemHasError,
  BillgReqItm._ServiceDocItem.ServiceDocumentItemIsReleased AS ServiceContractItemIsReleased,
  BillgReqItm._ServiceDocItem.ServiceDocumentItemIsRejected AS ServiceContractItemIsCanceled,
  BillgReqItm.BillingBlockReason AS BillingBlockReason,
  BillgReqItm._ServiceDocItem.ServiceDocItemBillingStatus AS ServiceDocItemBillingStatus,
  BillgReqItm._ServiceDocItem.SrvcDocItmIsReleasedForBilling AS SrvcDocItmIsReleasedForBilling,
  BillgReqItm.BillgReqItemBillingStatus AS BillgReqItemBillingStatus,
  BillgReqItm._ServiceDocItem.RefBusinessSolutionOrder AS RefBusinessSolutionOrder,
  BillgReqItm._ServiceDocItem.RefBusinessSolutionOrderItem AS RefBusinessSolutionOrderItem,
  BillgReqItm._ServiceDocItem._ServiceOrganizationOrgUnit AS _ServiceOrganizationOrgUnit,
  BillgReqItm._ServiceDocItem._ServiceOrganizationOrgUnit_2 AS _ServiceOrganizationOrgUnit_2,
  BillgReqItm._ServiceDocItem._SalesOrganizationOrgUnit_2 AS _SalesOrganizationOrgUnit_2,
  BillgReqItm._ServiceDocItem._SalesOfficeOrgUnit_2 AS _SalesOfficeOrgUnit_2,
  cast( '00000000' as abap.dats ) AS BillgReqItemBillingDate,
  SrvcContrItm._SalesGroupOrgUnit_2 AS _SalesGroupOrgUnit_2
FROM I_BillingRequestItem AS BillgReqItm
LEFT OUTER JOIN I_ServiceDocumentItemEnhcd AS SrvcContrItm ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): I_ServiceDocumentItemEnhcd, I_ServiceDocumentEnhcd
;

Learn More