I_AcctDocCustomer

@AbapCatalog.sqlViewName: 'IACCTDOCCUST'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@VDM.viewType: #COMPOSITE
@AbapCatalog.preserveKey: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.dataClass: #MIXED
@AccessControl.personalData.blocking: #NOT_REQUIRED
@EndUserText.label: 'Customer Number for Accounting Document'
define view I_AcctDocCustomer
  as select from I_OperationalAcctgDocItem
{
  key CompanyCode,
  key FiscalYear,
  key AccountingDocument,
      max(case when Customer is not null then Customer else '' end) as Customer,
      max(case when Supplier is not null then Supplier else '' end) as Supplier,
      max(case when BusinessPlace is not null then BusinessPlace else '' end) as BusinessPlace,
      max(case when BillingDocument is not null then BillingDocument else '' end) as BillingDocument,
      max(case when SpecialGLCode is not null then SpecialGLCode  else '' end) as SpecialGLCode,
      max(case when IsNegativePosting is not null then IsNegativePosting else '' end) as IsNegativePosting
}

group by
  CompanyCode,
  FiscalYear,
  AccountingDocument
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_OPERATIONALACCTGDOCITEM"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/