C_AbpInvoice

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_AbpInvoice.
-- 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: CABPINVOICE

CREATE VIEW C_AbpInvoice AS
SELECT
  _PaymentProposalItem.PaymentDocument AS PaymentDocument,
  _PaymentProposalItem.FiscalYear AS FiscalYear,
  _PaymentProposalItem.AccountingDocumentItem AS AccountingDocumentItem,
  cast(_PaymentProposalItem.PaymentRunDate as farp_laufd) AS PaymentRunDate,
  _PaymentProposalItem.PaymentRunID AS PaymentRunID,
  cast(_PaymentProposalItem.PaymentRunIsProposal as farp_xvorl) AS PaymentRunIsProposal,
  cast(_PaymentProposalItem.PayingCompanyCode as farp_bnk_com_dzbukr) AS PayingCompanyCode,
  _PaymentProposalItem.CompanyCode AS CompanyCode,
  cast (_PaymentProposalItem.AccountingDocument as fis_belnr) AS AccountingDocument,
  cast(_CompanyCode.CompanyCodeName as farp_zbukrstxt) AS PayingCompanyCodeName,
  _PayeeCompanyCode.CompanyCodeName AS PayeeCompanyCodeName,
  cast(_PaymentProposalItem.AccountingDocumentType as fap_bpa_blart) AS AccountingDocumentType,
  _PaymentProposalItem.BusinessArea AS BusinessArea,
  cast(_PaymentProposalItem.CashDiscount2Percent as dzbd2p_farp) AS CashDiscount2Percent,
  _PaymentProposalItem.PaymentMethod AS PaymentMethod,
  cast(_PaymentProposalItem.DocumentDate as fis_bldat) AS DocumentDate,
  _PaymentProposalItem.PaymentTerms AS PaymentTerms,
  _PaymentProposalItem.PostingDate AS PostingDate,
  _PaymentProposalItem.SpecialGLCode AS SpecialGLCode,
  _PaymentProposalItem.DocumentItemText AS DocumentItemText,
  _PaymentProposalItem.GLAccount AS GLAccount,
  _PaymentProposalItem.DocumentReferenceID AS DocumentReferenceID,
  _PaymentProposalItem.DueCalculationBaseDate AS NetDueDate,
  _PaymentProposalItem.AssignmentReference AS AssignmentReference,
  _PaymentProposalItem.TaxCode AS TaxCode,
  cast(_PaymentProposalItem.CashDiscount1Percent as dzbd1p_farp) AS CashDiscount1Percent,
  cast(_PaymentProposalItem.Supplier as fap_bpa_lifnr) AS CustomerSupplierAccount,
  cast(_PaymentProposalItem.PaymentDocument as fap_bpa_clrdoc) AS CAClearingDocumentNumber,
  _PaymentProposalItem.PaymentRecipient AS PaymentRecipient,
  cast(_PaymentProposalItem.AmountInTransactionCurrency as fap_bpa_wrbtr) AS AmountInTransactionCurrency,
  cast(_PaymentProposalItem.TotDeductionAmtInTransacCrcy as fap_bpa_wskto) AS TotDeductionAmtInTransacCrcy,
  cast(_PaymentProposalItem.NetAmountInTransacCurrency as fap_abp_wnetv) AS NetAmountInTransacCurrency,
  cast(_PaymentProposalItem.PaymentCurrency as fap_bpa_rwcur) AS TransactionCurrency,
  cast(_PaymentProposalItem.HeaderAmtInCoCodeCurrency as farp_dmbtr) AS HeaderAmtInCoCodeCurrency,
  cast(_PaymentProposalItem.TotDeductionAmtInCoCodeCrcy as fap_bpa_sknto) AS TotDeductionAmtInCoCodeCrcy,
  cast(_PaymentProposalItem.NetAmountInCoCodeCurrency as fap_bpa_wnetwcc) AS NetAmountInCoCodeCurrency,
  cast(_PaymentProposalItem._CompanyCode.Currency as fap_bpa_waers) AS CompanyCodeCurrency,
  _Supplier.SupplierAccountGroup AS SupplierAccountGroup,
  _Supplier.AuthorizationGroup AS AuthorizationGroup
FROM I_PaymentProposalItem AS _PaymentProposalItem
LEFT OUTER JOIN I_Supplier AS _Supplier ON _Supplier.Supplier = _PaymentProposalItem.Supplier  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _PayeeCompanyCode ON CompanyCode = _PayeeCompanyCode.CompanyCode  -- association [0..1]
;