A_AllocationRunResult

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 A_AllocationRunResult.
-- 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.

CREATE VIEW A_AllocationRunResult AS
SELECT
  UniversalAllocationRun,
  AllocationCycle,
  AllocationCycleStartDate,
  AllocationCycleSegment,
  AllocationRunDataCategory,
  AllocationRunResultItem,
  Ledger,
  LedgerName,
  CompanyCode,
  CompanyCodeName,
  cast(FiscalYear as fis_gjahr_no_conv) AS FiscalYear,
  cast(LedgerFiscalYear as fis_gjahr_no_conv ) AS LedgerFiscalYear,
  GLRecordType,
  GLRecordTypeName,
  FinancialTransactionType,
  FinancialTransactionTypeName,
  BusinessTransactionType,
  BusinessTransactionTypeName,
  ReferenceDocumentType,
  LogicalSystem,
  ReferenceDocumentContext,
  ReferenceDocument,
  ReferenceDocumentItem,
  ReferenceDocumentItemGroup,
  IsReversal,
  IsReversed,
  ReversalReferenceDocumentCntxt,
  ReversalReferenceDocument,
  IsSettlement,
  IsSettled,
  PredecessorReferenceDocType,
  PredecessorReferenceDocCntxt,
  PredecessorReferenceDocument,
  PredecessorReferenceDocItem,
  SourceReferenceDocumentType,
  SourceLogicalSystem,
  SourceReferenceDocumentCntxt,
  SourceReferenceDocument,
  SourceReferenceDocumentItem,
  SourceReferenceDocSubitem,
  IsCommitment,
  JrnlEntryItemObsoleteReason,
  BalanceTransactionCurrency,
  TransactionCurrency,
  CompanyCodeCurrency,
  GlobalCurrency,
  FreeDefinedCurrency1,
  FreeDefinedCurrency2,
  FreeDefinedCurrency3,
  FreeDefinedCurrency4,
  FreeDefinedCurrency5,
  FreeDefinedCurrency6,
  FreeDefinedCurrency7,
  FreeDefinedCurrency8,
  ControllingObjectCurrency,
  BaseUnit,
  BaseUnitName,
  CostSourceUnit,
  AdditionalQuantity1Unit,
  AdditionalQuantity2Unit,
  AdditionalQuantity3Unit,
  GLAccount,
  GLAccountName,
  CostCenter,
  CostCenterName,
  ProfitCenter,
  ProfitCenterName,
  FunctionalArea,
  FunctionalAreaName,
  BusinessArea,
  BusinessAreaName,
  ControllingArea,
  ControllingAreaName,
  ReportingSegment,
  ReportingSegmentName,
  PartnerCostCenter,
  PartnerCostCenterName,
  PartnerProfitCenter,
  PartnerProfitCenterName,
  PartnerFunctionalArea,
  PartnerFunctionalAreaName,
  PartnerBusinessArea,
  PartnerBusinessAreaText,
  PartnerCompany,
  PartnerCompanyName,
  PartnerSegment,
  PartnerSegmentText,
  AmountInBalanceTransacCrcy,
  AmountInTransactionCurrency,
  AmountInCompanyCodeCurrency,
  AmountInGlobalCurrency,
  AmountInFreeDefinedCurrency1,
  AmountInFreeDefinedCurrency2,
  AmountInFreeDefinedCurrency3,
  AmountInFreeDefinedCurrency4,
  AmountInFreeDefinedCurrency5,
  AmountInFreeDefinedCurrency6,
  AmountInFreeDefinedCurrency7,
  AmountInFreeDefinedCurrency8,
  FixedAmountInGlobalCrcy,
  GrpValnFixedAmtInGlobCrcy,
  PrftCtrValnFxdAmtInGlobCrcy,
  TotalPriceVarcInGlobalCrcy,
  GrpValnTotPrcVarcInGlobCrcy,
  PrftCtrValnTotPrcVarcInGlbCrcy,
  FixedPriceVarcInGlobalCrcy,
  GrpValnFixedPrcVarcInGlobCrcy,
  PrftCtrValnFxdPrcVarcInGlbCrcy,
  AmountInObjectCurrency,
  Quantity,
  FixedQuantity,
  ValuationQuantity,
  ValuationFixedQuantity,
  AdditionalQuantity1,
  AdditionalQuantity2,
  AdditionalQuantity3,
  DebitCreditCode,
  DebitCreditCodeName,
  FiscalPeriod,
  FiscalYearVariant,
  FiscalYearPeriod,
  PostingDate,
  DocumentDate,
  AccountingDocumentType,
  AccountingDocumentItem,
  AssignmentReference,
  PostingKey,
  PostingKeyName,
  AccountingDocumentCategory,
  AccountingDocumentCategoryName,
  TransactionTypeDetermination,
  SubLedgerAcctLineItemType,
  AccountingDocCreatedByUser,
  FullName,
  CreationDateTime,
  EliminationProfitCenter,
  EliminationProfitCenterName,
  OriginObjectType,
  GLAccountType,
  GLAccountTypeName,
  ChartOfAccounts,
  ChartOfAccountsName,
  AlternativeGLAccount,
  AlternativeGLAccountLongName,
  CountryChartOfAccounts,
  InvoiceReference,
  cast(InvoiceReferenceFiscalYear as fis_rebzj_no_conv ) AS InvoiceReferenceFiscalYear,
  InvoiceItemReference,
  FollowOnDocumentType,
  ReferencePurchaseOrderCategory,
  PurchasingDocument,
  PurchasingDocumentItem,
  AccountAssignmentNumber,
  DocumentItemText,
  SalesOrder,
  SalesDocumentItem,
  Material,
  MaterialName,
  Plant,
  PlantName,
  Supplier,
  SupplierName,
  Customer,
  CustomerName,
  ServicesRenderedDate,
  ConditionContract,
  FinancialAccountType,
  FinancialAccountTypeName,
  SpecialGLCode,
  TaxCode,
  HouseBank,
  HouseBankName,
  HouseBankAccount,
  IsOpenItemManaged,
  ClearingDate,
  ClearingAccountingDocument,
  cast(ClearingDocFiscalYear as fis_auggj_no_conv ) AS ClearingDocFiscalYear,
  AssetDepreciationArea,
  MasterFixedAsset,
  FixedAsset,
  AssetValueDate,
  AssetTransactionType,
  AssetAcctTransClassfctn,
  DepreciationFiscalPeriod,
  GroupMasterFixedAsset,
  GroupFixedAsset,
  AssetClass,
  AssetClassName,
  CostEstimate,
  InventorySpecialStockValnType,
  InventorySpecialStockType,
  InventorySpecialStockTypeName,
  InventorySpclStkSalesDocument,
  InventorySpclStkSalesDocItm,
  InvtrySpclStockWBSElmntIntID,
  InventorySpclStockWBSElement,
  InventorySpecialStockSupplier,
  InventoryValuationType,
  ValuationArea,
  SenderGLAccount,
  SenderGLAccountName,
  SenderAccountAssignment,
  SenderAccountAssignmentType,
  SndrAcctAsgtTypeName,
  ControllingObject,
  CostOriginGroup,
  OriginSenderObject,
  ControllingObjectDebitType,
  QuantityIsIncomplete,
  OffsettingAccount,
  OffsettingAccountName,
  OffsettingAccountType,
  OffsettingAccountTypeName,
  LineItemIsCompleted,
  PersonnelNumber,
  ControllingObjectClass,
  PartnerCompanyCode,
  PartnerCompanyCodeName,
  PartnerControllingObjectClass,
  OriginCostCenter,
  OriginCostCenterName,
  OriginCostCtrActivityType,
  OriginCostCtrActivityTypeName,
  OriginProfitCenter,
  OriginProfitCenterName,
  AccountAssignment,
  AccountAssignmentType,
  AccountAssignmentTypeName,
  CostCtrActivityType,
  CostCtrActivityTypeName,
  OrderID,
  OrderCategory,
  OrderCategoryName,
  WBSElementInternalID,
  WBSElementExternalID,
  WBSDescription,
  WBSElementLangBsdDescription,
  ProjectInternalID,
  ProjectDescription,
  ProjectNetwork,
  BusinessProcess,
  BusinessProcessName,
  CostObject,
  BillableControl,
  CostAnalysisResource,
  CustomerServiceNotification,
  ServiceDocumentType,
  ServiceDocument,
  ServiceDocumentItem,
  ServiceContractType,
  ServiceContract,
  ServiceContractItem,
  BusinessSolutionOrder,
  BusinessSolutionOrderItem,
  TimeSheetOvertimeCategory,
  WorkPackage,
  WorkItem,
  OperatingConcern,
  OperatingConcernName,
  PartnerAccountAssignment,
  PartnerAccountAssignmentType,
  PartAccountAssignmentTypeName,
  PartnerCostCtrActivityType,
  PartnerCostCtrActivityTypeName,
  PartnerOrder,
  PartnerOrderCategory,
  PartnerOrderCategoryName,
  PartnerWBSElementInternalID,
  PartnerWBSElementDescription,
  PartnerProjectInternalID,
  PartnerProject,
  PartnerProjectDescription,
  PartnerSalesDocument,
  PartnerSalesDocumentItem,
  PartnerProjectNetwork,
  cast(PartnerProjectNetworkActivity as fis_par_vornr_auf_no_conv ) AS PartnerProjectNetworkActivity,
  PartnerBusinessProcess,
  PartnerCostObject,
  BillingDocumentType,
  BillingDocumentTypeName,
  SalesOrganization,
  SalesOrganizationName,
  DistributionChannel,
  DistributionChannelName,
  OrganizationDivision,
  OrganizationDivisionText,
  SoldProduct,
  SoldProductName,
  SoldProductGroup,
  SoldProductGroupName,
  CustomerGroup,
  CustomerGroupName,
  CustomerSupplierCountry,
  CustomerSupplierCountryName,
  CustomerSupplierIndustry,
  CustomerSupplierIndustryName,
  SalesDistrict,
  SalesDistrictName,
  BillToParty,
  BillToPartyName,
  ShipToParty,
  ShipToPartyName,
  CustomerSupplierCorporateGroup,
  FinancialManagementArea,
  FundsCenter,
  FundsCenterName,
  FundedProgram,
  FundedProgramName,
  Fund,
  FundName,
  GrantID,
  GrantName,
  BudgetPeriod,
  BudgetPeriodName,
  PartnerFund,
  PartnerFundText,
  PartnerGrant,
  PartnerGrantName,
  PartnerBudgetPeriod,
  JointVenture,
  JointVentureName,
  JointVentureEquityGroup,
  JntOpgAgrmtEquityGrpText,
  JointVentureCostRecoveryCode,
  JointVenturePartner,
  JointVenturePartnerName,
  JointVentureBillingType,
  JointVentureEquityType,
  JointVentureEquityTypeName,
  JointVentureProductionDate,
  JointVentureBillingDate,
  JointVentureOperationalDate,
  CutbackRun,
  JointVentureAccountingActivity,
  PartnerVenture,
  PartnerVentureName,
  PartnerEquityGroup,
  SenderCostRecoveryCode,
  CutbackAccount,
  CutbackAccountName,
  CutbackCostObject,
  SettlementReferenceDate,
  ControllingBusTransacType,
  PrdcssrJournalEntryCompanyCode,
  PrdcssrJournalEntryFiscalYear,
  PredecessorJournalEntry,
  PredecessorJournalEntryItem,
  OrganizationalChange,
  GrantCurrency,
  AmountInGrantCurrency,
  ReferenceQuantityUnit,
  ReferenceQuantity,
  LastChangeDateTime,
  SalesDocument,
  Product,
  ProductName,
  PerformancePeriodStartDate,
  PerformancePeriodEndDate,
  TaxCountry,
  TaxCountryName,
  ValueDate,
  SenderCompanyCode,
  SenderCompanyCodeName,
  OriginProduct,
  OriginProductName,
  VarianceOriginGLAccount,
  PartnerServiceDocumentType,
  PartnerServiceDocument,
  PartnerServiceDocumentItem,
  CashLedgerCompanyCode,
  CashLedgerCompanyCodeName,
  CashLedgerAccount,
  CashLedgerAccountName,
  PubSecBudgetAccount,
  PubSecBudgetAccountCoCode,
  PubSecBudgetCnsmpnDate,
  PubSecBudgetCnsmpnFsclPeriod,
  cast(PubSecBudgetCnsmpnFsclYear as psm_bdgt_cnsmpn_year_no_conv ) AS PubSecBudgetCnsmpnFsclYear,
  PubSecBudgetIsRelevant,
  PubSecBudgetCnsmpnType,
  PubSecBudgetCnsmpnAmtType,
  SponsoredProgram,
  SponsoredClass,
  REBusinessEntity,
  RealEstateBuilding,
  RealEstateProperty,
  RERentalObject,
  RealEstateContract,
  REPartnerBusinessEntity,
  RealEstatePartnerBuilding,
  RealEstatePartnerProperty,
  REPartnerRentalObject,
  RealEstatePartnerContract,
  REPartnerServiceChargeKey,
  REPartnerSettlementUnitID,
  PartnerSettlementReferenceDate,
  CAProviderContract,
  CAProviderContractItemNumber,
  TransactionSubitem,
  FunctionalCurrency,
  AmountInFunctionalCurrency,
  ItemIsSplit,
  StatisticalKeyFigure,
  StatisticalKeyFigureName,
  AllocationCycleCategory,
  AllocationCycleNameText,
  SegmentName,
  SegmentNameDescription,
  AllocationType,
  AllocationActualPlanVariant,
  AllocActualPlanVariantText,
  AllocationPostingType,
  AllocationPostingTypeText,
  AllocationCycleName,
  AuthorizationGroup,
  AllocationRunIsTest,
  AllocationCycleIsReversed,
  AllocationRunTracingFactorQty,
  VariablePortion,
  VariablePortionText,
  VariablePortionType,
  VariablePortionTypeText,
  AllocationPortionPlanCategory,
  AllocRunTracingFctrQtyUnit,
  AllocationRunWeightingFactor,
  AllocationSenderRule,
  AllocationSenderRuleText,
  AllocationReceiverRule,
  AllocationReceiverRuleText
FROM C_AllocationRunResult
;