P_APVendorOpenItems1

DDL: P_APVENDOROPENITEMS1 SQL: PFIAPVNDROPITM1 Type: view COMPOSITE

P_APVendorOpenItems1 is a Composite CDS View in SAP S/4HANA. It reads from 2 data sources (P_APVendorOpenItems0, I_ReceivablesPayablesItem) and exposes 16 fields with key fields CompanyCode, AccountingDocument, FiscalYear, AccountingDocumentItem.

2 data source(s) 16 fields

Data Sources (2)

SourceAliasJoin Type
P_APVendorOpenItems0 AccountingDocumentItem from
I_ReceivablesPayablesItem GLAcctItems inner

Annotations (6)

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

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode P_APVendorOpenItems0 CompanyCode
KEY AccountingDocument P_APVendorOpenItems0 AccountingDocument
KEY FiscalYear P_APVendorOpenItems0 FiscalYear
KEY AccountingDocumentItem P_APVendorOpenItems0 AccountingDocumentItem
AmountInCompanyCodeCurrency P_APVendorOpenItems0 AmountInCompanyCodeCurrency
AmountInTransactionCurrency P_APVendorOpenItems0 AmountInTransactionCurrency
DocumentCurrency P_APVendorOpenItems0 DocumentCurrency
InvoiceReference P_APVendorOpenItems0 InvoiceReference
InvoiceReferenceFiscalYear P_APVendorOpenItems0 InvoiceReferenceFiscalYear
InvoiceItemReference P_APVendorOpenItems0 InvoiceItemReference
FollowOnDocumentType P_APVendorOpenItems0 FollowOnDocumentType
Supplier P_APVendorOpenItems0 Supplier
SpecialGLTransactionType P_APVendorOpenItems0 SpecialGLTransactionType
CompanyCodeCurrency P_APVendorOpenItems0 CompanyCodeCurrency
_AccountingDocumentHeader _AccountingDocumentHeader
_DocumentCurrency _DocumentCurrency 
//@EndUserText.label: 'Technical view' 

@VDM.private: true
@VDM.viewType: #COMPOSITE
@AbapCatalog.sqlViewName: 'PFIAPVNDROPITM1'
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations: true
define view P_APVendorOpenItems1
as select from
P_APVendorOpenItems0 as AccountingDocumentItem
inner join 
I_ReceivablesPayablesItem as GLAcctItems
on 
    AccountingDocumentItem.CompanyCode          = GLAcctItems.CompanyCode
  and AccountingDocumentItem.AccountingDocument = GLAcctItems.AccountingDocument
  and AccountingDocumentItem.FiscalYear         = GLAcctItems.FiscalYear
{
  key AccountingDocumentItem.CompanyCode,
  key AccountingDocumentItem.AccountingDocument,
  key AccountingDocumentItem.FiscalYear,
  key AccountingDocumentItem.AccountingDocumentItem,
  AccountingDocumentItem.AmountInCompanyCodeCurrency,
  AccountingDocumentItem.AmountInTransactionCurrency, 
  AccountingDocumentItem.DocumentCurrency,
  AccountingDocumentItem.InvoiceReference,
  AccountingDocumentItem.InvoiceReferenceFiscalYear,
  AccountingDocumentItem.InvoiceItemReference,
  AccountingDocumentItem.FollowOnDocumentType,
//  AccountingDocumentItem.DebitCreditCode,

  AccountingDocumentItem.Supplier,
  AccountingDocumentItem.SpecialGLTransactionType,
  AccountingDocumentItem.CompanyCodeCurrency,
  _AccountingDocumentHeader,
  _DocumentCurrency 
}
where (AccountingDocumentItem.ClearingAccountingDocument = '') 
and (AccountingDocumentItem.FinancialAccountType = 'K') 
and ( not AccountingDocumentItem.SpecialGLTransactionType = 'A') 
and (AccountingDocumentItem.AccountingDocumentCategory = '') 
and (AccountingDocumentItem.IsUsedInPaymentTransaction = 'X') 
and ( not AccountingDocumentItem.InvoiceReference = '') 
and ( not (AccountingDocumentItem.FollowOnDocumentType = '' or AccountingDocumentItem.FollowOnDocumentType = 'V')) 
and ( not AccountingDocumentItem.Supplier = '') 
and (GLAcctItems.FinancialAccountType = 'S') 
and ((GLAcctItems.TransactionTypeDetermination = '' or GLAcctItems.TransactionTypeDetermination = 'ZAH')) 
and (GLAcctItems.AccountingDocumentCategory = '')
;                                                                   
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_RECEIVABLESPAYABLESITEM",
"P_APVENDOROPENITEMS0"
],
"ASSOCIATED":
[
"I_ACCOUNTINGDOCUMENT",
"I_CURRENCY"
],
"BASE":
[
"P_APVENDOROPENITEMS0"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More