C_SrvcContrItemBillgValSitn

DDL: C_SRVCCONTRITEMBILLGVALSITN SQL: CSRVCITMABNBILLG Type: view CONSUMPTION
38 Fields 2 Data Sources

Contract with Zero Billing Value

C_SrvcContrItemBillgValSitn is a Consumption CDS View that provides data about "Contract with Zero Billing Value" in SAP S/4HANA. It reads from 2 data sources (P_SrvcContrItemZeroBillgVal, I_ServiceDocumentItemEnhcd) and exposes 38 fields with key fields ServiceObjectType, ServiceContract, ServiceContractItem.

Data Sources (2)

SourceAliasJoin Type
P_SrvcContrItemZeroBillgVal BillgReqItem inner
I_ServiceDocumentItemEnhcd SrvcContrItem from

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName CSRVCITMABNBILLG view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
EndUserText.label Contract with Zero Billing Value view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #CONSUMPTION view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
AccessControl.authorizationCheck #CHECK view
ObjectModel.representativeKey ServiceContract view
ObjectModel.uniqueIdField ServiceContractItemUUID view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XXL view

Fields (38)

KeyFieldSource TableSource FieldDescription
KEY ServiceObjectType I_ServiceDocumentItemEnhcd ServiceObjectType Object Type
KEY ServiceContract I_ServiceDocumentItemEnhcd ServiceDocument Service Contract ID
KEY ServiceContractItem I_ServiceDocumentItemEnhcd ServiceDocumentItem Service Contract Item
ServiceContractItemUUID ServiceDocumentItemUUID
ServiceDocumentDescription ServiceDocumentDescription
ServiceDocumentItemDescription ServiceDocumentItemDescription
ServiceDocumentType ServiceDocumentType Transaction Type
ServiceDocumentItemStatus ServiceDocumentItemStatus
RespEmployeeBusinessPartnerId ResponsibleEmployee Employee Resp.
ResponsibleEmployeeUserID RespEmployeeUser UserID User Name
SalesOrganizationOrgUnitID SalesOrganizationOrgUnitID
SalesOfficeOrgUnitID SalesOfficeOrgUnitID
SalesGroupOrgUnitID SalesGroupOrgUnitID
ServiceOrganization ServiceOrganization
SalesOrganization SalesOrganization Sales Organization
DistributionChannel DistributionChannel RefDistCh-Cust/Mat.
Division Division Internal Division ID
SalesOffice SalesOffice Sales Office
SalesGroup SalesGroup Sales Group
_ServiceObjType _ServiceObjType
_ServiceDocument _ServiceDocument
_ServiceDocumentType _ServiceDocumentType
_ServiceDocItemStatus _ServiceDocItemStatus
_SrvcDocItmLifecycleStatus _SrvcDocItmLifecycleStatus
_RespEmployee _RespEmployee
_SalesOrganizationOrgUnit _SalesOrganizationOrgUnit
_SalesOfficeOrgUnit _SalesOfficeOrgUnit
_SalesGroupOrgUnit _SalesGroupOrgUnit
_ServiceOrganizationOrgUnit _ServiceOrganizationOrgUnit
_SalesOrganizationOrgUnit_2 _SalesOrganizationOrgUnit_2
_SalesOfficeOrgUnit_2 _SalesOfficeOrgUnit_2
_SalesGroupOrgUnit_2 _SalesGroupOrgUnit_2
_ServiceOrganizationOrgUnit_2 _ServiceOrganizationOrgUnit_2
_SalesOrganization _SalesOrganization
_DistributionChannel _DistributionChannel
_Division _Division
_SalesOffice _SalesOffice
_SalesGroup _SalesGroup

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 C_SrvcContrItemBillgValSitn.
-- 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: CSRVCITMABNBILLG

CREATE VIEW C_SrvcContrItemBillgValSitn AS
SELECT
  SrvcContrItem.ServiceObjectType AS ServiceObjectType,
  SrvcContrItem.ServiceDocument AS ServiceContract,
  SrvcContrItem.ServiceDocumentItem AS ServiceContractItem,
  ServiceDocumentItemUUID AS ServiceContractItemUUID,
  ServiceDocumentDescription,
  ServiceDocumentItemDescription,
  ServiceDocumentType,
  ServiceDocumentItemStatus,
  ResponsibleEmployee AS RespEmployeeBusinessPartnerId,
  RespEmployeeUser.UserID AS ResponsibleEmployeeUserID,
  SalesOrganizationOrgUnitID,
  SalesOfficeOrgUnitID,
  SalesGroupOrgUnitID,
  ServiceOrganization,
  SalesOrganization,
  DistributionChannel,
  Division,
  SalesOffice,
  SalesGroup
FROM I_ServiceDocumentItemEnhcd AS SrvcContrItem
INNER JOIN P_SrvcContrItemZeroBillgVal AS BillgReqItem ON /* join condition not captured in parsed metadata */
;

Learn More