P_ReceivablesItem1

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_ReceivablesItem1.
-- 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: PFIRECITEM1

CREATE VIEW P_ReceivablesItem1 AS
SELECT
  CompanyCode,
  AccountingDocument,
  FiscalYear,
  AccountingDocumentItem,
  cast( concat(concat(CompanyCode, AccountingDocument), concat(FiscalYear, AccountingDocumentItem)) as swo_typeid ) AS DisputeCaseObjectKey,
  FiscalYearVariant,
  ClearingDate,
  ClearingCreationDate,
  ClearingAccountingDocument,
  PostingKey,
  FinancialAccountType,
  SpecialGLCode,
  SpecialGLTransactionType,
  TargetSpecialGLCode,
  DebitCreditCode,
  BusinessArea,
  PartnerBusinessArea,
  TaxCode,
  WithholdingTaxCode,
  AmountInCompanyCodeCurrency,
  AmountInTransactionCurrency,
  AmountInBalanceTransacCrcy,
  BalanceTransactionCurrency,
  TaxAmountInCoCodeCrcy,
  TaxAmount,
  TaxBaseAmountInTransCrcy,
  TaxBaseAmountInCoCodeCrcy,
  TaxType,
  TaxItemGroup,
  TransactionTypeDetermination,
  WithholdingTaxBaseAmount,
  ValuationDiffAmtInCoCodeCrcy,
  ValuationDiffAmtInAddlCrcy1,
  ValueDate,
  AssignmentReference,
  DocumentItemText,
  PartnerCompany,
  FinancialTransactionType,
  CorporateGroupAccount,
  PlanningLevel,
  PlannedAmtInTransactionCrcy,
  ControllingArea,
  CostCenter,
  OrderID,
  BillingDocument,
  SalesDocument,
  SalesDocumentItem,
  ScheduleLine,
  MasterFixedAsset,
  FixedAsset,
  AssetTransactionType,
  IsSalesRelated,
  LineItemDisplayIsEnabled,
  IsOpenItemManaged,
  AddressAndBankIsSetManually,
  IsAutomaticallyCreated,
  IsUsedInPaymentTransaction,
  GLAccount,
  Debtor,
  Creditor,
  IsBalanceSheetAccount,
  ProfitLossAccountType,
  SpecialGLAccountAssignment,
  DueCalculationBaseDate,
  PaymentTerms,
  CashDiscount1Days,
  CashDiscount2Days,
  NetPaymentDays,
  CashDiscount1Percent,
  CashDiscount2Percent,
  CashDiscountBaseAmount,
  CashDiscountAmtInCoCodeCrcy,
  CashDiscountAmount,
  PaymentMethod,
  PaymentBlockingReason,
  FixedCashDiscount,
  HouseBank,
  TaxDistributionCode1,
  TaxDistributionCode2,
  TaxDistributionCode3,
  InvoiceReference,
  InvoiceReferenceFiscalYear,
  InvoiceItemReference,
  FollowOnDocumentType,
  SupplyingCountry,
  InvoiceList,
  SettlementFiscalYearPeriod,
  BillOfExchangeUsage,
  DunningKey,
  DunningBlockingReason,
  LastDunningDate,
  DunningLevel,
  DunningArea,
  WithholdingTaxAmount,
  WithholdingTaxExemptionAmt,
  Material,
  Plant,
  Quantity,
  BaseUnit,
  QuantityInEntryUnit,
  EntryUnit,
  PurchaseOrderQty,
  PurchaseOrderPriceUnit,
  PurchasingDocument,
  PurchasingDocumentItem,
  AccountAssignmentNumber,
  IsCompletelyDelivered,
  MaterialPriceControl,
  MaterialPriceUnitQty,
  ValuationArea,
  InventoryValuationType,
  InvoiceAmtInCoCodeCrcy,
  InvoiceAmountInFrgnCurrency,
  VATRegistration,
  DelivOfGoodsDestCountry,
  DelivOfGoodsOriginCountry,
  PaymentDifferenceReason,
  ProfitCenter,
  JointVenture,
  JointVentureCostRecoveryCode,
  JointVentureEquityGroup,
  TreasuryContractType,
  AssetContract,
  CashFlowType,
  TaxJurisdiction,
  RealEstateObject,
  SettlementReferenceDate,
  CostObject,
  ProjectNetwork,
  WBSElement,
  ProfitabilitySegment,
  JointVentureEquityType,
  IsEUTriangularDeal,
  CostOriginGroup,
  AmountInAdditionalCurrency1,
  AmountInAdditionalCurrency2,
  ValuationDiffAmtInAddlCrcy2,
  ClearingIsReversed,
  PaymentMethodSupplement,
  AlternativeGLAccount,
  FundsCenter,
  Fund,
  PartnerProfitCenter,
  Reference1IDByBusinessPartner,
  Reference2IDByBusinessPartner,
  PaymentCardItem,
  PaymentCardPaymentSettlement,
  CreditControlArea,
  Reference3IDByBusinessPartner,
  DataExchangeInstruction1,
  DataExchangeInstruction2,
  DataExchangeInstruction3,
  DataExchangeInstruction4,
  Region,
  HasPaymentOrder,
  PaymentReference,
  HedgedAmount,
  TaxDeterminationDate,
  ClearingItem,
  PaymentCurrency,
  AmountInPaymentCurrency,
  BusinessPlace,
  TaxSection,
  CostCtrActivityType,
  AccountsReceivableIsPledged,
  BusinessProcess,
  GrantID,
  FunctionalArea,
  CustomerIsInExecution,
  ClearingDocFiscalYear,
  Segment,
  PartnerSegment,
  PartnerFunctionalArea,
  HouseBankAccount,
  CostElement,
  ReferenceDocumentType,
  OriginalReferenceDocument,
  ReferenceDocumentLogicalSystem,
  FiscalPeriod,
  AccountingDocumentCategory,
  PostingDate,
  DocumentDate,
  TransactionCurrency,
  AccountingDocumentType,
  CompanyCodeCurrency,
  AdditionalCurrency1,
  AdditionalCurrency2,
  NetDueDate,
  CashDiscount1DueDate,
  CashDiscount2DueDate,
  OffsettingAccount,
  OffsettingAccountType,
  PartnerFund,
  PartnerGrant,
  BudgetPeriod,
  PartnerBudgetPeriod,
  BPBankAccountInternalID
FROM I_ReceivablesPayablesItem
;