I_EmrkdFndsDocItmProcgItem

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_EmrkdFndsDocItmProcgItem.
-- 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_EmrkdFndsDocItmProcgItem AS
SELECT
  cast ( belnr as fmis_earmarkedfundsdoc preserving type ) AS EarmarkedFundsDocument,
  cast ( blpos as fmis_earmarkedfundsdocitem preserving type ) AS EarmarkedFundsDocumentItem,
  bpent AS EmrkdFndsDocItmProcgItem,
  rbukrs AS CompanyCode,
  vrgng AS BusinessTransactionType,
  erfas AS CreatedByUser,
  erdat AS CreationDate,
  aende AS LastChangedByUser,
  aedat AS LastChangeDate,
  awtyp AS ReferenceDocumentType,
  awref AS ReferenceDocument,
  aworg AS ReferenceDocumentContext,
  awsys AS ReferenceDocumentLogicalSystem,
  awpos AS ReferenceDocumentItem,
  cast ( rgjahr as fis_gjahr_no_conv preserving type ) AS FiscalYear,
  rbelnr AS AccountingDocument,
  rbuzei AS AccountingDocumentItem,
  rebeln AS PurchasingDocument,
  rebelp AS PurchasingDocumentItem,
  rzekkn AS AccountAssignmentNumber,
  retenr AS ScheduleLine,
  rbanfn AS PurchaseRequisition,
  rbnfpo AS PurchaseRequisitionItem,
  rzebkn AS PurchaseReqnAcctAssgmtNumber,
  stats AS EmrkdFndsItmProcgIsStatistical,
  stokz AS IsReversed,
  atext AS EarmarkedFundsDocItmProcgText,
  _EarmarkedFundsDocument.TransactionCurrency AS TransactionCurrency,
  wtabb AS EmrkdFndsProcgAmtInTransCrcy,
  _EmrkdFndsItmProcgAmtInCCCrcy.Currency AS CompanyCodeCurrency,
  cast( _EmrkdFndsItmProcgAmtInCCCrcy.EmrkdFndsCnsmdAmtInRoleCrcy as fmis_efd_amtincccrcy preserving type ) AS EmrkdFndsProcgAmtInCCCrcy
FROM kble
LEFT OUTER JOIN I_EarmarkedFundsDocument AS _EarmarkedFundsDocument ON EarmarkedFundsDocument = _EarmarkedFundsDocument.EarmarkedFundsDocument  -- association [1..1]
LEFT OUTER JOIN I_EmrkdFndsDocItmProcgCrcyAmt AS _EmrkdFndsItmProcgAmtInCCCrcy ON EarmarkedFundsDocument = _EmrkdFndsItmProcgAmtInCCCrcy.EarmarkedFundsDocument AND EarmarkedFundsDocumentItem = _EmrkdFndsItmProcgAmtInCCCrcy.EarmarkedFundsDocumentItem AND EmrkdFndsDocItmProcgItem = _EmrkdFndsItmProcgAmtInCCCrcy.EmrkdFndsDocItmProcgItem AND _EmrkdFndsItmProcgAmtInCCCrcy.CurrencyRole = '10'  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _TransactionCurrency ON TransactionCurrency = _TransactionCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_ReferenceDocumentType AS _ReferenceDocumentType ON ReferenceDocumentType = _ReferenceDocumentType.ReferenceDocumentType  -- association [0..1]
LEFT OUTER JOIN I_ReferenceDocumentTypeText AS _ReferenceDocumentTypeText ON ReferenceDocumentType = _ReferenceDocumentTypeText.ReferenceDocumentType  -- association [0..*]
LEFT OUTER JOIN I_ControllingBusTransacType AS _ControllingBusTransacType ON BusinessTransactionType = _ControllingBusTransacType.BusinessTransactionType  -- association [0..1]
LEFT OUTER JOIN I_User AS _CreatedByUser ON CreatedByUser = _CreatedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_User AS _LastChangedByUser ON LastChangedByUser = _LastChangedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_LogicalSystem AS _RefDocumentLogicalSystem ON ReferenceDocumentLogicalSystem = _RefDocumentLogicalSystem.LogicalSystem  -- association [0..1]
LEFT OUTER JOIN I_JournalEntry AS _JournalEntry ON CompanyCode = _JournalEntry.CompanyCode AND FiscalYear = _JournalEntry.FiscalYear AND AccountingDocument = _JournalEntry.AccountingDocument  -- association [0..1]
LEFT OUTER JOIN I_FiscalYearForCompanyCode AS _FiscalYear ON FiscalYear = _FiscalYear.FiscalYear AND CompanyCode = _FiscalYear.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_Purchaserequisition AS _PurchaseRequisition ON PurchaseRequisition = _PurchaseRequisition.PurchaseRequisition  -- association [0..1]
LEFT OUTER JOIN I_Purchaserequisitionitem AS _PurchaseRequisitionItem ON PurchaseRequisition = _PurchaseRequisitionItem.PurchaseRequisition AND PurchaseRequisitionItem = _PurchaseRequisitionItem.PurchaseRequisitionItem  -- association [0..1]
LEFT OUTER JOIN I_PurReqnAcctAssgmt AS _PurReqnAcctAssgmt ON PurchaseRequisition = _PurReqnAcctAssgmt.PurchaseRequisition AND PurchaseRequisitionItem = _PurReqnAcctAssgmt.PurchaseRequisitionItem AND PurchaseReqnAcctAssgmtNumber = _PurReqnAcctAssgmt.PurchaseReqnAcctAssgmtNumber  -- association [0..1]
LEFT OUTER JOIN I_PurchasingDocument AS _PurchasingDocument ON PurchasingDocument = _PurchasingDocument.PurchasingDocument  -- association [0..1]
LEFT OUTER JOIN I_PurchasingDocumentItem AS _PurchasingDocumentItem ON PurchasingDocument = _PurchasingDocumentItem.PurchasingDocument AND PurchasingDocumentItem = _PurchasingDocumentItem.PurchasingDocumentItem  -- association [0..1]
LEFT OUTER JOIN I_PurgDocAccountAssignment AS _PurgDocAccountAssignment ON PurchasingDocument = _PurgDocAccountAssignment.PurchasingDocument AND PurchasingDocumentItem = _PurgDocAccountAssignment.PurchasingDocumentItem AND AccountAssignmentNumber = _PurgDocAccountAssignment.AccountAssignmentNumber  -- association [0..1]
LEFT OUTER JOIN I_PurgDocScheduleLine AS _ScheduleLine ON PurchasingDocument = _ScheduleLine.PurchasingDocument AND PurchasingDocumentItem = _ScheduleLine.PurchasingDocumentItem AND ScheduleLine = _ScheduleLine.ScheduleLine  -- association [0..1]
;