P_AU_STRPPAYTTMESRPTGDOC4

DDL: P_AU_STRPPAYTTMESRPTGDOC4 Type: view_entity COMPOSITE Package: GLO_FIN_IS_AU
34 Fields 1 Data Sources 1 Associations

AU PTR Documents

P_AU_STRPPAYTTMESRPTGDOC4 is a Composite CDS View that provides data about "AU PTR Documents" in SAP S/4HANA. It reads from 1 data source (P_AU_STRPPAYTTMESRPTGDOC3) and exposes 34 fields with key fields CompanyCode, AccountingDocument, FiscalYear, AccountingDocumentItem. It has 1 association to related views. Part of development package GLO_FIN_IS_AU.

Data Sources (1)

SourceAliasJoin Type
P_AU_STRPPAYTTMESRPTGDOC3 P_AU_STRPPAYTTMESRPTGDOC3 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 _PaymentTerms.PaymentTerms = docs.PaymentTerms and _PaymentTerms.PaymentTermsValidityMonthDay is initial

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.private true view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
AccessControl.personalData.blocking #BLOCKED_DATA_INCLUDED view

Fields (34)

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 Posting View Item
PostingDate docs PostingDate Posting Date for GR
CompanyCodeName docs CompanyCodeName Company Name
VATRegistration docs VATRegistration VAT Registration No.
Supplier docs Supplier Supplier
BusinessPartner docs BusinessPartner Issuing Authority
SupplierInvoice docs SupplierInvoice
SupplierInvoiceFiscalYear docs SupplierInvoiceFiscalYear
InvoiceReference docs InvoiceReference Invoice Reference
InvoiceReferenceFiscalYear docs InvoiceReferenceFiscalYear Invoice Reference Fiscal Year
BPTaxNumber docs BPTaxNumber Tax Number
PurchaseOrder docs PurchaseOrder Purchasing Document
PurchaseContract docs PurchaseContract Purchasing Doc.
PaymentDate docs PaymentDate Payment Date
AU_PartialPaymentFlag docs AU_PartialPaymentFlag
InvoiceIssueDate docs InvoiceIssueDate
LastGoodsReceiptPostingDate docs LastGoodsReceiptPostingDate
ReportingDate docs ReportingDate
SupplierInvoiceOrigin docs SupplierInvoiceOrigin IV category
AU_SelfInvoiceFlag docs AU_SelfInvoiceFlag
AU_PurContrPaymentTerms docs AU_PurContrPaymentTerms
PaymentTerms docs PaymentTerms Pyt Terms
AccountingDocumentType docs AccountingDocumentType Journal Entry Type
SupplierAccountGroup docs SupplierAccountGroup Account group
TradingPartner docs TradingPartner Trading Partner
DebitCreditCode docs DebitCreditCode Single-Character Flag
CompanyCodeCurrency docs CompanyCodeCurrency Local Currency
AU_AccountingDocumentType docs AU_AccountingDocumentType
AmountInCompanyCodeCurrency docs AmountInCompanyCodeCurrency Local Crcy Amt
_PTRSmallBusiness docs _PTRSmallBusiness
_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 P_AU_STRPPAYTTMESRPTGDOC4.
-- 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 P_AU_STRPPAYTTMESRPTGDOC4 AS
SELECT
  docs.CompanyCode AS CompanyCode,
  docs.AccountingDocument AS AccountingDocument,
  docs.FiscalYear AS FiscalYear,
  docs.AccountingDocumentItem AS AccountingDocumentItem,
  docs.PostingDate AS PostingDate,
  docs.CompanyCodeName AS CompanyCodeName,
  docs.VATRegistration AS VATRegistration,
  docs.Supplier AS Supplier,
  docs.BusinessPartner AS BusinessPartner,
  docs.SupplierInvoice AS SupplierInvoice,
  docs.SupplierInvoiceFiscalYear AS SupplierInvoiceFiscalYear,
  docs.InvoiceReference AS InvoiceReference,
  docs.InvoiceReferenceFiscalYear AS InvoiceReferenceFiscalYear,
  docs.BPTaxNumber AS BPTaxNumber,
  docs.PurchaseOrder AS PurchaseOrder,
  docs.PurchaseContract AS PurchaseContract,
  docs.PaymentDate AS PaymentDate,
  docs.AU_PartialPaymentFlag AS AU_PartialPaymentFlag,
  docs.InvoiceIssueDate AS InvoiceIssueDate,
  docs.LastGoodsReceiptPostingDate AS LastGoodsReceiptPostingDate,
  docs.ReportingDate AS ReportingDate,
  docs.SupplierInvoiceOrigin AS SupplierInvoiceOrigin,
  docs.AU_SelfInvoiceFlag AS AU_SelfInvoiceFlag,
  docs.AU_PurContrPaymentTerms AS AU_PurContrPaymentTerms,
  docs.PaymentTerms AS PaymentTerms,
  docs.AccountingDocumentType AS AccountingDocumentType,
  docs.SupplierAccountGroup AS SupplierAccountGroup,
  docs.TradingPartner AS TradingPartner,
  docs.DebitCreditCode AS DebitCreditCode,
  docs.CompanyCodeCurrency AS CompanyCodeCurrency,
  docs.AU_AccountingDocumentType AS AU_AccountingDocumentType,
  docs.AmountInCompanyCodeCurrency AS AmountInCompanyCodeCurrency,
  docs._PTRSmallBusiness AS _PTRSmallBusiness,
  docs._ReportedItemsLog AS _ReportedItemsLog
FROM P_AU_STRPPAYTTMESRPTGDOC3
LEFT OUTER JOIN I_PaymentTermsConditions AS _PaymentTerms ON _PaymentTerms.PaymentTerms = docs.PaymentTerms AND _PaymentTerms.PaymentTermsValidityMonthDay is initial  -- association [0..1]
;

Learn More