FAC_DART_Z3_AR_TRIAL_BALANCE

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_TRIAL_BALANCE.
-- 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_DZARTRIBAL
-- Parameters: P_KeyDate : sydate, P_Language : fac_audit_language, P_FromPostingDate : fis_budat_from, P_ToPostingDate : fis_budat_to

CREATE VIEW FAC_DART_Z3_AR_TRIAL_BALANCE AS
SELECT
  SystemClient,
  Ledger,
  CompanyCode,
  Supplier,
  Customer,
  GLAccount,
  PostingDate,
  FiscalYear,
  LedgerFiscalYear,
  SourceLedger,
  FinancialTransactionType,
  BusinessTransactionType,
  ReferenceDocumentType,
  LogicalSystem,
  ReferenceDocumentItemGroup,
  IsReversal,
  IsReversed,
  IsSettlement,
  IsSettled,
  PredecessorReferenceDocType,
  ProfitCenter,
  FunctionalArea,
  BusinessArea,
  ControllingArea,
  Segment,
  PartnerCostCenter,
  PartnerProfitCenter,
  PartnerFunctionalArea,
  PartnerBusinessArea,
  PartnerCompany,
  PartnerSegment,
  DebitCreditCode,
  FiscalYearVariant,
  FiscalYearPeriod,
  FiscalPeriod,
  AccountingDocumentType,
  AssignmentReference,
  PostingKey,
  AccountingDocumentCategory,
  TransactionTypeDetermination,
  AccountingDocCreatedByUser,
  EliminationProfitCenter,
  OriginObjectType,
  GLAccountType,
  ChartOfAccounts,
  AlternativeGLAccount,
  CountryChartOfAccounts,
  PurchasingDocument,
  PurchasingDocumentItem,
  AccountAssignmentNumber,
  Material,
  MaterialName,
  Plant,
  _Plant.PlantName AS PlantName,
  FinancialAccountType,
  SpecialGLCode,
  TaxCode,
  HouseBank,
  HouseBankAccount,
  IsOpenItemManaged,
  ClearingAccountingDocument,
  ClearingDocFiscalYear,
  AssetDepreciationArea,
  MasterFixedAsset,
  FixedAsset,
  AssetValueDate,
  AssetTransactionType,
  GroupMasterFixedAsset,
  GroupFixedAsset,
  InventorySpecialStockValnType,
  InventorySpecialStockType,
  InventorySpclStkSalesDocument,
  InventorySpclStkSalesDocItm,
  InventorySpclStockWBSElement,
  InventorySpecialStockSupplier,
  InventoryValuationType,
  ValuationArea,
  SenderGLAccount,
  SenderAccountAssignment,
  SenderAccountAssignmentType,
  ControllingObjectDebitType,
  QuantityIsIncomplete,
  OffsettingAccount,
  OffsettingAccountType,
  LineItemIsCompleted,
  PersonnelNumber,
  ControllingObjectClass,
  PartnerCompanyCode,
  PartnerControllingObjectClass,
  OriginCostCenter,
  OriginCostCtrActivityType,
  AccountAssignment,
  AccountAssignmentType,
  ProjectNetwork,
  RelatedNetworkActivity,
  BusinessProcess,
  CostObject,
  CustomerServiceNotification,
  OperatingConcern,
  PartnerAccountAssignment,
  PartnerAccountAssignmentType,
  PartnerCostCtrActivityType,
  PartnerOrder,
  PartnerOrderCategory,
  PartnerWBSElement,
  PartnerProject,
  PartnerSalesDocument,
  PartnerSalesDocumentItem,
  PartnerProjectNetwork,
  PartnerProjectNetworkActivity,
  PartnerBusinessProcess,
  PartnerCostObject,
  ServiceDocumentType,
  ServiceDocument,
  ServiceDocumentItem,
  PartnerServiceDocumentType,
  PartnerServiceDocument,
  PartnerServiceDocumentItem,
  ServiceContract,
  ServiceContractType,
  ServiceContractItem,
  BillingDocumentType,
  SalesOrganization,
  DistributionChannel,
  OrganizationDivision,
  SoldMaterial,
  MaterialGroup,
  MaterialGroupName,
  CustomerGroup,
  FinancialManagementArea,
  Fund,
  GrantID,
  BudgetPeriod,
  PartnerFund,
  PartnerGrant,
  PartnerBudgetPeriod,
  JointVenture,
  JointVentureEquityGroup,
  JointVentureCostRecoveryCode,
  JointVentureEquityType,
  SettlementReferenceDate,
  CostCenter,
  CostCtrActivityType,
  OrderID,
  OrderCategory,
  WBSElement,
  Project,
  SalesOrder,
  SalesOrderItem,
  SalesDocument,
  SalesDocumentItem,
  ClearingDate,
  CompanyCodeCurrency,
  GlobalCurrency,
  FreeDefinedCurrency1,
  FreeDefinedCurrency2,
  FreeDefinedCurrency3,
  FreeDefinedCurrency4,
  FreeDefinedCurrency5,
  FreeDefinedCurrency6,
  FreeDefinedCurrency7,
  FreeDefinedCurrency8,
  BalanceTransactionCurrency,
  TransactionCurrency,
  FiscalPeriodDate,
  CalendarYear,
  CalendarQuarter,
  CalendarYearQuarter,
  CalendarMonth,
  CalendarYearMonth,
  CalendarWeek,
  CalendarYearWeek,
  FiscalQuarter,
  FiscalWeek,
  FiscalYearQuarter,
  FiscalYearWeek,
  CorporateGroupAccount,
  CorporateGroupChartOfAccounts,
  IsBalanceSheetAccount,
  CompanyCodeCurrencyforStart,
  CompanyCodeCurrencyforEnd,
  CompanyCodeCurrencyforDebit,
  CompanyCodeCurrencyforCredit,
  cast( cast( 1 as abap.dec(23,2)) as fis_start_bal_hsl_ui ) AS StartingBalanceAmtInCoCodeCrcy,
  cast( cast( 1 as abap.dec(23,2)) as fis_dr_bal_hsl ) AS DebitAmountInCoCodeCrcy,
  cast( cast( 1 as abap.dec(23,2)) as fis_cr_bal_hsl ) AS CreditAmountInCoCodeCrcy,
  cast( cast( 1 as abap.dec(23,2)) as fis_cr_bal_hsl ) AS CreditAmountInCoCodeCrcyDis,
  cast( cast( 1 as abap.dec(23,2)) as fis_end_bal_hsl_ui ) AS EndingBalanceAmtInCoCodeCrcy,
  EndingBalanceAmtInCoCodeCrcy AS IntmdEndingBalAmtInCoCodeCrcy,
  DebitAmountInCoCodeCrcy AS GLAcctDebitAmtInCoCodeCrcy,
  CreditAmountInCoCodeCrcy AS GLAcctCreditAmtInCoCodeCrcy,
  cast( cast( 1 as abap.dec(23,2)) as fis_start_bal_ksl_ui ) AS StartingBalanceAmtInGlobalCrcy,
  cast( cast( 1 as abap.dec(23,2)) as fis_dr_bal_ksl ) AS DebitAmountInGlobalCrcy,
  cast( cast( 1 as abap.dec(23,2)) as fis_cr_bal_ksl ) AS CreditAmountInGlobalCrcy,
  cast( cast( 1 as abap.dec(23,2)) as fis_cr_bal_ksl ) AS CreditAmountInGlobalCrcyDis,
  cast( cast( 1 as abap.dec(23,2)) as fis_end_bal_ksl_ui ) AS EndingBalanceAmtInGlobalCrcy,
  EndingBalanceAmtInGlobalCrcy AS IntmdEndingBalAmtInGlobalCrcy,
  DebitAmountInGlobalCrcy AS IntmdDebitAmountInGlobalCrcy,
  CreditAmountInGlobalCrcy AS IntmdCreditAmountInGlobalCrcy,
  cast( cast( 1 as abap.dec(23,2)) as fis_start_bal_osl_ui ) AS StartingBalAmtInFreeDfndCrcy1,
  cast( cast( 1 as abap.dec(23,2)) as fis_dr_bal_osl ) AS DebitAmountInFreeDefinedCrcy1,
  cast( cast( 1 as abap.dec(23,2)) as fis_cr_bal_osl ) AS CreditAmountInFreeDefinedCrcy1,
  cast( cast( 1 as abap.dec(23,2)) as fis_cr_bal_osl ) AS CreditAmtInFreeDefinedCrcy1Dis,
  cast( cast( 1 as abap.dec(23,2)) as fis_end_bal_osl_ui ) AS EndingBalAmtInFreeDfndCrcy1,
  EndingBalAmtInFreeDfndCrcy1 AS IntmdEndingBalInFreeDfndCrcy1,
  DebitAmountInFreeDefinedCrcy1 AS IntmdDebitAmtInFreeDfndCrcy1,
  CreditAmountInFreeDefinedCrcy1 AS IntmdCreditAmtInFreeDfndCrcy1,
  cast( cast( 1 as abap.dec(23,2)) as fis_start_bal_vsl_ui ) AS StartingBalAmtInFreeDfndCrcy2,
  cast( cast( 1 as abap.dec(23,2)) as fis_dr_bal_vsl ) AS DebitAmountInFreeDefinedCrcy2,
  cast( cast( 1 as abap.dec(23,2)) as fis_cr_bal_vsl ) AS CreditAmountInFreeDefinedCrcy2,
  cast( cast( 1 as abap.dec(23,2)) as fis_cr_bal_vsl ) AS CreditAmtInFreeDefinedCrcy2Dis,
  cast( cast( 1 as abap.dec(23,2)) as fis_end_bal_vsl_ui ) AS EndingBalAmtInFreeDfndCrcy2,
  EndingBalAmtInFreeDfndCrcy2 AS IntmdEndingBalInFreeDfndCrcy2,
  DebitAmountInFreeDefinedCrcy2 AS IntmdDebitAmtInFreeDfndCrcy2,
  CreditAmountInFreeDefinedCrcy2 AS IntmdCreditAmtInFreeDfndCrcy2,
  cast( cast( 1 as abap.dec(23,2)) as fis_start_bal_bsl_ui ) AS StartingBalAmtInFreeDfndCrcy3,
  cast( cast( 1 as abap.dec(23,2)) as fis_dr_bal_bsl ) AS DebitAmountInFreeDefinedCrcy3,
  cast( cast( 1 as abap.dec(23,2)) as fis_cr_bal_bsl ) AS CreditAmountInFreeDefinedCrcy3,
  cast( cast( 1 as abap.dec(23,2)) as fis_cr_bal_bsl ) AS CreditAmtInFreeDefinedCrcy3Dis,
  cast( cast( 1 as abap.dec(23,2)) as fis_end_bal_bsl_ui ) AS EndingBalAmtInFreeDfndCrcy3,
  EndingBalAmtInFreeDfndCrcy3 AS IntmdEndingBalInFreeDfndCrcy3,
  DebitAmountInFreeDefinedCrcy3 AS IntmdDebitAmtInFreeDfndCrcy3,
  CreditAmountInFreeDefinedCrcy3 AS IntmdCreditAmtInFreeDfndCrcy3,
  cast( cast( 1 as abap.dec(23,2)) as fis_start_bal_csl ) AS StartingBalAmtInFreeDfndCrcy4,
  cast( cast( 1 as abap.dec(23,2)) as fis_dr_bal_csl ) AS DebitAmountInFreeDefinedCrcy4,
  cast( cast( 1 as abap.dec(23,2)) as fis_cr_bal_csl ) AS CreditAmountInFreeDefinedCrcy4,
  cast( cast( 1 as abap.dec(23,2)) as fis_cr_bal_csl ) AS CreditAmtInFreeDefinedCrcy4Dis,
  cast( cast( 1 as abap.dec(23,2)) as fis_end_bal_csl_ui ) AS EndingBalAmtInFreeDfndCrcy4,
  EndingBalAmtInFreeDfndCrcy4 AS IntmdEndingBalInFreeDfndCrcy4,
  DebitAmountInFreeDefinedCrcy4 AS IntmdDebitAmtInFreeDfndCrcy4,
  CreditAmountInFreeDefinedCrcy4 AS IntmdCreditAmtInFreeDfndCrcy4,
  cast( cast( 1 as abap.dec(23,2)) as fis_start_bal_dsl ) AS StartingBalAmtInFreeDfndCrcy5,
  cast( cast( 1 as abap.dec(23,2)) as fis_dr_bal_dsl ) AS DebitAmountInFreeDefinedCrcy5,
  cast( cast( 1 as abap.dec(23,2)) as fis_cr_bal_dsl ) AS CreditAmountInFreeDefinedCrcy5,
  cast( cast( 1 as abap.dec(23,2)) as fis_cr_bal_dsl ) AS CreditAmtInFreeDefinedCrcy5Dis,
  cast( cast( 1 as abap.dec(23,2)) as fis_end_bal_dsl_ui ) AS EndingBalAmtInFreeDfndCrcy5,
  EndingBalAmtInFreeDfndCrcy5 AS IntmdEndingBalInFreeDfndCrcy5,
  DebitAmountInFreeDefinedCrcy5 AS IntmdDebitAmtInFreeDfndCrcy5,
  CreditAmountInFreeDefinedCrcy5 AS IntmdCreditAmtInFreeDfndCrcy5,
  cast( cast( 1 as abap.dec(23,2)) as fis_start_bal_esl ) AS StartingBalAmtInFreeDfndCrcy6,
  cast( cast( 1 as abap.dec(23,2)) as fis_dr_bal_esl ) AS DebitAmountInFreeDefinedCrcy6,
  cast( cast( 1 as abap.dec(23,2)) as fis_cr_bal_esl ) AS CreditAmountInFreeDefinedCrcy6,
  cast( cast( 1 as abap.dec(23,2)) as fis_cr_bal_esl ) AS CreditAmtInFreeDefinedCrcy6Dis,
  cast( cast( 1 as abap.dec(23,2)) as fis_end_bal_esl_ui ) AS EndingBalAmtInFreeDfndCrcy6,
  EndingBalAmtInFreeDfndCrcy6 AS IntmdEndingBalInFreeDfndCrcy6,
  DebitAmountInFreeDefinedCrcy6 AS IntmdDebitAmtInFreeDfndCrcy6,
  CreditAmountInFreeDefinedCrcy6 AS IntmdCreditAmtInFreeDfndCrcy6,
  cast( cast( 1 as abap.dec(23,2)) as fis_start_bal_fsl_ui ) AS StartingBalAmtInFreeDfndCrcy7,
  cast( cast( 1 as abap.dec(23,2)) as fis_dr_bal_fsl ) AS DebitAmountInFreeDefinedCrcy7,
  cast( cast( 1 as abap.dec(23,2)) as fis_cr_bal_fsl ) AS CreditAmountInFreeDefinedCrcy7,
  cast( cast( 1 as abap.dec(23,2)) as fis_cr_bal_fsl ) AS CreditAmtInFreeDefinedCrcy7Dis,
  cast( cast( 1 as abap.dec(23,2)) as fis_end_bal_fsl_ui ) AS EndingBalAmtInFreeDfndCrcy7,
  EndingBalAmtInFreeDfndCrcy7 AS IntmdEndingBalInFreeDfndCrcy7,
  DebitAmountInFreeDefinedCrcy7 AS IntmdDebitAmtInFreeDfndCrcy7,
  CreditAmountInFreeDefinedCrcy7 AS IntmdCreditAmtInFreeDfndCrcy7,
  cast( cast( 1 as abap.dec(23,2)) as fis_start_bal_gsl ) AS StartingBalAmtInFreeDfndCrcy8,
  cast( cast( 1 as abap.dec(23,2)) as fis_dr_bal_gsl ) AS DebitAmountInFreeDefinedCrcy8,
  cast( cast( 1 as abap.dec(23,2)) as fis_cr_bal_gsl ) AS CreditAmountInFreeDefinedCrcy8,
  cast( cast( 1 as abap.dec(23,2)) as fis_cr_bal_gsl ) AS CreditAmtInFreeDefinedCrcy8Dis,
  cast( cast( 1 as abap.dec(23,2)) as fis_end_bal_gsl_ui ) AS EndingBalAmtInFreeDfndCrcy8,
  EndingBalAmtInFreeDfndCrcy8 AS IntmdEndingBalInFreeDfndCrcy8,
  DebitAmountInFreeDefinedCrcy8 AS IntmdDebitAmtInFreeDfndCrcy8,
  CreditAmountInFreeDefinedCrcy8 AS IntmdCreditAmtInFreeDfndCrcy8,
  cast( cast( 1 as abap.dec(23,2)) as fis_start_bal_tsl_ui ) AS StartingBalAmtInBalTransCrcy,
  cast( cast( 1 as abap.dec(23,2)) as fis_dr_bal_tsl ) AS DebitAmountInBalanceTransCrcy,
  cast( cast( 1 as abap.dec(23,2)) as fis_cr_bal_tsl ) AS CreditAmountInBalanceTransCrcy,
  cast( cast( 1 as abap.dec(23,2)) as fis_cr_bal_tsl ) AS CreditAmtInBalanceTransCrcyDis,
  cast( cast( 1 as abap.dec(23,2)) as fis_end_bal_tsl_ui ) AS EndingBalanceAmtInBalTransCrcy,
  EndingBalanceAmtInBalTransCrcy AS IntmdEndingBalInBalTransCrcy,
  DebitAmountInBalanceTransCrcy AS IntmdDebitAmtInBalTransCrcy,
  CreditAmountInBalanceTransCrcy AS IntmdCreditAmtInBalTransCrcy,
  cast( cast( 1 as abap.dec(23,2)) as fis_start_bal_wsl_ui ) AS StartingBalanceAmtInTransCrcy,
  cast( cast( 1 as abap.dec(23,2)) as fis_dr_bal_wsl ) AS DebitAmountInTransCrcy,
  cast( cast( 1 as abap.dec(23,2)) as fis_cr_bal_wsl ) AS CreditAmountInTransCrcy,
  cast( cast( 1 as abap.dec(23,2)) as fis_cr_bal_wsl ) AS CreditAmountInTransCrcyDis,
  cast( cast( 1 as abap.dec(23,2)) as fis_end_bal_wsl_ui ) AS EndingBalanceAmtInTransCrcy,
  EndingBalanceAmtInTransCrcy AS IntmdEndingBalanceInTransCrcy,
  DebitAmountInTransCrcy AS IntmdDebitAmtInTransCrcy,
  CreditAmountInTransCrcy AS IntmdCreditAmountInTransCrcy
FROM FAC_DART_Z3_GLACCTBALANCE
;