P_SrvcContrItmRelDueSituation

DDL: P_SRVCCONTRITMRELDUESITUATION SQL: PSRVCONTRITMRELD Type: view COMPOSITE
35 Fields 1 Data Sources

P_SrvcContrItmRelDueSituation is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (I_ServiceDocumentItemEnhcd) and exposes 35 fields with key fields ServiceDocument, ServiceObjectType, ServiceDocumentItem.

Data Sources (1)

SourceAliasJoin Type
I_ServiceDocumentItemEnhcd I_ServiceDocumentItemEnhcd from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PSRVCONTRITMRELD view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.private true view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XXL view

Fields (35)

KeyFieldSource TableSource FieldDescription
KEY ServiceDocument ServiceDocument Transaction ID
KEY ServiceObjectType ServiceObjectType Object Type
KEY ServiceDocumentItem ServiceDocumentItem Service Document
ServiceDocumentType ServiceDocumentType Transaction Type
ServiceDocumentDescription ServiceDocumentDescription
ServiceContractItemStartDate ServiceContractItemStartDate
ServiceContractItemEndDate ServiceContractItemEndDate
ServiceDocumentItemUUID ServiceDocumentItemUUID
ServiceDocumentItemIsReleased ServiceDocumentItemIsReleased
TransactionCurrency TransactionCurrency Transaction Currency
ServiceDocumentItemNetAmount ServiceDocumentItemNetAmount
ResponsibleEmployee ResponsibleEmployee Employee Resp.
SalesOrganization SalesOrganization Sales Organization
DistributionChannel DistributionChannel RefDistCh-Cust/Mat.
Division Division Internal Division ID
SalesOffice SalesOffice Sales Office
SalesGroup SalesGroup Sales Group
SalesOrganizationOrgUnitID SalesOrganizationOrgUnitID
SalesOfficeOrgUnitID SalesOfficeOrgUnitID
SalesGroupOrgUnitID SalesGroupOrgUnitID
ServiceOrganization ServiceOrganization
_ServiceDocument _ServiceDocument
_ServiceObjType _ServiceObjType
_ServiceDocumentType _ServiceDocumentType
_RespEmployee _RespEmployee
_SalesOrganization _SalesOrganization
_DistributionChannel _DistributionChannel
_Division _Division
_SalesOffice _SalesOffice
_SalesGroup _SalesGroup
_SalesOrganizationOrgUnit_2 _SalesOrganizationOrgUnit_2
_SalesOfficeOrgUnit_2 _SalesOfficeOrgUnit_2
_SalesGroupOrgUnit_2 _SalesGroupOrgUnit_2
_ServiceOrganizationOrgUnit_2 _ServiceOrganizationOrgUnit_2
_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_SrvcContrItmRelDueSituation.
-- 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: PSRVCONTRITMRELD

CREATE VIEW P_SrvcContrItmRelDueSituation AS
SELECT
  ServiceDocument,
  ServiceObjectType,
  ServiceDocumentItem,
  ServiceDocumentType,
  ServiceDocumentDescription,
  ServiceContractItemStartDate,
  ServiceContractItemEndDate,
  ServiceDocumentItemUUID,
  ServiceDocumentItemIsReleased,
  TransactionCurrency,
  ServiceDocumentItemNetAmount,
  ResponsibleEmployee,
  SalesOrganization,
  DistributionChannel,
  Division,
  SalesOffice,
  SalesGroup,
  SalesOrganizationOrgUnitID,
  SalesOfficeOrgUnitID,
  SalesGroupOrgUnitID,
  ServiceOrganization
FROM I_ServiceDocumentItemEnhcd
;

Learn More