P_AU_StRpTPARSuplrAcctgDocItm

DDL: P_AU_STRPTPARSUPLRACCTGDOCITM SQL: PAUSRSPLRACCDITM Type: view COMPOSITE Package: GLO_FIN_IS_AU
14 Fields 2 Data Sources

Union of Fully and Partially Cleared Documents

P_AU_StRpTPARSuplrAcctgDocItm is a Composite CDS View that provides data about "Union of Fully and Partially Cleared Documents" in SAP S/4HANA. It reads from 2 data sources (P_AU_StRpTPARFullyPaidInvcDoc, P_AU_StRpTPARPrtlyPaidInvcDoc) and exposes 14 fields with key fields CompanyCode, AccountingDocument, FiscalYear, AccountingDocument, FiscalYear. Part of development package GLO_FIN_IS_AU.

Data Sources (2)

SourceAliasJoin Type
P_AU_StRpTPARFullyPaidInvcDoc P_AU_StRpTPARFullyPaidInvcDoc from
P_AU_StRpTPARPrtlyPaidInvcDoc P_AU_StRpTPARPrtlyPaidInvcDoc union_all

Parameters (2)

NameTypeDefault
P_FromReportingDate figen_rep_date_from
P_ToReportingDate figen_rep_date_to

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PAUSRSPLRACCDITM view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view
VDM.private true view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode CompanyCode Receiver Company Code
KEY AccountingDocument AccountingDocument Invoice Reference
KEY FiscalYear FiscalYear Invoice Reference Fiscal Year
ReportingDate ReportingDate Posting Date for GR
Supplier Supplier Supplier
ClearingJournalEntry ClearingJournalEntry Clrng doc.
PaymentDocument Payment Document Number
KEY AccountingDocument InvoiceReference Invoice Reference
KEY FiscalYear InvoiceReferenceFiscalYear Invoice Reference Fiscal Year
ReportingDate ReportingDate Posting Date for GR
Supplier Supplier Supplier
ClearingJournalEntry Clrng doc.
PaymentDocument PaymentDocument Payment Document Number
TotalGrossAmountInCoCodeCrcy TotalGrossAmountInCoCodeCrcy Amount in LC

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_StRpTPARSuplrAcctgDocItm.
-- 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: PAUSRSPLRACCDITM
-- Parameters: P_FromReportingDate : figen_rep_date_from, P_ToReportingDate : figen_rep_date_to

CREATE VIEW P_AU_StRpTPARSuplrAcctgDocItm AS
SELECT
  CompanyCode,
  AccountingDocument,
  FiscalYear,
  ReportingDate,
  Supplier,
  ClearingJournalEntry,
  cast('' as belnr_d) AS PaymentDocument,
  TotalGrossAmountInCoCodeCrcy
FROM P_AU_StRpTPARFullyPaidInvcDoc
-- UNION ALL with additional select branch(es): P_AU_StRpTPARPrtlyPaidInvcDoc
;

Learn More