C_PT_SAFTPaymentQry

DDL: C_PT_SAFTPAYMENTQRY SQL: CPTSAFTPAYQRY Type: view CONSUMPTION
20 Fields 1 Data Sources

SAFT PT Billing Payments - Qry

C_PT_SAFTPaymentQry is a Consumption CDS View that provides data about "SAFT PT Billing Payments - Qry" in SAP S/4HANA. It reads from 1 data source (I_PT_SAFTPaymentCube) and exposes 20 fields.

Data Sources (1)

SourceAliasJoin Type
I_PT_SAFTPaymentCube I_PT_SAFTPaymentCube from

Parameters (3)

NameTypeDefault
P_CompanyCode bukrs
P_StartDate begda
P_EndDate endda

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName CPTSAFTPAYQRY view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
EndUserText.label SAFT PT Billing Payments - Qry view
Metadata.ignorePropagatedAnnotations true view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #CONSUMPTION view
Analytics.query true view

Fields (20)

KeyFieldSource TableSource FieldDescription
keyCompanyCode
keyPaymentReference Payment Refeference No
DocumentItemNumber Line Number
IN_InvoiceDate IN_InvoiceDate Inv.Date from SourceDocument
PT_SeriesDocumentType PT_SeriesDocumentType PaymentType
DocumentBillingStatus DocumentBillingStatus PaymentStatus
PT_SeriesDocumentNumber PT_SeriesDocumentNumber ATCUD Code
CompanyCodeCurrency CompanyCodeCurrency Company Code Currency
DebitAmountInCoCodeCrcy DebitAmountInCoCodeCrcy Debit Amount in Company Code Currency
CreditAmountInCoCodeCrcy CreditAmountInCoCodeCrcy Credit Amount in Company Code Currency
CustomerPaymentMethodName CustomerPaymentMethodName
PaymentAmount PaymentAmount Payment Amount
PaymentDate PaymentDate Payment Date
NetAmount NetAmount Net Total
GrossAmount GrossAmount Gross Total
BusinessPartnerCustomer BusinessPartnerCustomer CustomerID
ExchangeRate ExchangeRate Exchange rate
TransactionCurrency TransactionCurrency Transaction Currency
TotalGrossAmountInTransCrcy TotalGrossAmountInTransCrcy Total Amt In Tr Crcy
PT_SAFTInvoiceReference PT_SAFTInvoiceReference Originating ON

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_PT_SAFTPaymentQry.
-- 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: CPTSAFTPAYQRY
-- Parameters: P_CompanyCode : bukrs, P_StartDate : begda, P_EndDate : endda

CREATE VIEW C_PT_SAFTPaymentQry AS
SELECT
  IN_InvoiceDate,
  PT_SeriesDocumentType,
  DocumentBillingStatus,
  PT_SeriesDocumentNumber,
  CompanyCodeCurrency,
  DebitAmountInCoCodeCrcy,
  CreditAmountInCoCodeCrcy,
  CustomerPaymentMethodName,
  PaymentAmount,
  PaymentDate,
  NetAmount,
  GrossAmount,
  BusinessPartnerCustomer,
  ExchangeRate,
  TransactionCurrency,
  TotalGrossAmountInTransCrcy,
  PT_SAFTInvoiceReference
FROM I_PT_SAFTPaymentCube
;

Learn More