P_CnsldtnJrnlEntryDraftItem

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 P_CnsldtnJrnlEntryDraftItem.
-- 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 P_CnsldtnJrnlEntryDraftItem AS
SELECT
  draftuuid AS DraftKey,
  parentdraftuuid AS ParentJrnlEntrDraftUUID,
  cast( fiscalyearforedit as fincs_fiscalyear preserving type ) AS FiscalYear,
  cast( consolidationdocumentnumber as fincs_group_jrnl_entry preserving type ) AS ConsolidationDocumentNumber,
  cast( consolidationledgerforedit as fincs_consolidationledger preserving type ) AS ConsolidationLedger,
  ConsolidationPostingItem,
  ConsolidationDimension,
  cast( glrecordtype as fincs_rrcty preserving type ) AS GLRecordType,
  ConsolidationVersion,
  TransactionCurrency,
  LocalCurrency,
  GroupCurrency,
  cast( baseunit as fincs_base_unit_doc preserving type ) AS BaseUnit,
  cast( fiscalperiod as fincs_poper preserving type ) AS FiscalPeriod,
  cast( company as fincs_company preserving type ) AS Company,
  ConsolidationUnit,
  PartnerConsolidationUnit,
  cast( consolidationchartofaccounts as fincs_itclg preserving type ) AS ConsolidationChartOfAccounts,
  cast( chartofaccounts as fincs_chartofaccounts preserving type ) AS ChartOfAccounts,
  cast( financialstatementitem as fincs_fsi_item preserving type ) AS FinancialStatementItem,
  cast( consolidationgroup as fincs_consolidationgroup preserving type ) AS ConsolidationGroup,
  ConsolidationUnit3,
  ConsolidationUnit1IsUsed,
  PartnerConsolidationUnit3,
  CompanyCode,
  cast( subitemcategory as fincs_subitemcategory preserving type ) AS SubItemCategory,
  cast( subitem as fincs_subitem preserving type ) AS SubItem,
  cast( postinglevel as fincs_plevl preserving type ) AS PostingLevel,
  cast( consolidationapportionment as fincs_rpflg preserving type ) AS ConsolidationApportionment,
  cast( currencyconversionsdifftype as fincs_rtflg preserving type ) AS CurrencyConversionsDiffType,
  cast( consolidationdocumenttype as fincs_docty preserving type ) AS ConsolidationDocumentType,
  cast( consolidationacquisitionyear as fincs_ryacq preserving type ) AS ConsolidationAcquisitionYear,
  cast( consolidationacquisitionperiod as fincs_rpacq preserving type ) AS ConsolidationAcquisitionPeriod,
  InvesteeConsolidationUnit,
  InvestorConsolidationUnit,
  cast( documentitemtext as fincs_sgtxt preserving type ) AS DocumentItemText,
  cast( consolidationpostgitemautoflag as fincs_autom preserving type ) AS ConsolidationPostgItemAutoFlag,
  cast( businesstransactiontype as fincs_glvor preserving type ) AS BusinessTransactionType,
  PostingDate,
  cast( currencytranslationdate as fincs_wsdat preserving type ) AS CurrencyTranslationDate,
  RefAccountingDocument,
  RefConsolidationDocumentnumber,
  ReferenceFiscalYear,
  RefConsolidationPostingItem,
  RefAccountingDocumentItem,
  RefConsolidationDocumentType,
  RefBusinessTransactionType,
  CreationDate,
  CreationTime,
  UserID,
  ReversedDocument,
  ReverseDocument,
  cast( investmentactivitytype as fincs_coiac preserving type ) AS InvestmentActivityType,
  cast( investmentactivity as fincs_coinr preserving type ) AS InvestmentActivity,
  cast( consolidationdocreversalyear as fincs_revyear preserving type ) AS ConsolidationDocReversalYear,
  cast( referencedocumenttype as fincs_awtyp preserving type ) AS ReferenceDocumentType,
  cast( referencedocumentcontext as fincs_aworg preserving type ) AS ReferenceDocumentContext,
  LogicalSystem,
  cast( glaccount as fincs_glaccount preserving type ) AS GLAccount,
  AssignmentReference,
  cast( costcenter as fincs_costcenter preserving type ) AS CostCenter,
  cast( profitcenter as fincs_profit_center preserving type ) AS ProfitCenter,
  cast( functionalarea as fincs_functionalarea preserving type ) AS FunctionalArea,
  cast( businessarea as fincs_businessarea preserving type ) AS BusinessArea,
  cast( controllingarea as fincs_controllingarea preserving type ) AS ControllingArea,
  cast( segment as fincs_segment preserving type ) AS Segment,
  cast( partnercostcenter as fincs_scntr preserving type ) AS PartnerCostCenter,
  cast( partnerprofitcenter as fincs_partnerprofitcenter preserving type ) AS PartnerProfitCenter,
  cast( partnerfunctionalarea as fincs_sfkber preserving type ) AS PartnerFunctionalArea,
  cast( partnerbusinessarea as fincs_pargb preserving type ) AS PartnerBusinessArea,
  cast( partnercompany as fincs_rassc preserving type ) AS PartnerCompany,
  cast( partnersegment as fincs_partnersegment preserving type ) AS PartnerSegment,
  cast( orderid as fincs_aufnr preserving type ) AS OrderID,
  cast( customer as fincs_customer preserving type ) AS Customer,
  cast( supplier as fincs_supplier preserving type ) AS Supplier,
  cast( material as fincs_material preserving type ) AS Material,
  cast( plant as fincs_plant preserving type ) AS Plant,
  cast( wbselementinternalid as ps_s4_pspnr preserving type ) AS WBSElementInternalID,
  cast( wbselementexternalid as ps_posid_edit preserving type ) AS WBSElementExternalID,
  cast( project as fincs_project_id preserving type ) AS Project,
  cast( billingdocumenttype as fincs_billingdocumenttype preserving type ) AS BillingDocumentType,
  cast( salesorganization as fincs_salesorganization preserving type ) AS SalesOrganization,
  cast( distributionchannel as fincs_distributionchannel preserving type ) AS DistributionChannel,
  cast( organizationdivision as fincs_spart preserving type ) AS OrganizationDivision,
  cast( soldmaterial as fincs_material preserving type ) AS SoldMaterial,
  cast( materialgroup as fincs_materialgroup preserving type ) AS MaterialGroup,
  cast( productgroup as fincs_productgroup preserving type ) AS ProductGroup,
  cast( customergroup as fincs_customergroup preserving type ) AS CustomerGroup,
  cast( customersuppliercountry as fincs_land1 preserving type ) AS CustomerSupplierCountry,
  cast( customersupplierindustry as fincs_brsch preserving type ) AS CustomerSupplierIndustry,
  cast( salesdistrict as fincs_salesdistrict preserving type ) AS SalesDistrict,
  cast( billtoparty as fincs_kunre preserving type ) AS BillToParty,
  cast( shiptoparty as fincs_kunwe preserving type ) AS ShipToParty,
  cast( customersuppliercorporategroup as fincs_konzs preserving type ) AS CustomerSupplierCorporateGroup,
  FinancialServicesProductGroup,
  FinancialServicesBranch,
  FinancialDataSource,
  FinancialManagementArea,
  Fund,
  PartnerFund,
  GrantID,
  CnsldtnCashLedgerChartOfAccts,
  CashLedgerAccount,
  GHGScope,
  GHGCategory,
  GHGScope2CalculationMethod,
  GHGScope2ContractualInstrument,
  SustainabilityModeOfTransport,
  GHGDataQualityCharacteristic,
  GHGEnergyClassification,
  GHGEnergyMix,
  GHGEnergySourcingType,
  cast( amountintransactioncurrency as fincs_tsl preserving type ) AS AmountInTransactionCurrency,
  cast( amountinlocalcurrency as fincs_hsl preserving type ) AS AmountInLocalCurrency,
  cast( amountingroupcurrency as fincs_ksl preserving type ) AS AmountInGroupCurrency,
  QuantityInBaseUnit
FROM fincsjrnlentri_d
;