P_SrvcContrItmBillgBlkSitn

DDL: P_SRVCCONTRITMBILLGBLKSITN SQL: PSRVCONTRITMBLGB Type: view COMPOSITE
40 Fields 1 Data Sources 1 Associations

P_SrvcContrItmBillgBlkSitn is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (I_ServiceDocumentItemEnhcd) and exposes 40 fields with key fields ServiceDocument, ServiceObjectType, ServiceDocumentItem. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_ServiceDocumentItemEnhcd I_ServiceDocumentItemEnhcd from

Associations (1)

CardinalityTargetAliasCondition
[0..1] P_SrvcContrBlkBillingReqItem _BillgReqItm $projection.ServiceObjectType = _BillgReqItm.ServiceObjectType and $projection.ServiceDocument = _BillgReqItm.ServiceDocument and $projection.ServiceDocumentItem = _BillgReqItm.ServiceDocumentItem

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PSRVCONTRITMBLGB 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 (40)

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
BillingBlockReason BillingBlockReason
SrvcContrItemHasBillingBlock _BillgReqItm SrvcContrItemHasBillingBlock
_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
_BillgReqItm _BillgReqItm
_BillingBlockReason _BillingBlockReason
_IsBlocked _BillgReqItm _IsBlocked

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_SrvcContrItmBillgBlkSitn.
-- 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: PSRVCONTRITMBLGB

CREATE VIEW P_SrvcContrItmBillgBlkSitn AS
SELECT
  ServiceDocument,
  ServiceObjectType,
  ServiceDocumentItem,
  ServiceDocumentType,
  ServiceDocumentDescription,
  ServiceContractItemStartDate,
  ServiceContractItemEndDate,
  ServiceDocumentItemUUID,
  ServiceDocumentItemIsReleased,
  TransactionCurrency,
  ServiceDocumentItemNetAmount,
  ResponsibleEmployee,
  SalesOrganization,
  DistributionChannel,
  Division,
  SalesOffice,
  SalesGroup,
  SalesOrganizationOrgUnitID,
  SalesOfficeOrgUnitID,
  SalesGroupOrgUnitID,
  ServiceOrganization,
  BillingBlockReason,
  _BillgReqItm.SrvcContrItemHasBillingBlock AS SrvcContrItemHasBillingBlock,
  _BillgReqItm._IsBlocked AS _IsBlocked
FROM I_ServiceDocumentItemEnhcd
LEFT OUTER JOIN P_SrvcContrBlkBillingReqItem AS _BillgReqItm ON ServiceObjectType = _BillgReqItm.ServiceObjectType AND ServiceDocument = _BillgReqItm.ServiceDocument AND ServiceDocumentItem = _BillgReqItm.ServiceDocumentItem  -- association [0..1]
;

Learn More