C_PaymentBatchPaymentDocument

DDL: C_PAYMENTBATCHPAYMENTDOCUMENT Type: view_entity CONSUMPTION Package: ODATA_PROCESS_FF_PAYMENTS

Payment Batch Payment Documents

C_PaymentBatchPaymentDocument is a Consumption CDS View that provides data about "Payment Batch Payment Documents" in SAP S/4HANA. It reads from 1 data source (I_MonitorBankPaymentBatchItem) and exposes 7 fields with key fields PayingCompanyCode, PaymentDocument, FiscalYear. It has 1 association to related views. Part of development package ODATA_PROCESS_FF_PAYMENTS.

Data Sources (1)

SourceAliasJoin Type
I_MonitorBankPaymentBatchItem PaymentBatch from

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_SystemStatusText _SystemStatusText $projection.Status = _SystemStatusText.SystemStatus

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #CONSUMPTION view
EndUserText.label Payment Batch Payment Documents view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY PayingCompanyCode PayingCompanyCode Paying Company Code
KEY PaymentDocument PaymentDocument Payment Document Number
KEY FiscalYear _FiscalCalendarDate FiscalYear G/L Fiscal Year
PaymentBatch PaymentBatch
BatchUUID BatchUUID Target Grp GUID
PaymentBatchItem PaymentBatchItem
Status Status Workflow Status

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_PaymentBatchPaymentDocument.
-- 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_PaymentBatchPaymentDocument AS
SELECT
  PayingCompanyCode,
  PaymentDocument,
  _FiscalCalendarDate.FiscalYear AS FiscalYear,
  PaymentBatch,
  BatchUUID,
  PaymentBatchItem,
  Status
FROM I_MonitorBankPaymentBatchItem AS PaymentBatch
LEFT OUTER JOIN I_SystemStatusText AS _SystemStatusText ON Status = _SystemStatusText.SystemStatus  -- association [0..*]
;