I_AU_StRpPTRTrdCrdtPaytCube

DDL: I_AU_STRPPTRTRDCRDTPAYTCUBE Type: view_entity COMPOSITE Package: GLO_FIN_IS_AU
38 Fields 2 Data Sources 1 Associations

AU PTR TradeCredit Payments - Cube

I_AU_StRpPTRTrdCrdtPaytCube is a Composite CDS View (Cube) that provides data about "AU PTR TradeCredit Payments - Cube" in SAP S/4HANA. It reads from 2 data sources (I_AU_PTRBusinessIdentification, P_AU_STRPPAYTTMESRPTGDOC4) and exposes 38 fields with key fields CompanyCode, AccountingDocument, FiscalYear, AccountingDocumentItem, StatryRptgEntity. It has 1 association to related views. Part of development package GLO_FIN_IS_AU.

Data Sources (2)

SourceAliasJoin Type
I_AU_PTRBusinessIdentification _PTRBusinessIdentification inner
P_AU_STRPPAYTTMESRPTGDOC4 P_AU_STRPPAYTTMESRPTGDOC4 from

Parameters (3)

NameTypeDefault
P_AU_InvoiceIssueDateType fiau_invoice_issue_date_type
P_FromReportingDate figen_rep_date_from
P_ToReportingDate figen_rep_date_to

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_PaymentTermsConditions _PaymentTerms $projection.PaymentTerms = _PaymentTerms.PaymentTerms and _PaymentTerms.PaymentTermsValidityMonthDay is initial

Annotations (10)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
Metadata.allowExtensions true view
Analytics.dataCategory #CUBE view
Analytics.internalName #LOCAL view
ObjectModel.usageType.sizeCategory #XXL view
AccessControl.personalData.blocking #BLOCKED_DATA_INCLUDED view
VDM.viewType #COMPOSITE view
EndUserText.label AU PTR TradeCredit Payments - Cube view

Fields (38)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode docs CompanyCode Receiver Company Code
KEY AccountingDocument docs AccountingDocument Journal Entry
KEY FiscalYear docs FiscalYear G/L Fiscal Year
KEY AccountingDocumentItem docs AccountingDocumentItem Journal Entry Item
KEY StatryRptgEntity
KEY StatryRptCategory
KEY StatryRptRunID
Supplier docs Supplier Supplier
CompanyCodeName docs CompanyCodeName Company Name
VATRegistration docs VATRegistration Company Code ABN
BPTaxNumber docs BPTaxNumber Supplier ABN
AccountingDocumentType docs AccountingDocumentType Journal Entry Type
SupplierAccountGroup docs SupplierAccountGroup Account group
TradingPartner docs TradingPartner Trading Partner
PostingDate docs PostingDate Posting Date for GR
InvoiceIssueDate docs InvoiceIssueDate Invoice Issue Date
PaymentDate docs PaymentDate Payment Date
ReportingDate docs ReportingDate
AU_AccountingDocumentType docs AU_AccountingDocumentType
PaymentDate1endelse0endasNumberOfDays Payment Time in Calendar Days
NetPaymentDays docs NetPaymentDays Payment Terms in Calendar Days
DebitCreditCode docs DebitCreditCode Single-Character Flag
AU_PurContrPaymentTerms docs AU_PurContrPaymentTerms Purchase Contract Payment Terms
PaymentTerms docs PaymentTerms Pyt Terms
AU_PartialPaymentFlag docs AU_PartialPaymentFlag Partial Payment(Y/N)
AU_CreditCardPaymentFlag Credit Card Payment(Y/N)
LastGoodsReceiptPostingDate docs LastGoodsReceiptPostingDate Supply Date
AU_SelfInvoiceFlag docs AU_SelfInvoiceFlag Recipient-created tax invoice(Y/N)
SupplierInvoiceOrigin docs SupplierInvoiceOrigin Supplier Invoice Origin
InvoiceReference docs InvoiceReference Invoice Reference
InvoiceReferenceFiscalYear docs InvoiceReferenceFiscalYear Invoice Reference Fiscal Year
SupplierInvoice docs SupplierInvoice
SupplierInvoiceFiscalYear docs SupplierInvoiceFiscalYear Supplier Invoice Fiscal Year
PurchaseOrder docs PurchaseOrder Purchasing Document
PurchaseContract docs PurchaseContract Purchasing Doc.
CompanyCodeCurrency docs CompanyCodeCurrency Local Currency
AmountInCompanyCodeCurrency docs AmountInCompanyCodeCurrency Local Crcy Amt
_ReportedItemsLog docs _ReportedItemsLog

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_AU_StRpPTRTrdCrdtPaytCube.
-- 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.
-- Parameters: P_AU_InvoiceIssueDateType : fiau_invoice_issue_date_type, P_FromReportingDate : figen_rep_date_from, P_ToReportingDate : figen_rep_date_to

CREATE VIEW I_AU_StRpPTRTrdCrdtPaytCube AS
SELECT
  docs.CompanyCode AS CompanyCode,
  docs.AccountingDocument AS AccountingDocument,
  docs.FiscalYear AS FiscalYear,
  docs.AccountingDocumentItem AS AccountingDocumentItem,
  docs._ReportedItemsLog.StatryRptgEntity AS StatryRptgEntity,
  docs._ReportedItemsLog.StatryRptCategory AS StatryRptCategory,
  docs._ReportedItemsLog.StatryRptRunID AS StatryRptRunID,
  docs.Supplier AS Supplier,
  docs.CompanyCodeName AS CompanyCodeName,
  docs.VATRegistration AS VATRegistration,
  docs.BPTaxNumber AS BPTaxNumber,
  docs.AccountingDocumentType AS AccountingDocumentType,
  docs.SupplierAccountGroup AS SupplierAccountGroup,
  docs.TradingPartner AS TradingPartner,
  docs.PostingDate AS PostingDate,
  docs.InvoiceIssueDate AS InvoiceIssueDate,
  docs.PaymentDate AS PaymentDate,
  docs.ReportingDate AS ReportingDate,
  docs.AU_AccountingDocumentType AS AU_AccountingDocumentType,
  case docs.AU_PartialPaymentFlag when 'N' then case when docs.InvoiceIssueDate = docs.PaymentDate then 0 else abs ( dats_days_between( docs.InvoiceIssueDate, docs.PaymentDate ) + 1 ) end else 0 end as NumberOfDays AS PaymentDate1endelse0endasNumberOfDays,
  docs.NetPaymentDays AS NetPaymentDays,
  docs.DebitCreditCode AS DebitCreditCode,
  docs.AU_PurContrPaymentTerms AS AU_PurContrPaymentTerms,
  docs.PaymentTerms AS PaymentTerms,
  docs.AU_PartialPaymentFlag AS AU_PartialPaymentFlag,
  'N' AS AU_CreditCardPaymentFlag,
  docs.LastGoodsReceiptPostingDate AS LastGoodsReceiptPostingDate,
  docs.AU_SelfInvoiceFlag AS AU_SelfInvoiceFlag,
  docs.SupplierInvoiceOrigin AS SupplierInvoiceOrigin,
  docs.InvoiceReference AS InvoiceReference,
  docs.InvoiceReferenceFiscalYear AS InvoiceReferenceFiscalYear,
  docs.SupplierInvoice AS SupplierInvoice,
  docs.SupplierInvoiceFiscalYear AS SupplierInvoiceFiscalYear,
  docs.PurchaseOrder AS PurchaseOrder,
  docs.PurchaseContract AS PurchaseContract,
  docs.CompanyCodeCurrency AS CompanyCodeCurrency,
  docs.AmountInCompanyCodeCurrency AS AmountInCompanyCodeCurrency,
  docs._ReportedItemsLog AS _ReportedItemsLog
FROM P_AU_STRPPAYTTMESRPTGDOC4
INNER JOIN I_AU_PTRBusinessIdentification AS _PTRBusinessIdentification ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_PaymentTermsConditions AS _PaymentTerms ON PaymentTerms = _PaymentTerms.PaymentTerms AND _PaymentTerms.PaymentTermsValidityMonthDay is initial  -- association [0..1]
;

Learn More