I_RblPyblTransactionItem

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_RblPyblTransactionItem.
-- 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_RblPyblTransactionItem AS
SELECT
  transaction_item_uuid AS RblPyblTransactionItemUUID,
  is_obsolete AS RblPyblItemIsObsolete,
  transaction_uuid AS RblPyblTransactionUUID,
  previous_transaction_uuid AS RblPyblPreviousTransactionUUID,
  doc_id AS ReceivablePayableDocument,
  doc_item AS ReceivablePayableDocumentItem,
  doc_subitem AS RblPyblDocumentSubitem,
  oid AS ReceivablePayableItemOID,
  accounting_doc AS AccountingDocument,
  company_code AS CompanyCode,
  fiscal_year AS FiscalYear,
  doc_date AS DocumentDate,
  posting_date AS PostingDate,
  net_due_date AS NetDueDate,
  application AS ReceivablePayableApplication,
  account_type AS RblPyblAccountType,
  Supplier,
  Customer,
  business_partner AS BusinessPartner,
  contract_account AS ContractAccount,
  contract_id AS CAContract,
  contract_subap AS CASubApplication,
  amount AS AmountInTransactionCurrency,
  currency AS TransactionCurrency,
  payment_method_origin AS PaytMethRblPyblCodeOrigin,
  payment_method AS RblPyblPaymentMethod,
  cash_discount_base_amount AS CashDiscountBaseAmount,
  cash_discount1_date AS CashDiscount1DueDate,
  cash_discount2_date AS CashDiscount2DueDate,
  cash_discount1_rate AS CashDiscount1Percent,
  cash_discount2_rate AS CashDiscount2Percent,
  is_cleared AS RblPyblItemIsCleared,
  clearing_date AS ClearingDate,
  clearing_doc_id AS ClearingRblPyblDocument,
  clearing_reason AS RblPyblClearingReason,
  clearing_currency AS ClearingTransactionCurrency,
  clearing_base_amount AS ClrgBaseAmountInClrgTransCrcy,
  clearing_amount AS ClearingAmountInClrgTransCrcy,
  cash_discount_amount AS CashDiscountAmtInClrgTransCrcy,
  deduction_amount AS DeductionAmountInClrgTransCrcy,
  residual_amount AS ResidualAmountInClrgTransCrcy,
  posting_class_origin AS PostgClassfctnRblPyblCodeOrign,
  posting_class AS PostingClassification,
  posting_subclass_origin AS PostgSubclfnRblPyblCodeOrigin,
  posting_subclass AS PostingSubclassification,
  paying_company_code AS PayingCompanyCode,
  has_payment_order AS HasPaymentOrder,
  rec_financing_status AS ReceivableFinancingStatus,
  payment_indicator AS IsUsedInPaymentTransaction,
  text AS ReceivablePayableItemText,
  branch_account AS BranchAccount,
  sales_related_indicator AS IsSalesRelated,
  transaction_type AS RblPyblTransactionType,
  is_blocked_for_dunning AS RblPyblItemIsBlockedForDunning,
  dunning_block_start_date AS DunningBlockStartDate,
  dunning_block_end_date AS DunningBlockEndDate,
  is_blocked_for_payment AS RblPyblItemIsBlockedForPayment,
  payment_block_start_date AS PaymentBlockStartDate,
  payment_block_end_date AS PaymentBlockEndDate,
  ref_doc_log_sys AS ReferenceDocumentLogicalSystem,
  ref_doc_type AS ReferenceDocumentType,
  orig_ref_doc AS OriginalReferenceDocument,
  orig_doc_id AS OriginalRblPyblDocument,
  orig_doc_item AS OriginalRblPyblDocumentItem,
  orig_doc_subitem AS OriginalRblPyblDocumentSubitem,
  orig_item_amount AS OriglRblPyblItmAmtInOrigItmTC,
  orig_item_currency AS OriglItemTransactionCurrency,
  has_relations AS RblPyblItemHasRelations,
  related_doc_id AS RelatedRblPyblDocument,
  related_doc_item AS RelatedRblPyblDocumentItem,
  related_doc_subitem AS RelatedRblPyblDocumentSubitem,
  relation_type AS RblPyblDocumentRelationType,
  doc_ref AS RblPyblDocumentReference,
  altv_doc_ref AS RblPyblAltvDocumentReference,
  assignment_reference AS AssignmentReference,
  additional_ref_1 AS FirstRblPyblAddlReference,
  additional_ref_2 AS SecondRblPyblAddlReference,
  additional_ref_3 AS ThirdRblPyblAddlReference,
  doc_creation_user AS RblPyblDocCreatedByUser,
  doc_creation_date AS RblPyblDocCreationDate,
  doc_creation_time AS RblPyblDocCreationTime,
  created_at AS CreationDateTime,
  last_changed_at AS LastChangeDateTime,
  log_sys AS LogicalSystem,
  load_id AS ReceivablePayableLoadID,
  res_itm_predecessor_doc_id AS RsdlItmPredecessorDocument,
  res_itm_predecessor_doc_item AS RsdlItmPredecessorDocumentItem,
  is_reversal AS RblPyblDocumentIsReversal,
  is_reversed AS RblPyblDocumentIsReversed,
  reversal_doc_id AS ReversalRblPyblDocument,
  reversed_doc_id AS ReversedRblPyblDocument,
  sdm_version AS RblPyblItmSilentDtaMigrtnVers
FROM frp_trans_item
LEFT OUTER JOIN I_AccountingDocument AS _AccountingDocument ON CompanyCode = _AccountingDocument.CompanyCode AND FiscalYear = _AccountingDocument.FiscalYear AND AccountingDocument = _AccountingDocument.AccountingDocument  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartner AS _BusinessPartner ON BusinessPartner = _BusinessPartner.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_CASubApplication AS _CASubApplication ON CASubApplication = _CASubApplication.CASubApplication  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [1..1]
LEFT OUTER JOIN I_CompanyCode AS _PayingCompanyCode ON PayingCompanyCode = _PayingCompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_ContractAccountHeader AS _ContractAccount ON ContractAccount = _ContractAccount.ContractAccount  -- association [0..1]
LEFT OUTER JOIN I_ContractAccountPartner AS _ContractAccountPartner ON ContractAccount = _ContractAccountPartner.ContractAccount AND BusinessPartner = _ContractAccountPartner.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _TransactionCurrency ON TransactionCurrency = _TransactionCurrency.Currency  -- association [1..1]
LEFT OUTER JOIN I_Currency AS _ClearingTransactionCurrency ON ClearingTransactionCurrency = _ClearingTransactionCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _OriglItemTransactionCurrency ON OriglItemTransactionCurrency = _OriglItemTransactionCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _Customer ON Customer = _Customer.Customer  -- association [0..1]
LEFT OUTER JOIN I_CustomerCompany AS _CustomerCompany ON Customer = _CustomerCompany.Customer AND CompanyCode = _CustomerCompany.CompanyCode  -- 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_LogicalSystem AS _LogicalSystem ON LogicalSystem = _LogicalSystem.LogicalSystem  -- association [0..1]
LEFT OUTER JOIN I_LogicalSystem AS _RefDocumentLogicalSystem ON ReferenceDocumentLogicalSystem = _RefDocumentLogicalSystem.LogicalSystem  -- association [0..1]
LEFT OUTER JOIN I_ProviderContract AS _ProviderContract ON CASubApplication = 'P' AND CAContract = _ProviderContract.ProviderContract  -- association [0..1]
LEFT OUTER JOIN I_ReferenceDocumentType AS _ReferenceDocumentType ON ReferenceDocumentType = _ReferenceDocumentType.ReferenceDocumentType  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON Supplier = _Supplier.Supplier  -- association [0..1]
LEFT OUTER JOIN I_SupplierCompany AS _SupplierCompany ON Supplier = _SupplierCompany.Supplier AND CompanyCode = _SupplierCompany.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_User AS _RblPyblDocCreatedByUser ON RblPyblDocCreatedByUser = _RblPyblDocCreatedByUser.UserID  -- association [0..1]
;