P_GB_APParkedInvc

DDL: P_GB_APPARKEDINVC Type: view_entity COMPOSITE Package: GLO_FIN_IS_GB_AP
41 Fields 1 Data Sources 2 Associations

GB VAT AP Parked Invoices

P_GB_APParkedInvc is a Composite CDS View that provides data about "GB VAT AP Parked Invoices" in SAP S/4HANA. It reads from 1 data source (I_ParkedDocumentTaxItem) and exposes 41 fields with key fields CompanyCode, FiscalYear, AccountingDocument, LedgerGLLineItem. It has 2 associations to related views. Part of development package GLO_FIN_IS_GB_AP.

Data Sources (1)

SourceAliasJoin Type
I_ParkedDocumentTaxItem TaxItem from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_ParkedOplAcctgDocPyblsItem _ParkedPayablesItem TaxItem.SourceCompanyCode = _ParkedPayablesItem.SourceCompanyCode and TaxItem.AccountingDocument = _ParkedPayablesItem.SourceAccountingDocument and TaxItem.FiscalYear = _ParkedPayablesItem.SourceFiscalYear
[0..1] P_GB_TaxCodeCustomizing _TaxCust _TaxCust.TaxCode = TaxItem.TaxCode

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view
VDM.private true view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view

Fields (41)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_ParkedDocumentTaxItem SourceCompanyCode Source CoCode
KEY FiscalYear I_ParkedDocumentTaxItem FiscalYear G/L Fiscal Year
KEY AccountingDocument I_ParkedDocumentTaxItem AccountingDocument Journal Entry
KEY LedgerGLLineItem
TaxCode I_ParkedDocumentTaxItem TaxCode Tax Code
DebitCreditCode I_ParkedDocumentTaxItem DebitCreditCode Single-Character Flag
TaxCountry I_ParkedDocumentTaxItem TaxCountry Tax Ctry/Reg.
TaxDeterminationDate I_ParkedDocumentTaxItem TaxDeterminationDate Tx Determination Dte
TaxRateValidityStartDate I_ParkedDocumentTaxItem TaxRateValidityStartDate Tax Rate Validity Start Date
SourceAccountingDocumentItem ParkedGLItem SourceAccountingDocumentItem
DocumentDate
PostingDate
ValueDate ParkedGLItem ValueDate Value Date
GLAccount ParkedGLItem GLAccount General Ledger
AssignmentReference ParkedGLItem AssignmentReference Assignment Reference
FinancialAccountType ParkedGLItem FinancialAccountType Fin. Account Type
CompanyCodeCurrency ParkedGLItem CompanyCodeCurrency Local Currency
TransactionCurrency ParkedGLItem TransactionCurrency Transaction Currency
DueCalculationBaseDate ParkedGLItem DueCalculationBaseDate Due Calculation Base Date
NetDueDate ParkedGLItem NetDueDate Net Due Date
ParkedAcctgDocPyblsItem _ParkedPayablesItem ParkedAcctgDocPyblsItem
FollowOnDocumentType _ParkedPayablesItem FollowOnDocumentType Follow-On Document Type
SpecialGLCode _ParkedPayablesItem SpecialGLCode Special G/L Ind
InvoiceReference _ParkedPayablesItem InvoiceReference Invoice Reference
InvoiceItemReference _ParkedPayablesItem InvoiceItemReference Item
InvoiceReferenceFiscalYear _ParkedPayablesItem InvoiceReferenceFiscalYear Invoice Reference Fiscal Year
Supplier _ParkedPayablesItem Supplier Supplier
SupplierFullName
CityName
PostalCode
StreetName
TransactionTypeDetermination _TaxCust TransactionTypeDetermination Transaction Key
ConditionType _TaxCust ConditionType Condition type
TxDatFron _TaxCust ConditionValidityStartDate Valid From
AmountInCompanyCodeCurrency
AmountInTransactionCurrency
TaxBaseAmountInCoCodeCrcy
TaxBaseAmountInTransCrcy
TaxRate _TaxCust TaxRate Tax Rate
CalcTaxAmountInCoCodeCrcy
CalculatedTaxAmountInTransCurr

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_GB_APParkedInvc.
-- 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.

CREATE VIEW P_GB_APParkedInvc AS
SELECT
  TaxItem.SourceCompanyCode AS CompanyCode,
  TaxItem.FiscalYear AS FiscalYear,
  TaxItem.AccountingDocument AS AccountingDocument,
  cast( lpad(TaxItem.ParkedAccountingDocumentItem,6,'0') as docln6 ) AS LedgerGLLineItem,
  TaxItem.TaxCode AS TaxCode,
  TaxItem.DebitCreditCode AS DebitCreditCode,
  TaxItem.TaxCountry AS TaxCountry,
  TaxItem.TaxDeterminationDate AS TaxDeterminationDate,
  TaxItem.TaxRateValidityStartDate AS TaxRateValidityStartDate,
  ParkedGLItem.SourceAccountingDocumentItem AS SourceAccountingDocumentItem,
  ParkedGLItem._SourceParkedOplAcctgDocument.DocumentDate AS DocumentDate,
  ParkedGLItem._SourceParkedOplAcctgDocument.PostingDate AS PostingDate,
  ParkedGLItem.ValueDate AS ValueDate,
  ParkedGLItem.GLAccount AS GLAccount,
  ParkedGLItem.AssignmentReference AS AssignmentReference,
  ParkedGLItem.FinancialAccountType AS FinancialAccountType,
  ParkedGLItem.CompanyCodeCurrency AS CompanyCodeCurrency,
  ParkedGLItem.TransactionCurrency AS TransactionCurrency,
  ParkedGLItem.DueCalculationBaseDate AS DueCalculationBaseDate,
  ParkedGLItem.NetDueDate AS NetDueDate,
  _ParkedPayablesItem.ParkedAcctgDocPyblsItem AS ParkedAcctgDocPyblsItem,
  _ParkedPayablesItem.FollowOnDocumentType AS FollowOnDocumentType,
  _ParkedPayablesItem.SpecialGLCode AS SpecialGLCode,
  _ParkedPayablesItem.InvoiceReference AS InvoiceReference,
  _ParkedPayablesItem.InvoiceItemReference AS InvoiceItemReference,
  _ParkedPayablesItem.InvoiceReferenceFiscalYear AS InvoiceReferenceFiscalYear,
  _ParkedPayablesItem.Supplier AS Supplier,
  _ParkedPayablesItem._Supplier.BPSupplierFullName AS SupplierFullName,
  _ParkedPayablesItem._Supplier.CityName AS CityName,
  _ParkedPayablesItem._Supplier.PostalCode AS PostalCode,
  _ParkedPayablesItem._Supplier.StreetName AS StreetName,
  _TaxCust.TransactionTypeDetermination AS TransactionTypeDetermination,
  _TaxCust.ConditionType AS ConditionType,
  _TaxCust.ConditionValidityStartDate AS TxDatFron,
  cast ( (ParkedGLItem.AmountInCompanyCodeCurrency) as glo_amount_compcode_crcy ) AS AmountInCompanyCodeCurrency,
  cast ( ParkedGLItem.AmountInTransactionCurrency as glo_amount_trans_crcy ) AS AmountInTransactionCurrency,
  cast ( ( ParkedGLItem.AmountInCompanyCodeCurrency ) as glo_tax_base_amount ) AS TaxBaseAmountInCoCodeCrcy,
  cast ( ( ParkedGLItem.AmountInTransactionCurrency ) as glo_tax_base_amount ) AS TaxBaseAmountInTransCrcy,
  _TaxCust.TaxRate AS TaxRate,
  cast ( ParkedGLItem.AmountInCompanyCodeCurrency as abap.dec( 18, 2 ) ) * _TaxCust.TaxRate AS CalcTaxAmountInCoCodeCrcy,
  round( cast ( ParkedGLItem.AmountInTransactionCurrency as abap.dec( 18, 2 ) ) * _TaxCust.TaxRate, 2) AS CalculatedTaxAmountInTransCurr
FROM I_ParkedDocumentTaxItem AS TaxItem
LEFT OUTER JOIN I_ParkedOplAcctgDocPyblsItem AS _ParkedPayablesItem ON TaxItem.SourceCompanyCode = _ParkedPayablesItem.SourceCompanyCode AND TaxItem.AccountingDocument = _ParkedPayablesItem.SourceAccountingDocument AND TaxItem.FiscalYear = _ParkedPayablesItem.SourceFiscalYear  -- association [0..1]
LEFT OUTER JOIN P_GB_TaxCodeCustomizing AS _TaxCust ON _TaxCust.TaxCode = TaxItem.TaxCode  -- association [0..1]
;

Learn More