C_GenericPlanQ3001

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 C_GenericPlanQ3001.
-- 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: CFIGENERICPLAN
-- Parameters: P_KeyDate : vdm_v_key_date, P_Language : sylangu, P_BusinessUser : syuname

CREATE VIEW C_GenericPlanQ3001 AS
SELECT
  GLAccount,
  CostCtrActivityType,
  BillingDocumentType,
  BillToParty,
  GteeMBudgetValidityNumber,
  BudgetPeriod,
  BudgetProcess,
  BudgetingType,
  BusinessArea,
  BusinessTransactionType,
  ChartOfAccounts,
  CompanyCode,
  CompanyCodeCurrency,
  ControllingArea,
  CostCenter,
  CostSourceUnit,
  CustomerSupplierCountry,
  CustomerSupplierIndustry,
  CustomerSupplierCorporateGroup,
  Customer,
  CustomerGroup,
  DistributionChannel,
  Division,
  ControllingDebitCreditCode,
  FinancialTransactionType,
  FiscalPeriod,
  FiscalYearPeriod,
  FiscalYearVariant,
  FinancialManagementArea,
  FreeDefinedCurrency1,
  FreeDefinedCurrency2,
  FreeDefinedCurrency3,
  FreeDefinedCurrency4,
  FreeDefinedCurrency5,
  FreeDefinedCurrency6,
  FreeDefinedCurrency7,
  FreeDefinedCurrency8,
  FunctionalArea,
  FunctionalCurrency,
  Fund,
  GlobalCurrency,
  GrantID,
  JointVenture,
  JointVentureEquityGroup,
  JointVentureCostRecoveryCode,
  JointVentureProductionDate,
  Ledger,
  LedgerFiscalYear,
  AccountingDocument,
  LedgerGLLineItem,
  Material,
  AccountAssignmentType,
  ControllingObjectCurrency,
  OrderID,
  PartnerBusinessArea,
  PartnerCompanyCode,
  PartnerCostCtrActivityType,
  PartnerCostCenter,
  PartnerFunctionalArea,
  PartnerOrder_2 AS PartnerOrder,
  PartnerProfitCenter,
  PartnerProject,
  PartnerProjectExternalID,
  PartnerSegment,
  PartnerWBSElement,
  PartnerWBSElementExternalID,
  PlanningCategory,
  Plant,
  PersonnelNumber,
  PostingDate,
  Product,
  MaterialGroup,
  ProfitCenter,
  Project,
  ProjectExternalID,
  REBusinessEntity,
  RealEstateBuilding,
  RealEstateProperty,
  RERentalObject,
  RealEstateContract,
  REServiceChargeKey,
  RESettlementUnitID,
  SettlementReferenceDate,
  ReferenceQuantityUnit,
  CostAnalysisResource,
  SalesDistrict,
  SalesOrder,
  SalesOrderItem,
  SalesOrganization,
  Segment,
  ServiceDocumentType,
  ServiceDocument,
  ServiceDocumentItem,
  ServiceContractType,
  ServiceContract,
  ServiceContractItem,
  ShipToParty,
  SoldMaterial,
  SponsoredProgram,
  SponsoredClass,
  PartnerCompany,
  TransactionCurrency,
  WBSElement,
  WBSElementExternalID,
  WorkItem,
  AmountInTransactionCurrency AS PlanAmountInTransactionCrcy,
  FixedAmountInTransCrcy,
  AmountInCompanyCodeCurrency AS PlanAmountInCompanyCodeCrcy,
  FixedAmountInCoCodeCrcy,
  AmountInGlobalCurrency AS PlanAmountInGlobalCurrency,
  FixedAmountInGlobalCrcy,
  AmountInObjectCurrency AS PlanAmountInObjectCurrency,
  AmountInFunctionalCurrency AS PlanAmountInFunctionalCurrency,
  AmountInFreeDefinedCurrency1 AS PlanAmountInFreeDefinedCrcy1,
  AmountInFreeDefinedCurrency2 AS PlanAmountInFreeDefinedCrcy2,
  AmountInFreeDefinedCurrency3 AS PlanAmountInFreeDefinedCrcy3,
  AmountInFreeDefinedCurrency4 AS PlanAmountInFreeDefinedCrcy4,
  AmountInFreeDefinedCurrency5 AS PlanAmountInFreeDefinedCrcy5,
  AmountInFreeDefinedCurrency6 AS PlanAmountInFreeDefinedCrcy6,
  AmountInFreeDefinedCurrency7 AS PlanAmountInFreeDefinedCrcy7,
  AmountInFreeDefinedCurrency8 AS PlanAmountInFreeDefinedCrcy8,
  PlanPriceInTransactionCurrency,
  PlanPriceInCompanyCodeCurrency,
  PlanPriceInGlobalCurrency,
  ValuationQuantity,
  ValuationFixedQuantity,
  ReferenceQuantity
FROM I_ActualPlanJrnlEntryItemCube
;