C_FinInvoiceItemFDP

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_FinInvoiceItemFDP.
-- 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 C_FinInvoiceItemFDP AS
SELECT
  Item.CompanyCode AS CompanyCode,
  Item.FiscalYear AS FiscalYear,
  Item.AccountingDocument AS AccountingDocument,
  Item.AccountingDocumentItem AS AccountingDocumentItem,
  Item.AccountingDocumentItemType AS AccountingDocumentItemType,
  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,
  _Customer.CustomerName AS CustomerName,
  _Customer.CustomerFullName AS CustomerFullName,
  _Customer.IsOneTimeAccount AS IsOneTimeAccount,
  _Customer.AlternativePayeeIsAllowed AS AlternativePayeeIsAllowed,
  _Customer.AlternativePayerAccount AS AlternativePayerAccount,
  Item.Supplier AS Supplier,
  _Supplier.SupplierName AS SupplierName,
  _Supplier.SupplierFullName AS SupplierFullName,
  Item.ClearingDate AS ClearingDate,
  Item.ClearingDocFiscalYear AS ClearingDocFiscalYear,
  Item.ClearingJournalEntry AS ClearingJournalEntry,
  Item.FinancialAccountType AS FinancialAccountType,
  Item.SpecialGLCode AS SpecialGLCode,
  Item.SpecialGLTransactionType AS SpecialGLTransactionType,
  Item.BaseUnit AS BaseUnit,
  Item.Quantity AS Quantity,
  cast('' as mseh3 ) AS UnitOfMeasure_E,
  Item.DebitCreditCode AS DebitCreditCode,
  Item.FiscalPeriod AS FiscalPeriod,
  Item.TransactionTypeDetermination AS TransactionTypeDetermination,
  Item.DocumentItemText AS DocumentItemText,
  Item.Product AS Product,
  Item.Plant AS Plant,
  Item.ValuationArea AS ValuationArea,
  Item.InventoryValuationType AS InventoryValuationType,
  Item.DueCalculationBaseDate AS DueCalculationBaseDate,
  Item.PaymentTerms AS PaymentTerms,
  _PaymentTerm.PaymentIsInstallment AS PaymentIsInstallment,
  _PaymentTermText[1:Language = $session.system_language].PaymentTermsName AS PaymentTermsName,
  _PaymentTermText[1:Language = $session.system_language].PaymentTermsDescription AS PaymentTermsDescription,
  Item.CashDiscount1Days AS CashDiscount1Days,
  Item.CashDiscount2Days AS CashDiscount2Days,
  cast( '00000000' as farp_sk1dt ) AS CashDiscount1DueDate,
  cast( '00000000' as farp_sk2dt ) AS CashDiscount2DueDate,
  Item.NetPaymentDays AS NetPaymentDays,
  cast( '00000000' as farp_netdt ) AS NetDueDate,
  Item.CashDiscount1Percent AS CashDiscount1Percent,
  Item.CashDiscount2Percent AS CashDiscount2Percent,
  Item.VATRegistration AS VATRegistration,
  Item.InvoiceReference AS InvoiceReference,
  Item.InvoiceReferenceFiscalYear AS InvoiceReferenceFiscalYear,
  Item.FollowOnDocumentType AS FollowOnDocumentType,
  Item.InvoiceItemReference AS InvoiceItemReference,
  Item.GoodsMovementEntryUnit AS GoodsMovementEntryUnit,
  Item.QuantityInEntryUnit AS QuantityInEntryUnit,
  Item.DelivOfGoodsDestCountry AS DelivOfGoodsDestCountry,
  Item.DelivOfGoodsOriginCountry AS DelivOfGoodsOriginCountry,
  Item.TaxCountry AS TaxCountry,
  Item.TaxCode AS TaxCode,
  Item.TaxType AS TaxType,
  Item.TaxItemGroup AS TaxItemGroup,
  Item.TaxRateValidityStartDate AS TaxRateValidityStartDate,
  Item.TaxDeterminationDate AS TaxDeterminationDate,
  Item.WithholdingTaxCode AS WithholdingTaxCode,
  Item.TransactionCurrency AS TransactionCurrency,
  Item.AmountInTransactionCurrency AS AmountInTransactionCurrency,
  Item.CompanyCodeCurrency AS CompanyCodeCurrency,
  Item.AmountInCompanyCodeCurrency AS AmountInCompanyCodeCurrency,
  Item.BalanceTransactionCurrency AS BalanceTransactionCurrency,
  Item.AmountInBalanceTransacCrcy AS AmountInBalanceTransacCrcy,
  Item.OriglTaxBaseAmountInCoCodeCrcy AS OriglTaxBaseAmountInCoCodeCrcy,
  Item.OriginalTaxBaseAmount AS OriginalTaxBaseAmount,
  Item.TaxAmountInCoCodeCrcy AS TaxAmountInCoCodeCrcy,
  Item.TaxAmount AS TaxAmount,
  Item.TaxBaseAmountInCoCodeCrcy AS TaxBaseAmountInCoCodeCrcy,
  Item.TaxBaseAmountInTransCrcy AS TaxBaseAmountInTransCrcy,
  Item.WithholdingTaxBaseAmount AS WithholdingTaxBaseAmount,
  Item.ChartOfAccounts AS ChartOfAccounts,
  Item.ServiceDocumentType AS ServiceDocumentType,
  Item.MasterFixedAsset AS MasterFixedAsset,
  Item.AccountingDocumentType AS AccountingDocumentType,
  Item.IsSalesRelated AS IsSalesRelated,
  Item.IsOpenItemManaged AS IsOpenItemManaged,
  Item.AddressAndBankIsSetManually AS AddressAndBankIsSetManually,
  Item.ServiceDocument AS ServiceDocument,
  Item.FixedAsset AS FixedAsset,
  Item.PostingDate AS PostingDate,
  Item.OrderID AS OrderID,
  Item.SalesDocument AS SalesDocument,
  Item.FunctionalArea AS FunctionalArea,
  Item.CostCenter AS CostCenter,
  Item.ControllingArea AS ControllingArea,
  Item.Segment AS Segment,
  Item.ProfitCenter AS ProfitCenter,
  Item._Customer AS _Customer,
  Item._Supplier AS _Supplier,
  Item._GLAccountInCompanyCode AS _GLAccountInCompanyCode,
  Item._ServiceDocument AS _ServiceDocument,
  Item._SalesDoc AS _SalesDoc,
  Item._FixedAsset AS _FixedAsset,
  Item._Order AS _Order,
  Item._CurrentCostCenter AS _CurrentCostCenter,
  Item._CurrentProfitCenter AS _CurrentProfitCenter,
  Item._AccountingDocumentType AS _AccountingDocumentType
FROM I_OperationalAcctgDocItem AS Item
LEFT OUTER JOIN C_FinInvoiceBillToPartyFDP AS _BillToParty ON Customer = _BillToParty.Customer  -- association [0..1]
LEFT OUTER JOIN C_FinInvcWithholdingTaxItemFDP AS _WithholdingTaxItem ON CompanyCode = _WithholdingTaxItem.CompanyCode AND FiscalYear = _WithholdingTaxItem.FiscalYear AND AccountingDocument = _WithholdingTaxItem.AccountingDocument AND AccountingDocumentItem = _WithholdingTaxItem.AccountingDocumentItem  -- association [0..*]
LEFT OUTER JOIN C_FinInvoiceSEPAMandateFDP AS _SEPAMandate ON Customer = _SEPAMandate.SEPAMandateSender  -- association [0..*]
LEFT OUTER JOIN C_FinInvoiceOneTimeAccountFDP AS _OneTimeAccount ON CompanyCode = _OneTimeAccount.CompanyCode AND FiscalYear = _OneTimeAccount.FiscalYear AND AccountingDocument = _OneTimeAccount.AccountingDocument AND AccountingDocumentItem = _OneTimeAccount.AccountingDocumentItem AND AddressAndBankIsSetManually = 'X'  -- association [0..1]
LEFT OUTER JOIN C_FinInvcBillToPartyCompanyFDP AS _BillToPartyCompany ON Customer = _BillToPartyCompany.Customer AND CompanyCode = _BillToPartyCompany.CompanyCode  -- association [0..1]
LEFT OUTER JOIN C_FinInvoiceItemNoteFDP AS _ItemNote ON CompanyCode = _ItemNote.CompanyCode AND FiscalYear = _ItemNote.FiscalYear AND AccountingDocument = _ItemNote.AccountingDocument AND AccountingDocumentItem = _ItemNote.AccountingDocumentItem  -- association [0..*]
LEFT OUTER JOIN I_PostingKeyWthSpclGLCodeTxt AS _PostingKeyWthSpclGLCodeTxt ON PostingKey = _PostingKeyWthSpclGLCodeTxt.PostingKey AND SpecialGLCode = _PostingKeyWthSpclGLCodeTxt.SpecialGLCode  -- association [*]
LEFT OUTER JOIN I_GLAccountText AS _GLAccountText ON ChartOfAccounts = _GLAccountText.ChartOfAccounts AND GLAccount = _GLAccountText.GLAccount  -- association [*]
LEFT OUTER JOIN I_PaymentTerms AS _PaymentTerm ON PaymentTerms = _PaymentTerm.PaymentTerms  -- association [0..1]
LEFT OUTER JOIN I_PaymentTermsText AS _PaymentTermText ON PaymentTerms = _PaymentTermText.PaymentTerms  -- association [*]
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]
;