I_PaytRequisitionLineItem

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_PaytRequisitionLineItem.
-- 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: IPAYTREQNLINEITM

CREATE VIEW I_PaytRequisitionLineItem AS
SELECT
  DocItem.CompanyCode AS CompanyCode,
  DocItem.AccountingDocument AS AccountingDocument,
  DocItem.FiscalYear AS FiscalYear,
  DocItem.AccountingDocumentItem AS AccountingDocumentItem,
  AccountingDocumentCategory,
  FinancialAccountType,
  NetDueDate,
  ItemType,
  DocItem.TransactionCurrency AS TransactionCurrency,
  DocItem.AmountInTransactionCurrency AS AmountInTransactionCurrency,
  TotalAmount.PaymentRequestAmountInPaytCrcy AS PaymentRequestAmountInPaytCrcy,
  case when ( DocItem.ClearingAccountingDocument <> '' and DocItem.ClearingIsReversed = '' ) then cast( ('0') as abap.curr( 23,2)) when TotalAmount.PaidAmountInPaytCurrency is null then DocItem.AmountInTransactionCurrency else cast( (DocItem.AmountInTransactionCurrency + TotalAmount.PaidAmountInPaytCurrency) as abap.curr( 23,2)) end as RemainingOpenAmtInDspCrcy AS curr232endasRemainingOpenAmtInDspCrcy,
  Supplier,
  SupplierBankType,
  cast( _Supplier.IsOneTimeAccount as farp_xcpdk ) AS SupplierIsOneTimeAccount,
  NetDueArrearsDays,
  ClearingStatus,
  DocumentDate,
  PostingDate,
  SpecialGLCode,
  PaymentMethod,
  _Supplier.PaymentIsBlockedForSupplier AS PaymentIsBlockedForSupplier,
  CostCenter,
  PurchasingDocument,
  PurchasingDocumentItem,
  SalesDocument,
  SalesDocumentItem,
  CashDiscount1DueDate,
  CashDiscount1Percent,
  CashDiscount1Days,
  CashDiscount2Percent,
  CashDiscount2Days,
  DueCalculationBaseDate,
  WBSElementInternalID,
  WBSElementExternalID,
  ControllingArea,
  ProfitCenter,
  BranchCode,
  DocumentItemText,
  AssignmentReference,
  PaymentBlockingReason,
  Reference1IDByBusinessPartner,
  Reference2IDByBusinessPartner,
  Reference3IDByBusinessPartner,
  _Supplier.SupplierName AS SupplierName,
  _Supplier.BPSupplierName AS BPSupplierName,
  _JournalEntry._CompanyCode.Country AS Country,
  _JournalEntry.AccountingDocCreatedByUser AS AccountingDocCreatedByUser
FROM P_PayReqnLineItems AS DocItem
LEFT OUTER JOIN I_Currency AS _TransactionCurrency ON TransactionCurrency = _TransactionCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_SpecialGLCodeText AS _SpecialGLCodeText ON FinancialAccountType = _SpecialGLCodeText.FinancialAccountType AND SpecialGLCode = _SpecialGLCodeText.SpecialGLCode AND _SpecialGLCodeText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON DocItem.Supplier = _Supplier.Supplier  -- association [0..1]
LEFT OUTER JOIN I_ProfitCenterText AS _ProfitCenterText ON ControllingArea = _ProfitCenterText.ControllingArea AND ProfitCenter = _ProfitCenterText.ProfitCenter  -- association [0..*]
LEFT OUTER JOIN I_CostCenterText AS _CostCenterText ON ControllingArea = _CostCenterText.ControllingArea AND CostCenter = _CostCenterText.CostCenter  -- association [0..*]
LEFT OUTER JOIN I_PaymentMethodText AS _PaymentMethodText ON Country = _PaymentMethodText.Country AND PaymentMethod = _PaymentMethodText.PaymentMethod  -- association [0..*]
;