I_GrntoClaimBillgReqLine

DDL: I_GRNTOCLAIMBILLGREQLINE Type: view_entity BASIC

Billing Request Line for Grantor Claim

I_GrntoClaimBillgReqLine (Basic)

Package: Explore, extend and adapt the SAP S/4HANA with built-in and side-by-side extension capabilities.

Public Sector

I_GrntoClaimBillgReqLine is a Basic CDS View that provides data about "Billing Request Line for Grantor Claim" in SAP S/4HANA. It reads from 1 data source (crms4d_billreq_i) and exposes 20 fields with key fields BusinessObjectType, GrantorClaim, GrantorClaimItem, BillingRequestItem.

SAP Help Documentation

CategoryCDS Views for Grantor Management
Purpose
This CDS view retrieves information about billing request lines for grantor claims. To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views .

Prerequisites
Authorizations Users who want to use this CDS view need to access it via another CDS view (privileged mode).

Structure
Important Fields Important fields in this view include the following: Field Name Description GrantorClaim ID of the grantor claim GrantorClaimItem Number of the item BillingRequestItem Number of the billing request item/line BillgReqItemNetAmount Amount of the item/line

Constraints
The associated database table crms4d_billreq_i is used in multiple business object types. This view doesn't ensure that the system only retrieves the grantor claims data. This is the responsibility of the consumer of this view.

View on SAP Help Portal →

SAP API Hub

StateC1
Line of BusinessPublic Sector
Application ComponentPSM-GM-GTR-GEN
CapabilitiesData Source for Defining CDS Entities, Association Target for Defining CDS Entities, Data Source in SQL Select
PackagePublic Sector for SAP S/4HANA
Description <p>This CDS view retrieves information about billing request lines for grantor claims.</p> <p>To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views.</p>

Documentation

Data Sources (1)

SourceAliasJoin Type
crms4d_billreq_i crms4d_billreq_i from

Annotations (9)

NameValueLevelField
EndUserText.label Billing Request Line for Grantor Claim view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.modelingPattern #NONE view
Metadata.ignorePropagatedAnnotations true view

Fields (20)

KeyFieldSource TableSource FieldDescription
KEY BusinessObjectType objtype_h Business Trans. Cat.
KEY GrantorClaim object_id Transaction ID
KEY GrantorClaimItem number_int Shortened Item Number in Document
KEY BillingRequestItem record_no Billing Request Item No
BillingRequestItemUUID record GUID of a CRM Order Object
BillgReqItemBillingDateTime bill_date Billing Date for Billing Index and Printout
SettlementStartDateTime settl_from Start of Settlement for Period
SettlementEndDateTime settl_to End of Settlement for Period
TransactionCurrency _GrantorClaimItem TransactionCurrency Transaction Currency
CompanyCodeCurrency Currency Key
BillgReqItemNetAmount net_value Own Net Val
BillingBlockReason billing_block Business Partner: Billing Block Reason
BillgReqItemIsCreditItem credit_indicator Credit Debit Indicator
BillgReqItemDescription description Well Code Des.
GrantorPaymentType billreq_i_usage_type Usage Type of Billing Request Lines
_GrantorClaimItem _GrantorClaimItem
_TransactionCurrency _TransactionCurrency
_CompanyCodeCurrency _CompanyCodeCurrency
_BillingBlockReason _BillingBlockReason
_GrantorPaymentType _GrantorPaymentType

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 I_GrntoClaimBillgReqLine.
-- 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 I_GrntoClaimBillgReqLine AS
SELECT
  objtype_h AS BusinessObjectType,
  object_id AS GrantorClaim,
  number_int AS GrantorClaimItem,
  record_no AS BillingRequestItem,
  record AS BillingRequestItemUUID,
  bill_date AS BillgReqItemBillingDateTime,
  settl_from AS SettlementStartDateTime,
  settl_to AS SettlementEndDateTime,
  _GrantorClaimItem.TransactionCurrency AS TransactionCurrency,
  _GrantorClaimItem._SalesOrganization._CompanyCode.Currency AS CompanyCodeCurrency,
  net_value AS BillgReqItemNetAmount,
  billing_block AS BillingBlockReason,
  credit_indicator AS BillgReqItemIsCreditItem,
  description AS BillgReqItemDescription,
  billreq_i_usage_type AS GrantorPaymentType
FROM crms4d_billreq_i
;