P_APLineItemMixedAccount

DDL: P_APLINEITEMMIXEDACCOUNT SQL: PAPITEMMIXEDACCT Type: view BASIC

P_APLineItemMixedAccount is a Basic CDS View in SAP S/4HANA. It reads from 2 data sources (I_SupplierCompany, I_Supplier) and exposes 40 fields with key fields Creditor, CompanyCode.

2 data source(s) 40 fields

Data Sources (2)

SourceAliasJoin Type
I_SupplierCompany I_SupplierCompany from
I_Supplier Supplier inner

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName PAPITEMMIXEDACCT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #MANDATORY view
VDM.viewType #BASIC view
VDM.private true view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (40)

KeyFieldSource TableSource FieldDescription
KEY Creditor I_SupplierCompany Supplier
KEY CompanyCode I_SupplierCompany CompanyCode
Debtor I_Supplier Customer
SupplierName I_Supplier SupplierName
Industry I_Supplier Industry
CreationDate I_Supplier CreationDate
CreatedByUser I_Supplier CreatedByUser
SupplierCorporateGroup I_Supplier SupplierCorporateGroup
SupplierAccountGroup I_Supplier SupplierAccountGroup
AccountIsBlockedForPosting I_Supplier PostingIsBlocked
TaxNumber1 I_Supplier TaxNumber1
TaxNumber2 I_Supplier TaxNumber2
TaxNumber3 I_Supplier TaxNumber3
TaxNumber4 I_Supplier TaxNumber4
TaxNumber5 I_Supplier TaxNumber5
IsOneTimeAccount I_Supplier IsOneTimeAccount
VATRegistration I_Supplier VATRegistration
TaxJurisdiction I_Supplier TaxJurisdiction
Country
CityName
POBox
POBoxPostalCode
PostalCode
Region
AccountingClerk I_SupplierCompany AccountingClerk
ReconciliationAccount I_SupplierCompany ReconciliationAccount
InterestCalculationCode I_SupplierCompany InterestCalculationCode
SupplierHeadOffice I_SupplierCompany SupplierHeadOffice
AlternativePayee I_SupplierCompany AlternativePayee
PaymentBlockingReason I_SupplierCompany PaymentBlockingReason
InterestCalculationDate I_SupplierCompany InterestCalculationDate
IntrstCalcFrequencyInMonths I_SupplierCompany IntrstCalcFrequencyInMonths
APARToleranceGroup I_SupplierCompany APARToleranceGroup
ItemIsToBePaidSeparately I_SupplierCompany ItemIsToBePaidSeparately
PaymentIsToBeSentByEDI I_SupplierCompany PaymentIsToBeSentByEDI
SupplierAccountNote I_SupplierCompany SupplierAccountNote
SupplierFinsAuthorizationGrp I_SupplierCompany AuthorizationGroup
SupplierBasicAuthorizationGrp I_Supplier AuthorizationGroup
SortField I_Supplier SortField
AlternativePayeeIsAllowed Creditor xzemp 
@AbapCatalog.sqlViewName: 'PAPITEMMIXEDACCT'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey:true
@AccessControl.authorizationCheck: #MANDATORY
@VDM.viewType: #BASIC
@VDM.private:true
@ClientHandling.algorithm: #SESSION_VARIABLE

define view P_APLineItemMixedAccount as select from I_SupplierCompany
  
  inner join I_Supplier as Supplier on     I_SupplierCompany.Supplier = Supplier.Supplier
                                       and Supplier.Customer         != ''
                                       
  //LFA1 needed because field AlternativePayerIsAllowed is not offered by I_Supplier

  left outer to one join lfa1 as Creditor on Supplier.Supplier = Creditor.lifnr 

{
      key I_SupplierCompany.Supplier                                                          as Creditor,
      key I_SupplierCompany.CompanyCode,
      Supplier.Customer                                                                       as Debtor,
      
      Supplier.SupplierName,                                                                   
      Supplier.Industry,                                                                      
      Supplier.CreationDate,                                                                   
      Supplier.CreatedByUser,                                                                  
      Supplier.SupplierCorporateGroup,
      Supplier.SupplierAccountGroup,                                                           
      Supplier.PostingIsBlocked                                                               as AccountIsBlockedForPosting,
      Supplier.TaxNumber1,                                                                    
      Supplier.TaxNumber2,                                                                    
      Supplier.TaxNumber3,                                                                   
      Supplier.TaxNumber4,                                                                     
      Supplier.TaxNumber5,                                                                     
      Supplier.IsOneTimeAccount,                                                              
      Supplier.VATRegistration,                                                              
      Supplier.TaxJurisdiction,                                                               

      Supplier._StandardAddress.Country,                                                       
      Supplier._StandardAddress.CityName,                                                      
      Supplier._StandardAddress.POBox,                                                         
      Supplier._StandardAddress.POBoxPostalCode,                                               
      Supplier._StandardAddress.PostalCode,                                                    
      Supplier._StandardAddress.Region,                                                        

      I_SupplierCompany.AccountingClerk,
      I_SupplierCompany.ReconciliationAccount,
      I_SupplierCompany.InterestCalculationCode,
      I_SupplierCompany.SupplierHeadOffice,
      I_SupplierCompany.AlternativePayee,
      I_SupplierCompany.PaymentBlockingReason,                                                 
      I_SupplierCompany.InterestCalculationDate,
      I_SupplierCompany.IntrstCalcFrequencyInMonths,
      I_SupplierCompany.APARToleranceGroup,
      I_SupplierCompany.ItemIsToBePaidSeparately,
      I_SupplierCompany.PaymentIsToBeSentByEDI,
      I_SupplierCompany.SupplierAccountNote,
      I_SupplierCompany.AuthorizationGroup                                                    as SupplierFinsAuthorizationGrp,
      Supplier.AuthorizationGroup                                                             as SupplierBasicAuthorizationGrp,
      Supplier.SortField,
      
      Creditor.xzemp                                                                         as AlternativePayeeIsAllowed
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_ADDRESS",
"I_SUPPLIER",
"I_SUPPLIERCOMPANY",
"LFA1"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More