C_OplAcctgDocItemCorrespnc

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 C_OplAcctgDocItemCorrespnc.
-- 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: COPLADICOR

CREATE VIEW C_OplAcctgDocItemCorrespnc AS
SELECT
  Item.CompanyCode AS CompanyCode,
  Item.FiscalYear AS FiscalYear,
  Item.AccountingDocument AS AccountingDocument,
  Item.AccountingDocumentItem AS AccountingDocumentItem,
  Item.PostingKey AS PostingKey,
  _PostingKeyWthSpclGLCodeTxt[1:Language = $session.system_language].PostingKeyName AS PostingKeyName,
  Item.GLAccount AS GLAccount,
  _GLAccountText[1:Language = $session.system_language].GLAccountName AS GLAccountName,
  _GLAccountText[1:Language = $session.system_language].GLAccountLongName AS GLAccountLongName,
  Item.Customer AS Customer,
  Item._Customer.CustomerName AS CustomerName,
  Item._Customer.CustomerFullName AS CustomerFullName,
  Item._Customer.AddressID AS CorrespncCustomerAddressID,
  Item.Supplier AS Supplier,
  Item._Supplier.SupplierName AS SupplierName,
  Item._Supplier.SupplierFullName AS SupplierFullName,
  Item._Supplier.AddressID AS SupplierAddressID,
  Item.AmountInCompanyCodeCurrency AS AmountInCompanyCodeCurrency,
  Item.CompanyCodeCurrency AS CompanyCodeCurrency,
  Item.AmountInTransactionCurrency AS AmountInTransactionCurrency,
  Item.TransactionCurrency AS TransactionCurrency,
  Item.DocumentItemText AS DocumentItemText,
  Item.ChartOfAccounts AS ChartOfAccounts,
  AccountingDocumentItemType,
  ClearingDate,
  ClearingCreationDate,
  ClearingJournalEntry AS ClearingAccountingDocument,
  Item.FinancialAccountType AS FinancialAccountType,
  Item.SpecialGLCode AS SpecialGLCode,
  SpecialGLTransactionType,
  DebitCreditCode,
  BusinessArea,
  PartnerBusinessArea,
  TaxCode,
  TaxCountry,
  WithholdingTaxCode,
  TaxType,
  TaxItemGroup,
  TransactionTypeDetermination,
  ValueDate,
  AssignmentReference,
  PartnerCompany,
  FinancialTransactionType,
  CorporateGroupAccount,
  PlanningLevel,
  ControllingArea,
  CostCenter,
  Project,
  OrderID,
  BillingDocument,
  SalesDocument,
  SalesDocumentItem,
  ScheduleLine,
  ServiceDocumentType,
  ServiceDocument,
  ServiceDocumentItem,
  MasterFixedAsset,
  FixedAsset,
  AssetTransactionType,
  AssetValueDate,
  PersonnelNumber,
  IsSalesRelated,
  LineItemDisplayIsEnabled,
  IsOpenItemManaged,
  IsNotCashDiscountLiable,
  IsAutomaticallyCreated,
  IsUsedInPaymentTransaction,
  OperationalGLAccount,
  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,
  Material,
  Product,
  Plant,
  PurchasingDocument,
  PurchasingDocumentItem,
  AccountAssignmentNumber,
  IsCompletelyDelivered,
  MaterialPriceControl,
  ValuationArea,
  InventoryValuationType,
  VATRegistration,
  DelivOfGoodsDestCountry,
  PaymentDifferenceReason,
  ProfitCenter,
  JointVenture,
  JointVentureCostRecoveryCode,
  JointVentureEquityGroup,
  TreasuryContractType,
  AssetContract,
  CashFlowType,
  TaxJurisdiction,
  RealEstateObject,
  SettlementReferenceDate,
  CommitmentItem,
  CostObject,
  ProjectNetwork,
  OrderInternalBillOfOperations,
  OrderIntBillOfOperationsItem,
  WBSElementInternalID,
  _WBSElementInternalIDText.WBSDescription AS WBSDescription,
  _I_WBSElementBasicData.WBSElementExternalID AS WBSElementExternalID,
  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,
  AccountsReceivableIsPledged,
  BusinessProcess,
  GrantID,
  FunctionalArea,
  CustomerIsInExecution,
  FundedProgram,
  ClearingJournalEntryFiscalYear AS ClearingDocFiscalYear,
  LedgerGLLineItem,
  Segment,
  PartnerSegment,
  PartnerFunctionalArea,
  HouseBankAccount,
  CostElement,
  PaymentServiceProvider,
  PaymentRefByPaytSrvcProvider,
  SEPAMandate,
  ReferenceDocumentType,
  OriginalReferenceDocument,
  ReferenceDocumentLogicalSystem,
  AccountingDocumentItemRef,
  FiscalPeriod,
  AccountingDocumentCategory,
  PostingDate,
  DocumentDate,
  AccountingDocumentType,
  NetDueDate,
  CashDiscount1DueDate,
  CashDiscount2DueDate,
  OffsettingAccount,
  OffsettingAccountType,
  OffsettingChartOfAccounts,
  PartnerFund,
  PartnerGrant,
  BudgetPeriod,
  PartnerBudgetPeriod,
  BranchCode,
  OplAcctgDocItmCntrySpcfcRef1,
  CashLedgerCompanyCode,
  CashLedgerAccount,
  PubSecBudgetAccountCoCode,
  PubSecBudgetAccount,
  TaxAmountInCoCodeCrcy,
  TaxBaseAmountInCoCodeCrcy,
  ValuationDiffAmtInCoCodeCrcy,
  CashDiscountAmtInCoCodeCrcy,
  InvoiceAmtInCoCodeCrcy,
  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,
  GLAccountAuthorizationGroup,
  SupplierBasicAuthorizationGrp,
  CustomerBasicAuthorizationGrp,
  AcctgDocTypeAuthorizationGroup,
  OrderType,
  SalesOrderType,
  AssetClass
FROM I_OperationalAcctgDocItem AS Item
LEFT OUTER JOIN I_PostingKeyWthSpclGLCodeTxt AS _PostingKeyWthSpclGLCodeTxt ON _PostingKeyWthSpclGLCodeTxt.PostingKey = Item.PostingKey AND _PostingKeyWthSpclGLCodeTxt.SpecialGLCode = Item.SpecialGLCode  -- association [*]
LEFT OUTER JOIN I_GLAccountText AS _GLAccountText ON _GLAccountText.ChartOfAccounts = Item.ChartOfAccounts AND _GLAccountText.GLAccount = Item.GLAccount  -- association [*]
LEFT OUTER JOIN I_WBSElementByInternalKey AS _WBSElementInternalIDText ON Item.WBSElementInternalID = _WBSElementInternalIDText.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_WBSElementBasicData AS _I_WBSElementBasicData ON Item.WBSElementInternalID = _I_WBSElementBasicData.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN C_CorrespondenceAddress AS _CustomerAddress ON CorrespncCustomerAddressID = _CustomerAddress.AddressID  -- association [0..1]
LEFT OUTER JOIN C_CorrespondenceAddress AS _SupplierAddress ON SupplierAddressID = _SupplierAddress.AddressID  -- association [0..1]
LEFT OUTER JOIN C_CorrespondenceItemNote AS _CorrespondenceItemNote ON CompanyCode = _CorrespondenceItemNote.CompanyCode AND FiscalYear = _CorrespondenceItemNote.FiscalYear AND AccountingDocument = _CorrespondenceItemNote.AccountingDocument AND AccountingDocumentItem = _CorrespondenceItemNote.AccountingDocumentItem  -- association [0..*]
LEFT OUTER JOIN E_OperationalAcctgDocItem AS _Extension ON CompanyCode = _Extension.CompanyCode AND FiscalYear = _Extension.FiscalYear AND AccountingDocument = _Extension.AccountingDocument AND AccountingDocumentItem = _Extension.AccountingDocumentItem  -- association [1]
;