R_JournalCaseProposalItemDraft

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 R_JournalCaseProposalItemDraft.
-- 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 R_JournalCaseProposalItemDraft AS
SELECT
  finiju_jeitm_d.journalcaseproposalitemuuid AS JournalCaseProposalItemUUID,
  finiju_jeitm_d.journalcaseuuid AS JournalCaseUUID,
  finiju_jeitm_d.journalcaseproposaluuid AS JournalCaseProposalUUID,
  finiju_jeitm_d.jrnlcaseprpsljournalentryitem AS JrnlCasePrpslJournalEntryItem,
  finiju_jeitm_d.companycode AS CompanyCode,
  finiju_jeitm_d.glaccount AS GLAccount,
  finiju_jeitm_d.documentitemtext AS DocumentItemText,
  finiju_jeitm_d.debitamountintranscrcy AS DebitAmountInTransCrcy,
  finiju_jeitm_d.creditamountintranscrcy AS CreditAmountInTransCrcy,
  finiju_jeitm_d.amountinlocalcurrency AS AmountInLocalCurrency,
  finiju_jeitm_d.amountinadditionalcurrency2 AS AmountInAdditionalCurrency2,
  finiju_jeitm_d.taxcode AS TaxCode,
  finiju_jeitm_d.taxjurisdiction AS TaxJurisdiction,
  finiju_jeitm_d.costcenter AS CostCenter,
  finiju_jeitm_d.profitcenter AS ProfitCenter,
  finiju_jeitm_d.orderid AS OrderID,
  finiju_jeitm_d.wbselement AS WBSElement,
  finiju_jeitm_d.valuedate AS ValueDate,
  finiju_jeitm_d.housebankaccount AS HouseBankAccount,
  finiju_jeitm_d.housebank AS HouseBank,
  finiju_jeitm_d.assignmentreference AS AssignmentReference,
  finiju_jeitm_d.partnercompany AS PartnerCompany,
  finiju_jeitm_d.postingkey AS PostingKey,
  finiju_jeitm_d.specialglcode AS SpecialGLCode,
  finiju_jeitm_d.absoluteamountintransaccrcy AS AbsoluteAmountInTransacCrcy,
  finiju_jeitm_d.taxiscalculatedautomatically AS TaxIsCalculatedAutomatically,
  finiju_jeitm_d.paymentblockingreason AS PaymentBlockingReason,
  finiju_jeitm_d.personnelnumber AS PersonnelNumber,
  finiju_jeitm_d.assettransactiontype AS AssetTransactionType,
  finiju_jeitm_d.purchasingdocument AS PurchasingDocument,
  finiju_jeitm_d.salesorder AS SalesOrder,
  finiju_jeitm_d.salesorderitem AS SalesOrderItem,
  finiju_jeitm_d.partnerfunctionalarea AS PartnerFunctionalArea,
  finiju_jeitm_d.partnerprofitcenter AS PartnerProfitCenter,
  finiju_jeitm_d.product AS Product,
  finiju_jeitm_d.distributionchannel AS DistributionChannel,
  finiju_jeitm_d.jointventureobjecttype AS JointVentureObjectType,
  finiju_jeitm_d.billtoparty AS BillToParty,
  finiju_jeitm_d.providercontract AS ProviderContract,
  finiju_jeitm_d.providercontractitem AS ProviderContractItem,
  finiju_jeitm_d.customernum AS CustomerNum,
  finiju_jeitm_d.transactioncurrency AS TransactionCurrency,
  finiju_jeitm_d.globalcurrency AS GlobalCurrency,
  finiju_jeitm_d.companycodecurrency AS CompanyCodeCurrency,
  finiju_jeitm_d.controllingarea AS ControllingArea,
  finiju_jeitm_d.chartofaccounts AS ChartOfAccounts,
  finiju_jeitm_d.draftentitycreationdatetime AS DraftEntityCreationDateTime,
  finiju_jeitm_d.draftentitylastchangedatetime AS DraftEntityLastChangeDateTime,
  finiju_jeitm_d.draftadministrativedatauuid AS DraftAdministrativeDataUUID,
  finiju_jeitm_d.draftentityoperationcode AS DraftEntityOperationCode,
  finiju_jeitm_d.hasactiveentity AS HasActiveEntity,
  finiju_jeitm_d.draftfieldchanges AS DraftFieldChanges,
  finiju_jeitm_d.dummy_incl_eew_cobl AS RFM_Dummy
FROM finiju_jeitm_d
LEFT OUTER JOIN E_JournalCaseProposalItemDraft AS _Extension ON JournalCaseProposalItemUUID = _Extension.JournalCaseProposalItemUUID  -- association [1..1]
;