I_ACCTDOCCUSTOMER

CDS View

Customer Number for Accounting Document

I_ACCTDOCCUSTOMER is a CDS View in S/4HANA. Customer Number for Accounting Document. It contains 3 fields. 6 CDS views read from this table.

Used by 6 CDS view(s) 3 fields

CDS Views using this table (6)

ViewTypeJoinVDMDescription
C_ID_StRpVATExportCube view inner CONSUMPTION Cube View for ID Exports VAT Report
C_ID_StRpVATImportCube view inner CONSUMPTION Cube View for ID Imports VAT Report
C_ID_StRpVATInb view inner CONSUMPTION Tax Items for ID VAT IN Statutory Report
C_ID_StRpVATOut view inner CONSUMPTION ID VAT OUT Statutory Report view
I_ID_StRpVATReturnInCube view inner COMPOSITE Indonesia VAT Return In - Cube
I_ID_StRpVATReturnOutCube view inner COMPOSITE Indonesia VAT Return Out - Cube

Fields (3)

KeyField CDS FieldsUsed in Views
BusinessPlace BusinessPlace 6
Customer Customer 4
Supplier Supplier 5 
@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":""
}
}*/

Learn More