C_CABillgDocPayment

DDL: C_CABILLGDOCPAYMENT Type: view_entity CONSUMPTION

Zahldatenpositionen des Abr.belegs

C_CABillgDocPayment is a Consumption CDS View that provides data about "Zahldatenpositionen des Abr.belegs" in SAP S/4HANA. It reads from 1 data source (R_CABillgDocPaymentItemTP) and exposes 17 fields with key fields CABillgDocument, CABillgDocPaymentItem.

Data Sources (1)

SourceAliasJoin Type
R_CABillgDocPaymentItemTP R_CABillgDocPaymentItemTP projection

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label Zahldatenpositionen des Abr.belegs view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
Metadata.allowExtensions true view
VDM.viewType #CONSUMPTION view

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY CABillgDocument _CABillgDocPayment CABillgDocument Billing Doc.
KEY CABillgDocPaymentItem _CABillgDocPayment CABillgDocPaymentItem
CABillgGrpgOfPaymentData _CABillgDocPayment CABillgGrpgOfPaymentData Pmt Data Group
CABillgPaymentReference _CABillgDocPayment CABillgPaymentReference
CABillgPaymentAmount _CABillgDocPayment CABillgPaymentAmount
TransactionCurrency _CABillgDocPayment TransactionCurrency Transaction Currency
CABillgDocPaytItmExtSyst _CABillgDocPayment CABillgDocPaytItmExtSyst
CAInvcgDocItemIsReversal _CABillgDocPayment CAInvcgDocItemIsReversal Reversal Item
CAPaymentMethod _CABillgDocPayment CAPaymentMethod Payment Method
CABankOfAltvBPForPayment _CABillgDocPayment CABankOfAltvBPForPayment Bank Details
CAAltvBPForPayment _CABillgDocPayment CAAltvBPForPayment Partner
CAKeyForPaymentCardSupplement _CABillgDocPayment CAKeyForPaymentCardSupplement
CAPaymentBillingStatus _CABillgDocPayment CAPaymentBillingStatus
CABillgDocPaymentItemPriority _CABillgDocPayment CABillgDocPaymentItemPriority
CABillgGroupingSourceItems _CABillgDocPayment CABillgGroupingSourceItems Source Item Grp
CAPaymentBillingStatusText
_CABillgDocument _CABillgDocument

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_CABillgDocPayment.
-- 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 C_CABillgDocPayment AS
SELECT
  _CABillgDocPayment.CABillgDocument AS CABillgDocument,
  _CABillgDocPayment.CABillgDocPaymentItem AS CABillgDocPaymentItem,
  _CABillgDocPayment.CABillgGrpgOfPaymentData AS CABillgGrpgOfPaymentData,
  _CABillgDocPayment.CABillgPaymentReference AS CABillgPaymentReference,
  _CABillgDocPayment.CABillgPaymentAmount AS CABillgPaymentAmount,
  _CABillgDocPayment.TransactionCurrency AS TransactionCurrency,
  _CABillgDocPayment.CABillgDocPaytItmExtSyst AS CABillgDocPaytItmExtSyst,
  _CABillgDocPayment.CAInvcgDocItemIsReversal AS CAInvcgDocItemIsReversal,
  _CABillgDocPayment.CAPaymentMethod AS CAPaymentMethod,
  _CABillgDocPayment.CABankOfAltvBPForPayment AS CABankOfAltvBPForPayment,
  _CABillgDocPayment.CAAltvBPForPayment AS CAAltvBPForPayment,
  _CABillgDocPayment.CAKeyForPaymentCardSupplement AS CAKeyForPaymentCardSupplement,
  _CABillgDocPayment.CAPaymentBillingStatus AS CAPaymentBillingStatus,
  _CABillgDocPayment.CABillgDocPaymentItemPriority AS CABillgDocPaymentItemPriority,
  _CABillgDocPayment.CABillgGroupingSourceItems AS CABillgGroupingSourceItems,
  _CAPaymentBillingStatus._CAPaymentBillingStatusText[1: Language=$session.system_language].CAPaymentBillingStatusText AS CAPaymentBillingStatusText
FROM R_CABillgDocPaymentItemTP
;