P_Apflexibleaging0

DDL: P_APFLEXIBLEAGING0 SQL: PAPFLXBLAGING0 Type: view COMPOSITE Package: FINS_FIS_AP_APPS
23 Fields 1 Data Sources

Accounts Payables Flexible Aging 0

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

Data Sources (1)

SourceAliasJoin Type
I_ParkedPayablesItem I_ParkedPayablesItem from

Annotations (6)

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

Fields (23)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_ParkedPayablesItem CompanyCode Receiver Company Code
KEY AccountingDocument I_ParkedPayablesItem AccountingDocument Journal Entry
KEY AccountingDocumentItem I_ParkedPayablesItem AccountingDocumentItem Posting View Item
KEY FiscalYear I_ParkedPayablesItem FiscalYear G/L Fiscal Year
InvoiceReference I_ParkedPayablesItem InvoiceReference Invoice Reference
InvoiceItemReference I_ParkedPayablesItem InvoiceItemReference Item
InvoiceReferenceFiscalYear I_ParkedPayablesItem InvoiceReferenceFiscalYear Invoice Reference Fiscal Year
FollowOnDocumentType I_ParkedPayablesItem FollowOnDocumentType Follow-On Document Type
NetDueDate I_ParkedPayablesItem NetDueDate Net Due Date
TransactionCurrency I_ParkedPayablesItem TransactionCurrency Transaction Currency
BusinessArea I_ParkedPayablesItem BusinessArea Business Area
ReconciliationAccount I_ParkedPayablesItem GLAccount General Ledger
SpecialGLCode I_ParkedPayablesItem SpecialGLCode Special G/L Ind
Supplier I_ParkedPayablesItem Creditor Supplier
PaymentMethod I_ParkedPayablesItem PaymentMethod Pymt Meth.
PaymentTerms I_ParkedPayablesItem PaymentTerms Pyt Terms
CompanyCodeCurrency I_ParkedPayablesItem CompanyCodeCurrency Local Currency
AccountingDocumentCategory _ParkedAccountingDocument AccountingDocumentCategory Journal Entry Category
PostingDate _ParkedAccountingDocument PostingDate Posting Date for GR
DocumentDate _ParkedAccountingDocument DocumentDate Journal Entry Date
FinancialAccountType
ClearingDate
AmountInCompanyCodeCurrency I_ParkedPayablesItem AmountInCompanyCodeCurrency Local Crcy Amt

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_Apflexibleaging0.
-- 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: PAPFLXBLAGING0

CREATE VIEW P_Apflexibleaging0 AS
SELECT
  I_ParkedPayablesItem.CompanyCode AS CompanyCode,
  I_ParkedPayablesItem.AccountingDocument AS AccountingDocument,
  I_ParkedPayablesItem.AccountingDocumentItem AS AccountingDocumentItem,
  I_ParkedPayablesItem.FiscalYear AS FiscalYear,
  I_ParkedPayablesItem.InvoiceReference AS InvoiceReference,
  I_ParkedPayablesItem.InvoiceItemReference AS InvoiceItemReference,
  I_ParkedPayablesItem.InvoiceReferenceFiscalYear AS InvoiceReferenceFiscalYear,
  I_ParkedPayablesItem.FollowOnDocumentType AS FollowOnDocumentType,
  I_ParkedPayablesItem.NetDueDate AS NetDueDate,
  I_ParkedPayablesItem.TransactionCurrency AS TransactionCurrency,
  I_ParkedPayablesItem.BusinessArea AS BusinessArea,
  I_ParkedPayablesItem.GLAccount AS ReconciliationAccount,
  I_ParkedPayablesItem.SpecialGLCode AS SpecialGLCode,
  I_ParkedPayablesItem.Creditor AS Supplier,
  I_ParkedPayablesItem.PaymentMethod AS PaymentMethod,
  I_ParkedPayablesItem.PaymentTerms AS PaymentTerms,
  I_ParkedPayablesItem.CompanyCodeCurrency AS CompanyCodeCurrency,
  _ParkedAccountingDocument.AccountingDocumentCategory AS AccountingDocumentCategory,
  _ParkedAccountingDocument.PostingDate AS PostingDate,
  _ParkedAccountingDocument.DocumentDate AS DocumentDate,
  'K' AS FinancialAccountType,
  '00000000' AS ClearingDate,
  I_ParkedPayablesItem.AmountInCompanyCodeCurrency AS AmountInCompanyCodeCurrency
FROM I_ParkedPayablesItem
;

Learn More