P_ARLineItemMixedAccount

DDL: P_ARLINEITEMMIXEDACCOUNT SQL: PARITEMMIXEDACCT Type: view BASIC

P_ARLineItemMixedAccount is a Basic CDS View in SAP S/4HANA. It reads from 2 data sources (I_Customer, I_CustomerCompany) and exposes 43 fields with key fields Customer, CompanyCode.

2 data source(s) 43 fields

Data Sources (2)

SourceAliasJoin Type
I_Customer Customer inner
I_CustomerCompany I_CustomerCompany from

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName PARITEMMIXEDACCT view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #BASIC view
VDM.private true view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (43)

KeyFieldSource TableSource FieldDescription
KEY Customer I_CustomerCompany Customer
KEY CompanyCode I_CustomerCompany CompanyCode
Supplier I_Customer Supplier
AccountingClerk I_CustomerCompany AccountingClerk
ReconciliationAccount I_CustomerCompany ReconciliationAccount
InterestCalculationCode I_CustomerCompany InterestCalculationCode
CustomerHeadOffice I_CustomerCompany CustomerHeadOffice
AlternativePayerAccount I_CustomerCompany AlternativePayerAccount
PaymentBlockingReason I_CustomerCompany PaymentBlockingReason
InterestCalculationDate I_CustomerCompany InterestCalculationDate
IntrstCalcFrequencyInMonths I_CustomerCompany IntrstCalcFrequencyInMonths
APARToleranceGroup I_CustomerCompany APARToleranceGroup
ItemIsToBePaidSeparately I_CustomerCompany ItemIsToBePaidSeparately
PaytAdviceIsSentbyEDI I_CustomerCompany PaytAdviceIsSentbyEDI
CustomerAccountNote I_CustomerCompany CustomerAccountNote
CustomerFinsAuthorizationGrp I_CustomerCompany AuthorizationGroup
CustomerBasicAuthorizationGrp I_Customer AuthorizationGroup
CustomerName I_Customer CustomerName
CreatedByUser I_Customer CreatedByUser
CreationDate I_Customer CreationDate
CustomerAccountGroup I_Customer CustomerAccountGroup
VATRegistration I_Customer VATRegistration
Industry I_Customer Industry
DeliveryIsBlocked I_Customer DeliveryIsBlocked
PostingIsBlocked I_Customer PostingIsBlocked
CustomerCorporateGroup I_Customer CustomerCorporateGroup
TaxNumber1 I_Customer TaxNumber1
TaxNumber2 I_Customer TaxNumber2
TaxNumber3 I_Customer TaxNumber3
TaxNumber4 I_Customer TaxNumber4
TaxNumber5 I_Customer TaxNumber5
TaxJurisdiction I_Customer TaxJurisdiction
IsOneTimeAccount I_Customer IsOneTimeAccount
SortField I_Customer SortField
Country
CityName
POBox
POBoxPostalCode
PostalCode
Region
CityCode
County
AlternativePayerIsAllowed Debtor xzemp 
@AbapCatalog.sqlViewName: 'PARITEMMIXEDACCT'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@VDM.viewType: #BASIC
@VDM.private:true
@ClientHandling.algorithm: #SESSION_VARIABLE

define view P_ARLineItemMixedAccount as select from I_CustomerCompany 
  
  inner join I_Customer as Customer on     I_CustomerCompany.Customer = Customer.Customer
                                       and Customer.Supplier         != ''
                                       
  //KNA1 needed because field AlternativePayerIsAllowed is not offered by I_Customer

  left outer to one join kna1 as Debtor on Customer.Customer = Debtor.kunnr 
                                                     
{  
  key I_CustomerCompany.Customer, 
  key I_CustomerCompany.CompanyCode,
  Customer.Supplier,
   
  I_CustomerCompany.AccountingClerk, 
  I_CustomerCompany.ReconciliationAccount, 
  I_CustomerCompany.InterestCalculationCode, 
  I_CustomerCompany.CustomerHeadOffice, 
  I_CustomerCompany.AlternativePayerAccount, 
  I_CustomerCompany.PaymentBlockingReason, 
  I_CustomerCompany.InterestCalculationDate, 
  I_CustomerCompany.IntrstCalcFrequencyInMonths, 
  I_CustomerCompany.APARToleranceGroup, 
  I_CustomerCompany.ItemIsToBePaidSeparately, 
  I_CustomerCompany.PaytAdviceIsSentbyEDI, 
  I_CustomerCompany.CustomerAccountNote, 
  I_CustomerCompany.AuthorizationGroup            as CustomerFinsAuthorizationGrp,
  
  Customer.AuthorizationGroup                     as CustomerBasicAuthorizationGrp, 
  Customer.CustomerName, 
  Customer.CreatedByUser, 
  Customer.CreationDate, 
  Customer.CustomerAccountGroup, 
  Customer.VATRegistration, 
  Customer.Industry, 
  Customer.DeliveryIsBlocked, 
  Customer.PostingIsBlocked, 
  Customer.CustomerCorporateGroup, 
  Customer.TaxNumber1, 
  Customer.TaxNumber2, 
  Customer.TaxNumber3, 
  Customer.TaxNumber4, 
  Customer.TaxNumber5, 
  Customer.TaxJurisdiction, 
  Customer.IsOneTimeAccount, 
  Customer.SortField, 
  Customer._StandardAddress.Country, 
  Customer._StandardAddress.CityName, 
  Customer._StandardAddress.POBox, 
  Customer._StandardAddress.POBoxPostalCode, 
  Customer._StandardAddress.PostalCode, 
  Customer._StandardAddress.Region, 
  Customer._StandardAddress.CityCode, 
  Customer._StandardAddress.County,
  
  Debtor.xzemp                                    as AlternativePayerIsAllowed
}

/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_ADDRESS",
"I_CUSTOMER",
"I_CUSTOMERCOMPANY",
"KNA1"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More