P_SrvcContrSettlmtBillgReqDets

DDL: P_SRVCCONTRSETTLMTBILLGREQDETS SQL: PSCITMBDRDT Type: view COMPOSITE
61 Fields 1 Data Sources

P_SrvcContrSettlmtBillgReqDets is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (P_SrvcContrItmSettlmtDetails) and exposes 61 fields with key fields ServiceContract, ServiceContractItem, ServiceObjectType, BillingRequestItem.

Data Sources (1)

SourceAliasJoin Type
P_SrvcContrItmSettlmtDetails P_SrvcContrItmSettlmtDetails from

Parameters (2)

NameTypeDefault
P_ContractStartDate dats
P_ContractEndDate dats

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PSCITMBDRDT view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED 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 (61)

KeyFieldSource TableSource FieldDescription
KEY ServiceContract ServiceContract Transaction ID
KEY ServiceContractItem ServiceContractItem Item Number in Doc.
KEY ServiceObjectType ServiceObjectType Object Type
KEY BillingRequestItem BillingRequestItem
ServiceContractType ServiceContractType Transaction Type
ServiceContractDescription ServiceContractDescription
ServiceContractItemProduct ServiceContractItemProduct Product Sold
ServiceContrItemBillingStatus ServiceContrItemBillingStatus
SettlementStartDate SettlementStartDate
SettlementEndDate SettlementEndDate
BillgReqItemBillingDate BillgReqItemBillingDate
SrvcContrItemBillgBlockReason SrvcContrItemBillgBlockReason
BillgReqItemBillingStatus BillgReqItemBillingStatus
BillgReqItemNetAmount BillgReqItemNetAmount
BillgDocReqItemNetAmount _BDRItem NetAmount Stated Amount
BillingDocumentRequest _BDRItem BillingDocumentRequest
BillingDocumentRequestItem _BDRItem BillingDocumentRequestItem
BillgDocReqBillgSts _BDRItem BillgDocReqBillgSts
ServiceContractItemStartDate ServiceContractItemStartDate
ServiceContractItemEndDate ServiceContractItemEndDate
ServiceContractItemStatus ServiceContractItemStatus
ServiceContractItemIsActive ServiceContractItemIsActive
SrvcContrItemHasBillingBlock SrvcContrItemHasBillingBlock
ServiceContractItemQuantity ServiceContractItemQuantity
ServiceContrItemQuantityUnit ServiceContrItemQuantityUnit
PurchaseOrderByCustomer PurchaseOrderByCustomer Purchase Order Number
ProfitCenter ProfitCenter Profit Center
ControllingArea ControllingArea Controlling Area
TransactionCurrency TransactionCurrency Transaction Currency
RespEmployeeBusinessPartnerId RespEmployeeBusinessPartnerId Employee Resp.
RefBusinessSolutionOrder RefBusinessSolutionOrder
SalesOrganization SalesOrganization Sales Organization
SalesOffice SalesOffice Sales Office
SalesGroup SalesGroup Sales Group
DistributionChannel DistributionChannel RefDistCh-Cust/Mat.
Division Division Internal Division ID
SoldToParty SoldToParty Sold-to Party
ServiceDocItemCreationDate ServiceDocItemCreationDate
ServiceDocumentItemDescription ServiceDocumentItemDescription
_BDRItem _BDRItem
_Product _Product
_SettlementItem _SettlementItem
_ServiceDocument _ServiceDocument
_ServiceObjType _ServiceObjType
_ServiceDocumentType _ServiceDocumentType
_ServiceDocItemBillingStatus _ServiceDocItemBillingStatus
_BillingBlockReason _BillingBlockReason
_ServiceDocItemStatus _ServiceDocItemStatus
_SrvcDocItmLifecycleStatus _SrvcDocItmLifecycleStatus
_ServiceContractItemIsActive _ServiceContractItemIsActive
_IsBlocked _IsBlocked
_ProfitCenter _ProfitCenter
_ControllingArea _ControllingArea
_TransactionCurrency _TransactionCurrency
_RespEmployee _RespEmployee
_SalesOrganization _SalesOrganization
_SalesOffice _SalesOffice
_SalesGroup _SalesGroup
_DistributionChannel _DistributionChannel
_Division _Division
_SoldToParty _SoldToParty

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_SrvcContrSettlmtBillgReqDets.
-- 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: PSCITMBDRDT
-- Parameters: P_ContractStartDate : dats, P_ContractEndDate : dats

CREATE VIEW P_SrvcContrSettlmtBillgReqDets AS
SELECT
  ServiceContract,
  ServiceContractItem,
  ServiceObjectType,
  BillingRequestItem,
  ServiceContractType,
  ServiceContractDescription,
  ServiceContractItemProduct,
  ServiceContrItemBillingStatus,
  SettlementStartDate,
  SettlementEndDate,
  BillgReqItemBillingDate,
  SrvcContrItemBillgBlockReason,
  BillgReqItemBillingStatus,
  BillgReqItemNetAmount,
  _BDRItem.NetAmount AS BillgDocReqItemNetAmount,
  _BDRItem.BillingDocumentRequest AS BillingDocumentRequest,
  _BDRItem.BillingDocumentRequestItem AS BillingDocumentRequestItem,
  _BDRItem.BillgDocReqBillgSts AS BillgDocReqBillgSts,
  ServiceContractItemStartDate,
  ServiceContractItemEndDate,
  ServiceContractItemStatus,
  ServiceContractItemIsActive,
  SrvcContrItemHasBillingBlock,
  ServiceContractItemQuantity,
  ServiceContrItemQuantityUnit,
  PurchaseOrderByCustomer,
  ProfitCenter,
  ControllingArea,
  TransactionCurrency,
  RespEmployeeBusinessPartnerId,
  RefBusinessSolutionOrder,
  SalesOrganization,
  SalesOffice,
  SalesGroup,
  DistributionChannel,
  Division,
  SoldToParty,
  ServiceDocItemCreationDate,
  ServiceDocumentItemDescription
FROM P_SrvcContrItmSettlmtDetails
;

Learn More