I_BillgReqItmSettlmtStatusText

DDL: I_BILLGREQITMSETTLMTSTATUSTEXT SQL: IBILREQISTLSTATX Type: view BASIC
5 Fields 1 Data Sources 2 Associations

Billing Request Item Settlement Status Text

I_BillgReqItmSettlmtStatusText is a Basic CDS View that provides data about "Billing Request Item Settlement Status Text" in SAP S/4HANA. It reads from 1 data source (dd07t) and exposes 5 fields with key fields BillgReqItemBillingStatus, Language. It has 2 associations to related views.

SAP Help Documentation

CategoryService Operations and Processes
StatusBilling Request Item Settlement Status - Text
Purpose
This CDS view is the related text view. • ‘ ’ Not Transferred to Billing • ‘E’ Error in Transfer to Billing • ‘T’ Transferred to Billing • ‘F’ Billed

Prerequisites
Authorizations Users who want to use this CDS view don't need any special authorization.

Structure
Important Fields Important fields in this view include the following: Field Name Description BillgReqItmSettlmtStatusText Billing Request Item Settlement Status - Text

Data Extraction
Data Extraction Type This CDS view is enabled for data extraction in full mode as well as in delta mode. Deltas are determined automatically by change data capture.

View on SAP Help Portal →

Data Sources (1)

SourceAliasJoin Type
dd07t dd07t from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_BillgReqItmSettlmtStatus _BillgReqItmSettlmtStatus $projection.BillgReqItemBillingStatus = _BillgReqItmSettlmtStatus.BillgReqItemBillingStatus
[0..1] I_Language _Language _Language.Language = $projection.Language

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName IBILREQISTLSTATX view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Billing Request Item Settlement Status Text view
VDM.viewType #BASIC view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.representativeKey BillgReqItemBillingStatus view
Metadata.ignorePropagatedAnnotations true view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY BillgReqItemBillingStatus domvalue_l Lower Value
KEY Language ddlanguage Lang.
BillgReqItemBillingStatusName ddtext Short text
_BillgReqItmSettlmtStatus _BillgReqItmSettlmtStatus
_Language _Language

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_BillgReqItmSettlmtStatusText.
-- 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: IBILREQISTLSTATX

CREATE VIEW I_BillgReqItmSettlmtStatusText AS
SELECT
  domvalue_l AS BillgReqItemBillingStatus,
  ddlanguage AS Language,
  ddtext AS BillgReqItemBillingStatusName
FROM dd07t
LEFT OUTER JOIN I_BillgReqItmSettlmtStatus AS _BillgReqItmSettlmtStatus ON BillgReqItemBillingStatus = _BillgReqItmSettlmtStatus.BillgReqItemBillingStatus  -- association [1..1]
LEFT OUTER JOIN I_Language AS _Language ON _Language.Language = Language  -- association [0..1]
;

Learn More