P_APFlexibleAging1

DDL: P_APFLEXIBLEAGING1 SQL: PAPFLXBLAGING1 Type: view COMPOSITE Package: FINS_FIS_AP_APPS
43 Fields 4 Data Sources

Accounts Payables Flexible Aging 1

P_APFlexibleAging1 is a Composite CDS View that provides data about "Accounts Payables Flexible Aging 1" in SAP S/4HANA. It reads from 4 data sources (I_ReceivablesPayablesItem, P_Apflexibleaging0, P_Apflexibleaging0, I_ReceivablesPayablesItem) and exposes 43 fields with key fields CompanyCode, AccountingDocument, AccountingDocumentItem, FiscalYear, AccountingDocument. Part of development package FINS_FIS_AP_APPS.

Data Sources (4)

SourceAliasJoin Type
I_ReceivablesPayablesItem OpenPayables from
P_Apflexibleaging0 ParkedPayables union_all
P_Apflexibleaging0 ReferencedParkedPayables left_outer
I_ReceivablesPayablesItem ReferencedPayables left_outer

Parameters (1)

NameTypeDefault
P_KeyDate abap.dats

Annotations (6)

NameValueLevelField
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.private true view
AbapCatalog.sqlViewName PAPFLXBLAGING1 view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view

Fields (43)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_ReceivablesPayablesItem CompanyCode Receiver Company Code
KEY AccountingDocument I_ReceivablesPayablesItem AccountingDocument Journal Entry
KEY AccountingDocumentItem I_ReceivablesPayablesItem AccountingDocumentItem Posting View Item
KEY FiscalYear I_ReceivablesPayablesItem FiscalYear G/L Fiscal Year
InvoiceReference I_ReceivablesPayablesItem InvoiceReference Invoice Reference
InvoiceItemReference I_ReceivablesPayablesItem InvoiceItemReference Item
InvoiceReferenceFiscalYear I_ReceivablesPayablesItem InvoiceReferenceFiscalYear Invoice Reference Fiscal Year
FollowOnDocumentType I_ReceivablesPayablesItem FollowOnDocumentType Follow-On Document Type
NetDueDate I_ReceivablesPayablesItem NetDueDate Net Due Date
TransactionCurrency I_ReceivablesPayablesItem TransactionCurrency Transaction Currency
BusinessArea I_ReceivablesPayablesItem BusinessArea Business Area
ReconciliationAccount I_ReceivablesPayablesItem GLAccount Recon. account
SpecialGLCode I_ReceivablesPayablesItem SpecialGLCode Special G/L Ind
Supplier I_ReceivablesPayablesItem Creditor Supplier
PaymentMethod I_ReceivablesPayablesItem PaymentMethod Pymt Meth.
PaymentTerms I_ReceivablesPayablesItem PaymentTerms Pyt Terms
CompanyCodeCurrency I_ReceivablesPayablesItem CompanyCodeCurrency Local Currency
AccountingDocumentCategory I_ReceivablesPayablesItem AccountingDocumentCategory Journal Entry Category
AmountInCompanyCodeCurrency
NumberOfOpenItems
RefInvcDocumentDate I_ReceivablesPayablesItem DocumentDate Journal Entry Date
CompanyCodeasCompanyCode
KEY AccountingDocument P_Apflexibleaging0 AccountingDocument Journal Entry
KEY AccountingDocumentItem P_Apflexibleaging0 AccountingDocumentItem Posting View Item
KEY FiscalYear P_Apflexibleaging0 FiscalYear G/L Fiscal Year
InvoiceReference P_Apflexibleaging0 InvoiceReference Invoice Reference
InvoiceItemReference P_Apflexibleaging0 InvoiceItemReference Item
InvoiceReferenceFiscalYear P_Apflexibleaging0 InvoiceReferenceFiscalYear Invoice Reference Fiscal Year
FollowOnDocumentType P_Apflexibleaging0 FollowOnDocumentType Follow-On Document Type
NetDueDate P_Apflexibleaging0 NetDueDate Net Due Date
TransactionCurrency P_Apflexibleaging0 TransactionCurrency Transaction Currency
BusinessArea P_Apflexibleaging0 BusinessArea Business Area
ReconciliationAccount P_Apflexibleaging0 ReconciliationAccount Recon. account
SpecialGLCode P_Apflexibleaging0 SpecialGLCode Special G/L Ind
Supplier P_Apflexibleaging0 Supplier Supplier
PaymentMethod P_Apflexibleaging0 PaymentMethod Pymt Meth.
PaymentTerms P_Apflexibleaging0 PaymentTerms Pyt Terms
CompanyCodeCurrency P_Apflexibleaging0 CompanyCodeCurrency Local Currency
AccountingDocumentCategory P_Apflexibleaging0 AccountingDocumentCategory Journal Entry Category
AmountInCompanyCodeCurrency
NumberOfOpenItems
RefInvcDocumentDate P_Apflexibleaging0 DocumentDate Journal Entry Date
RefInvcNetDueDate P_Apflexibleaging0 NetDueDate Net Due Date

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_APFlexibleAging1.
-- 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: PAPFLXBLAGING1
-- Parameters: P_KeyDate : abap.dats

CREATE VIEW P_APFlexibleAging1 AS
SELECT
  OpenPayables.CompanyCode AS CompanyCode,
  OpenPayables.AccountingDocument AS AccountingDocument,
  OpenPayables.AccountingDocumentItem AS AccountingDocumentItem,
  OpenPayables.FiscalYear AS FiscalYear,
  OpenPayables.InvoiceReference AS InvoiceReference,
  OpenPayables.InvoiceItemReference AS InvoiceItemReference,
  OpenPayables.InvoiceReferenceFiscalYear AS InvoiceReferenceFiscalYear,
  OpenPayables.FollowOnDocumentType AS FollowOnDocumentType,
  OpenPayables.NetDueDate AS NetDueDate,
  OpenPayables.TransactionCurrency AS TransactionCurrency,
  OpenPayables.BusinessArea AS BusinessArea,
  OpenPayables.GLAccount AS ReconciliationAccount,
  OpenPayables.SpecialGLCode AS SpecialGLCode,
  OpenPayables.Creditor AS Supplier,
  OpenPayables.PaymentMethod AS PaymentMethod,
  OpenPayables.PaymentTerms AS PaymentTerms,
  OpenPayables.CompanyCodeCurrency AS CompanyCodeCurrency,
  OpenPayables.AccountingDocumentCategory AS AccountingDocumentCategory,
  cast(-OpenPayables.AmountInCompanyCodeCurrency as dmshb_farp) AS AmountInCompanyCodeCurrency,
  cast( 1 as abap.int4 ) AS NumberOfOpenItems,
  ReferencedPayables.DocumentDate AS RefInvcDocumentDate,
  ReferencedPayables.NetDueDate as RefInvcNetDueDate AS CompanyCodeasCompanyCode,
  ReferencedParkedPayables.NetDueDate AS RefInvcNetDueDate
FROM I_ReceivablesPayablesItem AS OpenPayables
LEFT OUTER JOIN I_ReceivablesPayablesItem AS ReferencedPayables ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_Apflexibleaging0 AS ReferencedParkedPayables ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): P_Apflexibleaging0
;

Learn More