P_APVendorOpenItems11

DDL: P_APVENDOROPENITEMS11 SQL: PFIAPVNDROPITM11 Type: view COMPOSITE

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

2 data source(s) 13 fields

Data Sources (2)

SourceAliasJoin Type
P_APVendorOpenItems10 DeleteEmpty from
P_APVendorOpenItems0 P_APVendorOpenItems0 inner

Annotations (6)

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

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode P_APVendorOpenItems0 CompanyCode
KEY AccountingDocument P_APVendorOpenItems0 AccountingDocument
KEY FiscalYear P_APVendorOpenItems0 FiscalYear
KEY AccountingDocumentItem P_APVendorOpenItems0 AccountingDocumentItem
Supplier P_APVendorOpenItems0 Supplier
DocumentCurrency P_APVendorOpenItems0 DocumentCurrency
SpecialGLTransactionType P_APVendorOpenItems10 SpecialGLTransactionType
OpenAmount P_APVendorOpenItems10 OpenAmount
OpenAmountelse0endasDownPaymentAmount
OpenAmountendasOtherPaymentAmount
AccountingDocCreatedByUser _AccountingDocumentHeader AccountingDocCreatedByUser
CompanyCodeCurrency P_APVendorOpenItems0 CompanyCodeCurrency
_DocumentCurrency _DocumentCurrency 
//@EndUserText.label: 'Technical view' 

@VDM.private: true
@VDM.viewType: #COMPOSITE
@AbapCatalog.sqlViewName: 'PFIAPVNDROPITM11'
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations: true
define view P_APVendorOpenItems11
as select from
P_APVendorOpenItems10 as DeleteEmpty  
inner join P_APVendorOpenItems0 on
      DeleteEmpty.CompanyCode             = P_APVendorOpenItems0.CompanyCode
  and DeleteEmpty.AccountingDocument      = P_APVendorOpenItems0.AccountingDocument
  and DeleteEmpty.AccountingDocumentItem  = P_APVendorOpenItems0.AccountingDocumentItem
  and DeleteEmpty.FiscalYear              = P_APVendorOpenItems0.FiscalYear
{
  key P_APVendorOpenItems0.CompanyCode,
  key P_APVendorOpenItems0.AccountingDocument,
  key P_APVendorOpenItems0.FiscalYear,
  key P_APVendorOpenItems0.AccountingDocumentItem,
  P_APVendorOpenItems0.Supplier,
  P_APVendorOpenItems0.DocumentCurrency as DocumentCurrency,
  DeleteEmpty.SpecialGLTransactionType,
  DeleteEmpty.OpenAmount,
  case DeleteEmpty.SpecialGLTransactionType
    when 'A' then 
      DeleteEmpty.OpenAmount
    else
      0
  end as DownPaymentAmount,
  case DeleteEmpty.SpecialGLTransactionType
    when 'A' then
      0
    else
      DeleteEmpty.OpenAmount
  end as OtherPaymentAmount,
  _AccountingDocumentHeader.AccountingDocCreatedByUser as AccountingDocCreatedByUser,
  P_APVendorOpenItems0.CompanyCodeCurrency,
  _DocumentCurrency
}
where OpenAmount != 0;                                                               
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_ACCOUNTINGDOCUMENT",
"P_APVENDOROPENITEMS0",
"P_APVENDOROPENITEMS10"
],
"ASSOCIATED":
[
"I_CURRENCY"
],
"BASE":
[
"P_APVENDOROPENITEMS0"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More