P_ARLineItem_4

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_ARLineItem_4.
-- 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.
-- Parameters: P_DisputeCaseAccessIsGranted : boole_d

CREATE VIEW P_ARLineItem_4 AS
SELECT
  P_ARLineItem_9.CompanyCode AS CompanyCode,
  P_ARLineItem_9.AccountingDocument AS AccountingDocument,
  P_ARLineItem_9.FiscalYear AS FiscalYear,
  P_ARLineItem_9.AccountingDocumentItem AS AccountingDocumentItem,
  P_ARLineItem_9._JournalEntry.AccountingDocCreatedByUser AS AccountingDocCreatedByUser,
  P_ARLineItem_9.AccountingDocumentCategory AS AccountingDocumentCategory,
  P_ARLineItem_9._JournalEntry.AccountingDocumentCreationDate AS AccountingDocumentCreationDate,
  P_ARLineItem_9.AccountingDocumentType AS AccountingDocumentType,
  P_ARLineItem_9.AccountsReceivableIsPledged AS AccountsReceivableIsPledged,
  P_ARLineItem_9.AdditionalCurrency1 AS AdditionalCurrency1,
  P_ARLineItem_9.AdditionalCurrency2 AS AdditionalCurrency2,
  P_ARLineItem_9.AlternativeGLAccount AS AlternativeGLAccount,
  P_ARLineItem_9.AmountInAdditionalCurrency1 AS AmountInAdditionalCurrency1,
  P_ARLineItem_9.AmountInAdditionalCurrency2 AS AmountInAdditionalCurrency2,
  P_ARLineItem_9.AmountInBalanceTransacCrcy AS AmountInBalanceTransacCrcy,
  P_ARLineItem_9.AmountInCompanyCodeCurrency AS AmountInCompanyCodeCurrency,
  P_ARLineItem_9.AmountInFunctionalCurrency AS AmountInFunctionalCurrency,
  P_ARLineItem_9.AmountInPaymentCurrency AS AmountInPaymentCurrency,
  P_ARLineItem_9.AmountInTransactionCurrency AS AmountInTransactionCurrency,
  P_ARLineItem_9.AssetContract AS AssetContract,
  P_ARLineItem_9.AssignmentReference AS AssignmentReference,
  P_ARLineItem_9.BalanceTransactionCurrency AS BalanceTransactionCurrency,
  P_ARLineItem_9.BillingDocument AS BillingDocument,
  P_ARLineItem_9.BillOfExchangeUsage AS BillOfExchangeUsage,
  P_ARLineItem_9.Branch AS Branch,
  P_ARLineItem_9.BusinessArea AS BusinessArea,
  P_ARLineItem_9.BusinessPlace AS BusinessPlace,
  P_ARLineItem_9.CashDiscount1Days AS CashDiscount1Days,
  P_ARLineItem_9.CashDiscount1DueDate AS CashDiscount1DueDate,
  P_ARLineItem_9.CashDiscount1Percent AS CashDiscount1Percent,
  P_ARLineItem_9.CashDiscount2Days AS CashDiscount2Days,
  P_ARLineItem_9.CashDiscount2Percent AS CashDiscount2Percent,
  P_ARLineItem_9.CashDiscountAmount AS CashDiscountAmount,
  P_ARLineItem_9.CashDiscountAmtInCoCodeCrcy AS CashDiscountAmtInCoCodeCrcy,
  P_ARLineItem_9.CashDiscountBaseAmount AS CashDiscountBaseAmount,
  P_ARLineItem_9.CashFlowType AS CashFlowType,
  P_ARLineItem_9.ClearingAccountingDocument AS ClearingAccountingDocument,
  P_ARLineItem_9.ClearingDate AS ClearingDate,
  P_ARLineItem_9.ClearingDocFiscalYear AS ClearingDocFiscalYear,
  P_ARLineItem_9.ClearingIsReversed AS ClearingIsReversed,
  P_ARLineItem_9.CompanyCodeCurrency AS CompanyCodeCurrency,
  P_ARLineItem_9.CostCenter AS CostCenter,
  P_ARLineItem_9.CreditControlArea AS CreditControlArea,
  P_ARLineItem_9.ReceivableAlternativePayer AS ReceivableAlternativePayer,
  P_ARLineItem_9.DataExchangeInstruction1 AS DataExchangeInstruction1,
  P_ARLineItem_9.DataExchangeInstruction2 AS DataExchangeInstruction2,
  P_ARLineItem_9.DataExchangeInstruction3 AS DataExchangeInstruction3,
  P_ARLineItem_9.DataExchangeInstruction4 AS DataExchangeInstruction4,
  P_ARLineItem_9.DebitCreditCode AS DebitCreditCode,
  P_ARLineItem_9.Debtor AS Debtor,
  P_ARLineItem_9.DocumentDate AS DocumentDate,
  ' ' AS DocumentIsArchived,
  P_ARLineItem_9.DocumentItemText AS DocumentItemText,
  P_ARLineItem_9._JournalEntry.DocumentReferenceID AS DocumentReferenceID,
  P_ARLineItem_9.DueCalculationBaseDate AS DueCalculationBaseDate,
  P_ARLineItem_9.DunningArea AS DunningArea,
  P_ARLineItem_9.DunningBlockingReason AS DunningBlockingReason,
  P_ARLineItem_9.DunningLevel AS DunningLevel,
  P_ARLineItem_9.FinancialAccountType AS FinancialAccountType,
  P_ARLineItem_9.FiscalPeriod AS FiscalPeriod,
  P_ARLineItem_9.FixedAsset AS FixedAsset,
  P_ARLineItem_9.FixedCashDiscount AS FixedCashDiscount,
  P_ARLineItem_9.FollowOnDocumentType AS FollowOnDocumentType,
  P_ARLineItem_9.StateCentralBankPaymentReason AS StateCentralBankPaymentReason,
  P_ARLineItem_9.SupplyingCountry AS SupplyingCountry,
  P_ARLineItem_9.FunctionalCurrency AS FunctionalCurrency,
  P_ARLineItem_9.FundsCenter AS FundsCenter,
  P_ARLineItem_9.GLAccount AS GLAccount,
  P_ARLineItem_9.HasPaymentOrder AS HasPaymentOrder,
  P_ARLineItem_9.HedgedAmount AS HedgedAmount,
  P_ARLineItem_9.HouseBankAccount AS HouseBankAccount,
  P_ARLineItem_9.InvoiceList AS InvoiceList,
  P_ARLineItem_9.InvoiceReference AS InvoiceReference,
  P_ARLineItem_9.IsSalesRelated AS IsSalesRelated,
  P_ARLineItem_9.IsUsedInPaymentTransaction AS IsUsedInPaymentTransaction,
  cast ( 'BSEG_DEBIT_SIDE_BRANCH' as char30 ) AS ITEM_TYPE_BRANCH,
  P_ARLineItem_9.LastDunningDate AS LastDunningDate,
  P_ARLineItem_9.MasterFixedAsset AS MasterFixedAsset,
  P_ARLineItem_9.DunningKey AS DunningKey,
  P_ARLineItem_9.NetDueDate AS NetDueDate,
  P_ARLineItem_9.NetPaymentDays AS NetPaymentDays,
  P_ARLineItem_9.OffsettingAccount AS OffsettingAccount,
  P_ARLineItem_9.OffsettingAccountType AS OffsettingAccountType,
  P_ARLineItem_9.OrderID AS OrderID,
  P_ARLineItem_9.PartnerCompany AS PartnerCompany,
  P_ARLineItem_9.PaymentBlockingReason AS PaymentBlockingReason,
  P_ARLineItem_9.PaymentCardItem AS PaymentCardItem,
  P_ARLineItem_9.PaymentCardPaymentSettlement AS PaymentCardPaymentSettlement,
  P_ARLineItem_9.PaymentCurrency AS PaymentCurrency,
  P_ARLineItem_9.PaymentDifferenceReason AS PaymentDifferenceReason,
  P_ARLineItem_9.PaymentMethod AS PaymentMethod,
  P_ARLineItem_9.PaymentMethodSupplement AS PaymentMethodSupplement,
  P_ARLineItem_9.PaymentReference AS PaymentReference,
  P_ARLineItem_9.PaymentTerms AS PaymentTerms,
  P_ARLineItem_9.PlannedAmtInTransactionCrcy AS PlannedAmtInTransactionCrcy,
  P_ARLineItem_9.Plant AS Plant,
  P_ARLineItem_9.PostingDate AS PostingDate,
  P_ARLineItem_9.PostingKey AS PostingKey,
  P_ARLineItem_9.ProfitCenter AS ProfitCenter,
  P_ARLineItem_9.PurchasingDocument AS PurchasingDocument,
  P_ARLineItem_9.PurchasingDocumentItem AS PurchasingDocumentItem,
  P_ARLineItem_9.RealEstateObject AS RealEstateObject,
  P_ARLineItem_9.Reference1IDByBusinessPartner AS Reference1IDByBusinessPartner,
  P_ARLineItem_9.Reference2IDByBusinessPartner AS Reference2IDByBusinessPartner,
  P_ARLineItem_9.Reference3IDByBusinessPartner AS Reference3IDByBusinessPartner,
  P_ARLineItem_9.SalesDocument AS SalesDocument,
  P_ARLineItem_9.SalesDocumentItem AS SalesDocumentItem,
  P_ARLineItem_9.ScheduleLine AS ScheduleLine,
  P_ARLineItem_9.SettlementReferenceDate AS SettlementReferenceDate,
  '' AS SourceCompanyCode,
  P_ARLineItem_9.SpecialGLCode AS SpecialGLCode,
  P_ARLineItem_9.SpecialGLTransactionType AS SpecialGLTransactionType,
  _BsetTax.TaxAmountInCoCodeCrcy AS TaxAmountInCoCodeCrcy,
  _BsetBase.TaxBaseAmountInCoCodeCrcy AS TaxBaseAmountInCoCodeCrcy,
  P_ARLineItem_9._CompanyCode._Country.TaxCalculationProcedure AS TaxCalculationProcedure,
  P_ARLineItem_9.TaxCode AS TaxCode,
  P_ARLineItem_9.TaxCountry AS TaxCountry,
  P_ARLineItem_9._JournalEntry.TaxReportingDate AS TaxReportingDate,
  P_ARLineItem_9.TaxSection AS TaxSection,
  P_ARLineItem_9.TransactionCurrency AS TransactionCurrency,
  P_ARLineItem_9.TreasuryContractType AS TreasuryContractType,
  P_ARLineItem_9.ValuationDiffAmtInAddlCrcy1 AS ValuationDiffAmtInAddlCrcy1,
  P_ARLineItem_9.ValuationDiffAmtInAddlCrcy2 AS ValuationDiffAmtInAddlCrcy2,
  P_ARLineItem_9.ValuationDiffAmtInCoCodeCrcy AS ValuationDiffAmtInCoCodeCrcy,
  P_ARLineItem_9.ValueDate AS ValueDate,
  P_ARLineItem_9.WBSElement AS WBSElement,
  P_ARLineItem_9.WithholdingTaxAmount AS WithholdingTaxAmount,
  P_ARLineItem_9.WithholdingTaxBaseAmount AS WithholdingTaxBaseAmount,
  P_ARLineItem_9.WithholdingTaxExemptionAmt AS WithholdingTaxExemptionAmt,
  P_ARLineItem_9.BPBankAccountInternalID AS BPBankAccountInternalID,
  P_ARLineItem_9.ReceivableFinancingStatus AS ReceivableFinancingStatus,
  P_ARLineItem_9.HouseBank AS HouseBank,
  _CaseAttribute.CaseID AS CaseID,
  _CaseAttribute.DisputeCasePriority AS DisputeCasePriority,
  _CaseAttribute.DisputeCasePriorityName AS DisputeCasePriorityName,
  _CaseAttribute.DisputeCaseTitle AS DisputeCaseTitle,
  _CaseAttribute.DisputeCaseReason AS DisputeCaseReason,
  _CaseAttribute.DisputeCaseReasonName AS DisputeCaseReasonName,
  _CaseAttribute.DisputeCaseStatus AS DisputeCaseStatus,
  _CaseAttribute.DisputeCaseStatusName AS DisputeCaseStatusName,
  _CaseAttribute.DisputeCaseProcessor AS DisputeCaseProcessor,
  _CaseAttribute.DisputeCaseProcessorFullName AS DisputeCaseProcessorFullName,
  _CaseAttribute.DisputeCaseUUID AS DisputeCaseUUID,
  P_ARLineItem_9.Creditor AS Creditor,
  cast( P_ARLineItem_9._JournalEntry.AdditionalCurrency1Role as fis_adl1_currole preserving type ) AS AdditionalCurrency1Role,
  cast( P_ARLineItem_9._JournalEntry.AdditionalCurrency2Role as fis_adl2_currole preserving type ) AS AdditionalCurrency2Role,
  P_ARLineItem_9.BranchCode AS BranchCode,
  P_ARLineItem_9.ReferenceDocumentType AS ReferenceDocumentType,
  P_ARLineItem_9.OriginalReferenceDocument AS OriginalReferenceDocument,
  P_ARLineItem_9.ReferenceDocumentLogicalSystem AS ReferenceDocumentLogicalSystem,
  P_ARLineItem_9.BillOfExchangeUsageDocument AS BillOfExchangeUsageDocument,
  P_ARLineItem_9.BOEUsageDocFiscalYear AS BOEUsageDocFiscalYear,
  P_ARLineItem_9.BOEUsageDocLineItem AS BOEUsageDocLineItem,
  P_ARLineItem_9.JointVenture AS JointVenture,
  P_ARLineItem_9.JointVentureCostRecoveryCode AS JointVentureCostRecoveryCode,
  P_ARLineItem_9.JointVentureBillingType AS JointVentureBillingType,
  P_ARLineItem_9.JointVentureCorporateEquityGrp as JointVentureCorporateEquityGrp AS CompanyCodeasCompanyCode,
  ' ' AS JointVentureCorporateEquityGrp
FROM P_ARLineItem_9
INNER JOIN far_mult_mix_acc AS MixAcc1 ON /* join condition not captured in parsed metadata */
INNER JOIN far_mult_mix_acc AS MixAcc2 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_ARLineItem_Base_Bset AS _BsetBase ON CompanyCode = _BsetBase.CompanyCode AND AccountingDocument = _BsetBase.AccountingDocument AND FiscalYear = _BsetBase.FiscalYear  -- association [0..1]
LEFT OUTER JOIN P_ARLineItem_Sum_Bset AS _BsetTax ON CompanyCode = _BsetTax.CompanyCode AND AccountingDocument = _BsetTax.AccountingDocument AND FiscalYear = _BsetTax.FiscalYear  -- association [0..1]
-- UNION ALL with additional select branch(es): I_ReceivablesPayablesItem, I_ParkedOplAcctgDocRblsItem, I_ParkedOplAcctgDocPyblsItem, P_ARLineItem_7, P_ARLineItem_8
;