I_JournalCaseProposalItem

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 I_JournalCaseProposalItem.
-- 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 I_JournalCaseProposalItem AS
SELECT
  jeitm_uuid AS JournalCaseProposalItemUUID,
  case_uuid AS JournalCaseUUID,
  jehdr_uuid AS JournalCaseProposalUUID,
  iju_jeitemid AS JrnlCasePrpslJournalEntryItem,
  bukrs AS CompanyCode,
  hkont AS GLAccount,
  sgtxt AS DocumentItemText,
  wrsol AS DebitAmountInTransCrcy,
  wrhab AS CreditAmountInTransCrcy,
  dmbtr AS AmountInLocalCurrency,
  dmbe2 AS AmountInAdditionalCurrency2,
  mwskz AS TaxCode,
  txjcd AS TaxJurisdiction,
  kostl AS CostCenter,
  prctr AS ProfitCenter,
  aufnr AS OrderID,
  cast(ps_posid as fis_wbs_no_conv preserving type ) AS WBSElement,
  valut AS ValueDate,
  hbkid AS HouseBankAccount,
  hktid AS HouseBank,
  zuonr AS AssignmentReference,
  vbund AS PartnerCompany,
  newbs AS PostingKey,
  newum AS SpecialGLCode,
  wrbtr AS AbsoluteAmountInTransacCrcy,
  xmwst AS TaxIsCalculatedAutomatically,
  zlspr AS PaymentBlockingReason,
  pernr AS PersonnelNumber,
  newbw AS AssetTransactionType,
  ebeln AS PurchasingDocument,
  kaufn AS SalesOrder,
  kdpos AS SalesOrderItem,
  fkber AS PartnerFunctionalArea,
  pprct AS PartnerProfitCenter,
  artnr AS Product,
  vtweg AS DistributionChannel,
  otype AS JointVentureObjectType,
  kunre AS BillToParty,
  wwprc AS ProviderContract,
  wwpci AS ProviderContractItem,
  kndnr AS CustomerNum,
  rwcur AS TransactionCurrency,
  rkcur AS GlobalCurrency,
  rhcur AS CompanyCodeCurrency,
  kokrs AS ControllingArea,
  ktopl AS ChartOfAccounts,
  _ControllingAreaText.ControllingAreaName AS ControllingAreaName,
  _CostCenterTxt[1: Language=$session.system_language].CostCenterName AS CostCenterName,
  _TaxCodeText[1: Language=$session.system_language].TaxCodeName AS TaxCodeName,
  _HouseBankAccountText[1: Language=$session.system_language].HouseBankAccountDescription AS HouseBankAccountDescription,
  _HouseBankText[1: Language=$session.system_language].HouseBankName AS HouseBankName,
  _PartnerCompanyText.CompanyCodeName AS PartnerCompanyCodeName,
  _AssetTransactionTypeText[1: Language=$session.system_language].AssetTransactionTypeName AS AssetTransactionTypeName,
  _PartnerFunctionalAreaText[1: Language=$session.system_language].FunctionalAreaName AS PartnerFunctionalAreaName,
  _DistributionChannelText[1: Language=$session.system_language].DistributionChannelName AS DistributionChannelName,
  _BillToParty.CustomerName AS BillToPartyName,
  _GLAccountText[1: Language=$session.system_language].GLAccountName AS GLAccountName,
  _PostingKey[1: Language=$session.system_language].PostingKeyName AS PostingKeyName
FROM finiju_casejeitm
LEFT OUTER JOIN I_GLAccountText AS _GLAccountText ON ChartOfAccounts = _GLAccountText.ChartOfAccounts AND GLAccount = _GLAccountText.GLAccount  -- association [0..*]
LEFT OUTER JOIN I_TaxCodeText AS _TaxCodeText ON TaxCode = _TaxCodeText.TaxCode  -- association [0..*]
LEFT OUTER JOIN I_HouseBankAccountText AS _HouseBankAccountText ON CompanyCode = _HouseBankAccountText.CompanyCode AND HouseBank = _HouseBankAccountText.HouseBank AND HouseBankAccount = _HouseBankAccountText.HouseBankAccount  -- association [0..*]
LEFT OUTER JOIN I_HouseBankText AS _HouseBankText ON CompanyCode = _HouseBankText.CompanyCode AND HouseBank = _HouseBankText.HouseBank  -- association [0..*]
LEFT OUTER JOIN I_CompanyCode AS _PartnerCompanyText ON CompanyCode = _PartnerCompanyText.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_ControllingArea AS _ControllingAreaText ON ControllingArea = _ControllingAreaText.ControllingArea  -- association [0..1]
LEFT OUTER JOIN I_CostCenterText AS _CostCenterTxt ON ControllingArea = _CostCenterTxt.ControllingArea AND CostCenter = _CostCenterTxt.CostCenter AND ValueDate = _CostCenterTxt.ValidityEndDate  -- association [0..*]
LEFT OUTER JOIN I_AssetTransactionTypeText AS _AssetTransactionTypeText ON AssetTransactionType = _AssetTransactionTypeText.AssetTransactionType  -- association [0..*]
LEFT OUTER JOIN I_FunctionalAreaText AS _PartnerFunctionalAreaText ON PartnerFunctionalArea = _PartnerFunctionalAreaText.FunctionalArea  -- association [0..*]
LEFT OUTER JOIN I_DistributionChannelText AS _DistributionChannelText ON DistributionChannel = _DistributionChannelText.DistributionChannel  -- association [0..*]
LEFT OUTER JOIN I_Customer AS _BillToParty ON BillToParty = _BillToParty.Customer  -- association [0..1]
LEFT OUTER JOIN I_JournalCase AS _JournalCase ON JournalCaseUUID = _JournalCase.JournalCaseUUID  -- association [0..1]
LEFT OUTER JOIN I_PostingKeyText AS _PostingKey ON PostingKey = _PostingKey.PostingKey  -- association [0..*]
LEFT OUTER JOIN E_JournalCaseProposalItem AS _ExtensionItem ON JournalCaseProposalItemUUID = _ExtensionItem.JournalCaseProposalItemUUID  -- association [1..1]
;