FAC_DART_Z3_AR_LINEITEM

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 FAC_DART_Z3_AR_LINEITEM.
-- 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: FAC_DZARLNITM
-- Parameters: P_Ledger : fins_ledger, P_FiscalYear : fins_gjahr, P_FromFiscalPeriod : fins_fagl_fiscper_from, P_ToFiscalPeriod : fins_fagl_fiscper_to, P_Language : sylangu

CREATE VIEW FAC_DART_Z3_AR_LINEITEM AS
SELECT
  Base.CompanyCode AS CompanyCode,
  Base.AccountingDocument AS AccountingDocument,
  Base.FiscalYear AS FiscalYear,
  AccountingDocumentItem,
  $session.client AS SystemClient,
  FinancialAccountType,
  Supplier,
  Customer,
  SpecialGLCode,
  AssignmentReference,
  PostingDate,
  DocumentDate,
  AccountingDocumentCreationDate,
  TransactionCurrency,
  DocumentReferenceID,
  AccountingDocumentType,
  FiscalPeriod,
  PostingKey,
  Base.DebitCreditCode AS DebitCreditCode,
  BusinessArea,
  Base.TaxCode AS TaxCode,
  AmountInCompanyCodeCurrency,
  AmountInTransactionCurrency,
  Base.TaxAmountInCoCodeCrcy AS TaxAmountInCoCodeCrcy,
  Base.TaxAmount AS TaxAmount,
  DocumentItemText,
  OrderID,
  PurchasingDocument,
  PurchasingDocumentItem,
  OperationalGLAccount,
  Base.GLAccount AS GLAccount,
  BranchAccount,
  DueCalculationBaseDate,
  PaymentTerms,
  CashDiscount1Days,
  CashDiscount2Days,
  NetPaymentDays,
  CashDiscount1Percent,
  CashDiscount2Percent,
  FixedCashDiscount,
  CashDiscountAmtInCoCodeCrcy,
  CashDiscountAmount,
  PaymentMethod,
  HouseBank,
  InvoiceReference,
  InvoiceReferenceFiscalYear,
  InvoiceItemReference,
  Base.SupplyingCountry AS SupplyingCountry,
  NetAmountIsPosted,
  DownPaymentIsNetProcedure,
  AddressAndBankIsSetManually,
  PaytSlipWthRefSubscriber,
  PaytSlipWthRefReference,
  PaytSlipWthRefCheckDigit,
  IsUsedInPaymentTransaction,
  TaxDistributionCode1,
  TaxDistributionCode2,
  TaxDistributionCode3,
  TaxBrkdwnAmount1InCoCodeCrcy,
  TaxBrkdwnAmount2InCoCodeCrcy,
  TaxBrkdwnAmount3InCoCodeCrcy,
  TaxBrkdwnAmount1InTransCrcy,
  TaxBrkdwnAmount2InTransCrcy,
  TaxBrkdwnAmount3InTransCrcy,
  WithholdingTaxCode,
  WithholdingTaxBaseAmount,
  WithholdingTaxAmount,
  PartnerCompany,
  FollowOnDocumentType,
  Base.VATRegistration AS VATRegistration,
  DelivOfGoodsDestCountry,
  WithholdingTaxCertificate,
  WithholdingTaxExemptionAmt,
  WBSElementInternalID,
  IsEUTriangularDeal,
  CostCenter,
  AlternativePayeePayer,
  ProfitCenter,
  PaymentReference,
  PaymentCurrency,
  AmountInPaymentCurrency,
  TaxSection,
  FunctionalArea,
  BillingDocument,
  SalesDocument,
  SalesDocumentItem,
  ValueDate,
  PaymentMethodSupplement,
  I_LedgerCompanyCodeCrcyRoles.FiscalYearVariant AS FiscalYearVariant,
  ReconciliationAccount,
  Base.CompanyCodeCurrency AS DebitCompanyCodeCurrency,
  Base.CompanyCodeCurrency AS CreditCompanyCodeCurrency,
  Base.ChartOfAccounts AS ChartOfAccounts,
  OriginalReferenceDocument,
  TransactionCurrency AS DebitTransactionCurrency,
  TransactionCurrency AS CreditTransactionCurrency,
  _DebitCreditCode._Text[1: Language = $parameters.P_Language].DebitCreditCodeName AS DebitCreditCodeName,
  Base.CompanyCodeCurrency AS CompanyCodeCurrency,
  AccountingDocumentCategory,
  AccountingDocumentItemType,
  SpecialGLTransactionType,
  PartnerBusinessArea,
  Base.TaxCountry AS TaxCountry,
  TaxType,
  Base.TaxItemGroup AS TaxItemGroup,
  Base.TransactionTypeDetermination AS TransactionTypeDetermination,
  FinancialTransactionType,
  CorporateGroupAccount,
  PlanningLevel,
  Base.ControllingArea AS ControllingArea,
  Project,
  ScheduleLine,
  ServiceDocumentType,
  ServiceDocument,
  ServiceDocumentItem,
  MasterFixedAsset,
  FixedAsset,
  AssetTransactionType,
  AssetValueDate,
  AssetClass,
  PersonnelNumber,
  IsSalesRelated,
  LineItemDisplayIsEnabled,
  IsOpenItemManaged,
  IsNotCashDiscountLiable,
  IsAutomaticallyCreated,
  IsBalanceSheetAccount,
  ProfitLossAccountType,
  SpecialGLAccountAssignment,
  PaymentBlockingReason,
  BPBankAccountInternalID,
  StateCentralBankPaymentReason,
  InvoiceList,
  BillOfExchangeUsage,
  DunningKey,
  DunningBlockingReason,
  LastDunningDate,
  DunningLevel,
  DunningArea,
  Material,
  Product,
  Plant,
  AccountAssignmentNumber,
  IsCompletelyDelivered,
  MaterialPriceControl,
  ValuationArea,
  InventoryValuationType,
  PaymentDifferenceReason,
  JointVenture,
  JointVentureCostRecoveryCode,
  JointVentureEquityGroup,
  TreasuryContractType,
  AssetContract,
  CashFlowType,
  Base.TaxJurisdiction AS TaxJurisdiction,
  RealEstateObject,
  SettlementReferenceDate,
  CommitmentItem,
  CostObject,
  ProjectNetwork,
  OrderInternalBillOfOperations,
  OrderIntBillOfOperationsItem,
  ProfitabilitySegment,
  JointVentureEquityType,
  CostOriginGroup,
  CompanyCodeCurrencyDetnMethod,
  AlternativeGLAccount,
  FundsCenter,
  Fund,
  PartnerProfitCenter,
  Reference1IDByBusinessPartner,
  Reference2IDByBusinessPartner,
  IsNegativePosting,
  PaymentCardItem,
  PaymentCardPaymentSettlement,
  Base.CreditControlArea AS CreditControlArea,
  Reference3IDByBusinessPartner,
  DataExchangeInstruction1,
  DataExchangeInstruction2,
  DataExchangeInstruction3,
  DataExchangeInstruction4,
  Region,
  HasPaymentOrder,
  Base.TaxDeterminationDate AS TaxDeterminationDate,
  P_Bset.TaxRateValidityStartDate AS TaxRateValidityStartDate,
  Base.BusinessPlace AS BusinessPlace,
  CostCtrActivityType,
  AccountsReceivableIsPledged,
  BusinessProcess,
  GrantID,
  CustomerIsInExecution,
  FundedProgram,
  LedgerGLLineItem,
  Segment,
  PartnerSegment,
  PartnerFunctionalArea,
  HouseBankAccount,
  CostElement,
  PaymentServiceProvider,
  PaymentRefByPaytSrvcProvider,
  SEPAMandate,
  ReferenceDocumentType,
  ReferenceDocumentLogicalSystem,
  AccountingDocumentItemRef,
  NetDueDate,
  CashDiscount1DueDate,
  CashDiscount2DueDate,
  OffsettingAccount,
  OffsettingAccountType,
  OffsettingChartOfAccounts,
  PartnerFund,
  PartnerGrant,
  BudgetPeriod,
  PartnerBudgetPeriod,
  BranchCode,
  Base.TaxBaseAmountInCoCodeCrcy AS TaxBaseAmountInCoCodeCrcy,
  ValuationDiffAmtInCoCodeCrcy,
  InvoiceAmtInCoCodeCrcy,
  OriginalTaxBaseAmount,
  Base.TaxBaseAmountInTransCrcy AS TaxBaseAmountInTransCrcy,
  PlannedAmtInTransactionCrcy,
  CashDiscountBaseAmount,
  NetPaymentAmount,
  InvoiceAmountInFrgnCurrency,
  BalanceTransactionCurrency,
  AmountInBalanceTransacCrcy,
  Base.AdditionalCurrency1 AS AdditionalCurrency1,
  ValuationDiffAmtInAddlCrcy1,
  AmountInAdditionalCurrency1,
  Base.AdditionalCurrency2 AS AdditionalCurrency2,
  AmountInAdditionalCurrency2,
  ValuationDiffAmtInAddlCrcy2,
  CreditControlAreaCurrency,
  HedgedAmount,
  BaseUnit,
  Quantity,
  GoodsMovementEntryUnit,
  QuantityInEntryUnit,
  PurchasingDocumentPriceUnit,
  PurchaseOrderQty,
  MaterialPriceUnitQty,
  NumberOfItems,
  Base._ChartOfAccounts AS _ChartOfAccounts,
  Base._ChartOfAccountsText AS _ChartOfAccountsText,
  Base._CompanyCode AS _CompanyCode,
  Base._ControllingArea AS _ControllingArea,
  Base._ControllingAreaText AS _ControllingAreaText
FROM FAC_DART_Z3_AR_LINEITEM_BASE AS Base
LEFT OUTER JOIN P_Bset ON /* join condition not captured in parsed metadata */
INNER JOIN I_LedgerCompanyCodeCrcyRoles ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN E_JournalEntryItem AS _Extension ON _Extension.SourceLedger = ' ' AND _Extension.CompanyCode = Base.CompanyCode AND _Extension.FiscalYear = Base.FiscalYear AND _Extension.AccountingDocument = Base.AccountingDocument AND _Extension.LedgerGLLineItem = Base.AccountingDocumentItem  -- association [0..1]
LEFT OUTER JOIN I_FiscalPeriodForVariant AS _ToFiscalPeriodForVariant ON _ToFiscalPeriodForVariant.FiscalYearVariant = FiscalYearVariant AND _ToFiscalPeriodForVariant.FiscalYear = $parameters.P_FiscalYear AND _ToFiscalPeriodForVariant.FiscalPeriod = $parameters.P_ToFiscalPeriod  -- association [0..1]
LEFT OUTER JOIN I_FiscalPeriodForVariant AS _FromFiscalPeriodForVariant ON _FromFiscalPeriodForVariant.FiscalYearVariant = FiscalYearVariant AND _FromFiscalPeriodForVariant.FiscalYear = $parameters.P_FiscalYear AND _FromFiscalPeriodForVariant.FiscalPeriod = $parameters.P_FromFiscalPeriod  -- association [0..1]
;