I_ComplaintBillingStatus

DDL: I_COMPLAINTBILLINGSTATUS Type: view_entity BASIC
5 Fields 1 Data Sources 1 Associations

Complaint Billing Status

I_ComplaintBillingStatus is a Basic CDS View that provides data about "Complaint Billing Status" in SAP S/4HANA. It reads from 1 data source (vbrp) and exposes 5 fields with key fields SalesDocument, DocumentItemNumber. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
vbrp ComplaintBillingStatus from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_OverallBillingStatusText BillingStatus ComplaintBillingStatus.vf_status_ana = BillingStatus.OverallBillingStatus and BillingStatus.Language = $session.system_language

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #XL view
Metadata.ignorePropagatedAnnotations true view
AccessControl.personalData.blocking #NOT_REQUIRED view
VDM.viewType #BASIC view
EndUserText.label Complaint Billing Status view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY SalesDocument vbeln SD Sched. Agmt
KEY DocumentItemNumber posnr WBS Element
DocumentBillingStatus vf_status_ana Status
OverallBillingStatusDesc BillingStatus OverallBillingStatusDesc
DeliveryDocumentItemCategory pstyv Item Category

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_ComplaintBillingStatus.
-- 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_ComplaintBillingStatus AS
SELECT
  vbeln AS SalesDocument,
  posnr AS DocumentItemNumber,
  vf_status_ana AS DocumentBillingStatus,
  BillingStatus.OverallBillingStatusDesc AS OverallBillingStatusDesc,
  pstyv AS DeliveryDocumentItemCategory
FROM vbrp AS ComplaintBillingStatus
LEFT OUTER JOIN I_OverallBillingStatusText AS BillingStatus ON ComplaintBillingStatus.vf_status_ana = BillingStatus.OverallBillingStatus AND BillingStatus.Language = $session.system_language  -- association [0..1]
;

Learn More