FAC_DART_Z3_AP_OPENITEM

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_AP_OPENITEM.
-- 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_DZAPOPITM
-- Parameters: P_Ledger : fins_ledger, P_FiscalYear : fins_gjahr, P_ToFiscalPeriod : fins_fagl_fiscper_to, P_Language : sylangu

CREATE VIEW FAC_DART_Z3_AP_OPENITEM AS
SELECT
  Base.CompanyCode AS CompanyCode,
  Base.AccountingDocument AS AccountingDocument,
  Base.FiscalYear AS FiscalYear,
  AccountingDocumentItem,
  $session.client AS SystemClient,
  FinancialAccountType,
  Supplier,
  Customer,
  SpecialGLCode,
  ClearingDate,
  ClearingAccountingDocument,
  AssignmentReference,
  PostingDate,
  DocumentDate,
  Base._JournalEntry.AccountingDocumentCreationDate AS AccountingDocumentCreationDate,
  TransactionCurrency,
  Base._JournalEntry.DocumentReferenceID AS 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,
  Base._JournalEntry.NetAmountIsPosted AS 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,
  OriginalReferenceDocument,
  ReferenceDocumentType,
  Base.CompanyCodeCurrency AS DebitCompanyCodeCurrency,
  Base.CompanyCodeCurrency AS CreditCompanyCodeCurrency,
  Base.AmountInCompanyCodeCurrency AS BalanceAmountInCoCodeCrcy,
  Base.CompanyCodeCurrency AS CompanyCodeCurrency,
  TransactionCurrency AS DebitTransactionCurrency,
  TransactionCurrency AS CreditTransactionCurrency,
  _DebitCreditCode._Text[1: Language = $parameters.P_Language].DebitCreditCodeName AS DebitCreditCodeName,
  AccountingDocumentCategory,
  Base.ChartOfAccounts AS ChartOfAccounts,
  AccountingDocumentItemType,
  ClearingCreationDate,
  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_2 AS ProfitabilitySegment,
  JointVentureEquityType,
  CostOriginGroup,
  CompanyCodeCurrencyDetnMethod,
  ClearingIsReversed,
  AlternativeGLAccount,
  FundsCenter,
  Fund,
  PartnerProfitCenter,
  Reference1IDByBusinessPartner,
  Reference2IDByBusinessPartner,
  Reference3IDByBusinessPartner,
  IsNegativePosting,
  PaymentCardItem,
  PaymentCardPaymentSettlement,
  Base.CreditControlArea AS CreditControlArea,
  DataExchangeInstruction1,
  DataExchangeInstruction2,
  DataExchangeInstruction3,
  DataExchangeInstruction4,
  Region,
  HasPaymentOrder,
  Base.TaxDeterminationDate AS TaxDeterminationDate,
  P_Bset.TaxRateValidityStartDate AS TaxRateValidityStartDate,
  ClearingItem,
  Base.BusinessPlace AS BusinessPlace,
  CostCtrActivityType,
  AccountsReceivableIsPledged,
  BusinessProcess,
  GrantID,
  CustomerIsInExecution,
  FundedProgram,
  ClearingDocFiscalYear,
  LedgerGLLineItem,
  Segment,
  PartnerSegment,
  PartnerFunctionalArea,
  HouseBankAccount,
  CostElement,
  PaymentServiceProvider,
  PaymentRefByPaytSrvcProvider,
  SEPAMandate,
  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 I_OperationalAcctgDocItem AS Base
INNER JOIN I_LedgerCompanyCodeCrcyRoles ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_Bset 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 _FiscalPeriodForVariant ON _FiscalPeriodForVariant.FiscalYearVariant = FiscalYearVariant AND _FiscalPeriodForVariant.FiscalYear = $parameters.P_FiscalYear AND _FiscalPeriodForVariant.FiscalPeriod = $parameters.P_ToFiscalPeriod  -- association [0..1]
;