P_DebtorCreditorRblsPyblsItem

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 P_DebtorCreditorRblsPyblsItem.
-- 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: PDRCRRBPAYITM

CREATE VIEW P_DebtorCreditorRblsPyblsItem AS
SELECT
  I_OperationalAcctgDocItem.CompanyCode AS CompanyCode,
  I_OperationalAcctgDocItem.AccountingDocument AS AccountingDocument,
  I_OperationalAcctgDocItem.FiscalYear AS FiscalYear,
  I_OperationalAcctgDocItem.AccountingDocumentItem AS AccountingDocumentItem,
  ChartOfAccounts,
  AccountingDocumentItemType,
  ClearingDate,
  ClearingCreationDate,
  ClearingAccountingDocument,
  ClearingDocFiscalYear,
  ClearingJournalEntry,
  ClearingJournalEntryFiscalYear,
  PostingKey,
  FinancialAccountType,
  SpecialGLCode,
  SpecialGLTransactionType,
  DebitCreditCode,
  BusinessArea,
  PartnerBusinessArea,
  TaxCode,
  WithholdingTaxCode,
  TaxType,
  TaxItemGroup,
  TransactionTypeDetermination,
  ValueDate,
  AssignmentReference,
  DocumentItemText,
  PartnerCompany,
  FinancialTransactionType,
  CorporateGroupAccount,
  PlanningLevel,
  ControllingArea,
  CostCenter,
  Project,
  OrderID,
  BillingDocument,
  SalesDocument,
  SalesDocumentItem,
  ScheduleLine,
  MasterFixedAsset,
  FixedAsset,
  AssetTransactionType,
  AssetValueDate,
  PersonnelNumber,
  IsSalesRelated,
  LineItemDisplayIsEnabled,
  IsOpenItemManaged,
  IsNotCashDiscountLiable,
  IsAutomaticallyCreated,
  IsUsedInPaymentTransaction,
  OperationalGLAccount,
  GLAccount,
  Customer,
  Supplier,
  BranchAccount,
  IsBalanceSheetAccount,
  ProfitLossAccountType,
  SpecialGLAccountAssignment,
  DueCalculationBaseDate,
  PaymentTerms,
  CashDiscount1Days,
  CashDiscount2Days,
  NetPaymentDays,
  CashDiscount1Percent,
  CashDiscount2Percent,
  PaymentMethod,
  PaymentBlockingReason,
  FixedCashDiscount,
  HouseBank,
  BPBankAccountInternalID,
  TaxDistributionCode1,
  TaxDistributionCode2,
  TaxDistributionCode3,
  InvoiceReference,
  InvoiceReferenceFiscalYear,
  InvoiceItemReference,
  FollowOnDocumentType,
  StateCentralBankPaymentReason,
  SupplyingCountry,
  InvoiceList,
  BillOfExchangeUsage,
  DunningKey,
  DunningBlockingReason,
  LastDunningDate,
  DunningLevel,
  DunningArea,
  WithholdingTaxCertificate,
  Product,
  Material,
  Plant,
  PurchasingDocument,
  PurchasingDocumentItem,
  AccountAssignmentNumber,
  IsCompletelyDelivered,
  MaterialPriceControl,
  ValuationArea,
  InventoryValuationType,
  VATRegistration,
  DelivOfGoodsDestCountry,
  PaymentDifferenceReason,
  ProfitCenter,
  JointVenture,
  JointVentureCostRecoveryCode,
  JointVentureEquityGroup,
  TreasuryContractType,
  AssetContract,
  CashFlowType,
  TaxJurisdiction,
  REInternalFinNumber,
  RealEstateObject,
  SettlementReferenceDate,
  CommitmentItemShortID,
  CommitmentItem,
  CostObject,
  ProjectNetwork,
  OrderInternalBillOfOperations,
  OrderIntBillOfOperationsItem,
  WBSElementInternalID,
  ProfitabilitySegment_2 AS ProfitabilitySegment,
  JointVentureEquityType,
  IsEUTriangularDeal,
  CostOriginGroup,
  CompanyCodeCurrencyDetnMethod,
  ClearingIsReversed,
  PaymentMethodSupplement,
  AlternativeGLAccount,
  FundsCenter,
  Fund,
  PartnerProfitCenter,
  Reference1IDByBusinessPartner,
  Reference2IDByBusinessPartner,
  EarmarkedFundsDocument,
  EarmarkedFundsDocumentItem,
  IsNegativePosting,
  PaymentCardItem,
  PaymentCardPaymentSettlement,
  CreditControlArea,
  Reference3IDByBusinessPartner,
  DataExchangeInstruction1,
  DataExchangeInstruction2,
  DataExchangeInstruction3,
  DataExchangeInstruction4,
  Region,
  HasPaymentOrder,
  PaymentReference,
  TaxDeterminationDate,
  ClearingItem,
  BusinessPlace,
  TaxSection,
  CostCtrActivityType,
  AcctsReceivablePledgingCode,
  AccountsReceivableIsPledged,
  BusinessProcess,
  GrantID,
  FunctionalArea,
  CustomerIsInExecution,
  FundedProgram,
  LedgerGLLineItem,
  Segment,
  PartnerSegment,
  PartnerFunctionalArea,
  HouseBankAccount,
  CostElement,
  SEPAMandate,
  ReferenceDocumentType,
  OriginalReferenceDocument,
  ReferenceDocumentLogicalSystem,
  AccountingDocumentItemRef,
  FiscalPeriod,
  AccountingDocumentCategory,
  PostingDate,
  DocumentDate,
  AccountingDocumentType,
  NetDueDate,
  CashDiscount1DueDate,
  CashDiscount2DueDate,
  OffsettingAccount,
  OffsettingAccountType,
  PartnerFund,
  PartnerGrant,
  BudgetPeriod,
  PartnerBudgetPeriod,
  BranchCode,
  CompanyCodeCurrency,
  AmountInCompanyCodeCurrency,
  TaxAmountInCoCodeCrcy,
  TaxBaseAmountInCoCodeCrcy,
  ValuationDiffAmtInCoCodeCrcy,
  CashDiscountAmtInCoCodeCrcy,
  InvoiceAmtInCoCodeCrcy,
  TransactionCurrency,
  AmountInTransactionCurrency,
  OriginalTaxBaseAmount,
  TaxAmount,
  TaxBaseAmountInTransCrcy,
  WithholdingTaxBaseAmount,
  PlannedAmtInTransactionCrcy,
  CashDiscountBaseAmount,
  CashDiscountAmount,
  NetPaymentAmount,
  WithholdingTaxAmount,
  WithholdingTaxExemptionAmt,
  InvoiceAmountInFrgnCurrency,
  BalanceTransactionCurrency,
  AmountInBalanceTransacCrcy,
  AdditionalCurrency1,
  ValuationDiffAmtInAddlCrcy1,
  AmountInAdditionalCurrency1,
  AdditionalCurrency2,
  AmountInAdditionalCurrency2,
  ValuationDiffAmtInAddlCrcy2,
  PaymentCurrency,
  AmountInPaymentCurrency,
  CreditControlAreaCurrency,
  HedgedAmount,
  BaseUnit,
  Quantity,
  GoodsMovementEntryUnit,
  QuantityInEntryUnit,
  PurchasingDocumentPriceUnit,
  PurchaseOrderQty,
  MaterialPriceUnitQty,
  NumberOfItems
FROM I_OperationalAcctgDocItem
INNER JOIN P_FirstDbtrCrdtrRblsPyblsItem ON /* join condition not captured in parsed metadata */
;