P_ARLineItemMixedAccount

DDL: P_ARLINEITEMMIXEDACCOUNT SQL: PARITEMMIXEDACCT Type: view BASIC
43 Fields 2 Data Sources

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.

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 Sold-to Party
KEY CompanyCode I_CustomerCompany CompanyCode Receiver Company Code
Supplier I_Customer Supplier Supplier
AccountingClerk I_CustomerCompany AccountingClerk Clerk Abbrev.
ReconciliationAccount I_CustomerCompany ReconciliationAccount Recon. account
InterestCalculationCode I_CustomerCompany InterestCalculationCode Interest Indic.
CustomerHeadOffice I_CustomerCompany CustomerHeadOffice Head Office
AlternativePayerAccount I_CustomerCompany AlternativePayerAccount Alternat.payer
PaymentBlockingReason I_CustomerCompany PaymentBlockingReason Pmnt block
InterestCalculationDate I_CustomerCompany InterestCalculationDate Last Key Date
IntrstCalcFrequencyInMonths I_CustomerCompany IntrstCalcFrequencyInMonths Int.Calc.Freq.
APARToleranceGroup I_CustomerCompany APARToleranceGroup Tolerance Group
ItemIsToBePaidSeparately I_CustomerCompany ItemIsToBePaidSeparately Individual Payt
PaytAdviceIsSentbyEDI I_CustomerCompany PaytAdviceIsSentbyEDI Pmt adv. by EDI
CustomerAccountNote I_CustomerCompany CustomerAccountNote Account Memo
CustomerFinsAuthorizationGrp I_CustomerCompany AuthorizationGroup AuthorizGroup
CustomerBasicAuthorizationGrp I_Customer AuthorizationGroup AuthorizGroup
CustomerName I_Customer CustomerName Name of Customer
CreatedByUser I_Customer CreatedByUser User Name
CreationDate I_Customer CreationDate Time Stamp
CustomerAccountGroup I_Customer CustomerAccountGroup Account group
VATRegistration I_Customer VATRegistration VAT Registration No.
Industry I_Customer Industry Industry Sector
DeliveryIsBlocked I_Customer DeliveryIsBlocked Delivery block
PostingIsBlocked I_Customer PostingIsBlocked Posting Block
CustomerCorporateGroup I_Customer CustomerCorporateGroup Group
TaxNumber1 I_Customer TaxNumber1 VAT Reg. No.
TaxNumber2 I_Customer TaxNumber2 Tax Number 2
TaxNumber3 I_Customer TaxNumber3
TaxNumber4 I_Customer TaxNumber4
TaxNumber5 I_Customer TaxNumber5
TaxJurisdiction I_Customer TaxJurisdiction Tax Jurisdiction
IsOneTimeAccount I_Customer IsOneTimeAccount One-time acct
SortField I_Customer SortField Sort Field
Country
CityName
POBox
POBoxPostalCode
PostalCode
Region
CityCode
County
AlternativePayerIsAllowed Debtor xzemp Payee in doc.

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view P_ARLineItemMixedAccount.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: PARITEMMIXEDACCT

CREATE VIEW P_ARLineItemMixedAccount AS
SELECT
  I_CustomerCompany.Customer AS Customer,
  I_CustomerCompany.CompanyCode AS CompanyCode,
  Customer.Supplier AS Supplier,
  I_CustomerCompany.AccountingClerk AS AccountingClerk,
  I_CustomerCompany.ReconciliationAccount AS ReconciliationAccount,
  I_CustomerCompany.InterestCalculationCode AS InterestCalculationCode,
  I_CustomerCompany.CustomerHeadOffice AS CustomerHeadOffice,
  I_CustomerCompany.AlternativePayerAccount AS AlternativePayerAccount,
  I_CustomerCompany.PaymentBlockingReason AS PaymentBlockingReason,
  I_CustomerCompany.InterestCalculationDate AS InterestCalculationDate,
  I_CustomerCompany.IntrstCalcFrequencyInMonths AS IntrstCalcFrequencyInMonths,
  I_CustomerCompany.APARToleranceGroup AS APARToleranceGroup,
  I_CustomerCompany.ItemIsToBePaidSeparately AS ItemIsToBePaidSeparately,
  I_CustomerCompany.PaytAdviceIsSentbyEDI AS PaytAdviceIsSentbyEDI,
  I_CustomerCompany.CustomerAccountNote AS CustomerAccountNote,
  I_CustomerCompany.AuthorizationGroup AS CustomerFinsAuthorizationGrp,
  Customer.AuthorizationGroup AS CustomerBasicAuthorizationGrp,
  Customer.CustomerName AS CustomerName,
  Customer.CreatedByUser AS CreatedByUser,
  Customer.CreationDate AS CreationDate,
  Customer.CustomerAccountGroup AS CustomerAccountGroup,
  Customer.VATRegistration AS VATRegistration,
  Customer.Industry AS Industry,
  Customer.DeliveryIsBlocked AS DeliveryIsBlocked,
  Customer.PostingIsBlocked AS PostingIsBlocked,
  Customer.CustomerCorporateGroup AS CustomerCorporateGroup,
  Customer.TaxNumber1 AS TaxNumber1,
  Customer.TaxNumber2 AS TaxNumber2,
  Customer.TaxNumber3 AS TaxNumber3,
  Customer.TaxNumber4 AS TaxNumber4,
  Customer.TaxNumber5 AS TaxNumber5,
  Customer.TaxJurisdiction AS TaxJurisdiction,
  Customer.IsOneTimeAccount AS IsOneTimeAccount,
  Customer.SortField AS SortField,
  Customer._StandardAddress.Country AS Country,
  Customer._StandardAddress.CityName AS CityName,
  Customer._StandardAddress.POBox AS POBox,
  Customer._StandardAddress.POBoxPostalCode AS POBoxPostalCode,
  Customer._StandardAddress.PostalCode AS PostalCode,
  Customer._StandardAddress.Region AS Region,
  Customer._StandardAddress.CityCode AS CityCode,
  Customer._StandardAddress.County AS County,
  Debtor.xzemp AS AlternativePayerIsAllowed
FROM I_CustomerCompany
INNER JOIN I_Customer AS Customer ON /* join condition not captured in parsed metadata */
;

Learn More