Deprecated
This CDS view is deprecated in S/4HANA. Use I_OperationalAcctgDocItem instead. View all deprecated CDS views →

I_SAFTAccountingProduct

DDL: I_SAFTACCOUNTINGPRODUCT SQL: ISAFTACCPRODUCT Type: view COMPOSITE

SAF-T Accouting Product

I_SAFTAccountingProduct is a Composite CDS View that provides data about "SAF-T Accouting Product" in SAP S/4HANA.

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName ISAFTACCPRODUCT view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #COMPOSITE view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
EndUserText.label SAF-T Accouting Product view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
VDM.lifecycle.status #DEPRECATED view
VDM.lifecycle.successor I_OperationalAcctgDocItem view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY AccountingDocument AccountingDocument Journal Entry
KEY CompanyCode CompanyCode Receiver Company Code
KEY FiscalYear FiscalYear G/L Fiscal Year
KEY Product accdoc Product Product Sold
KEY GLAccount accdoc GLAccount General Ledger
InvoiceDate accdoc DocumentDate Journal Entry Date
ProductType
ChartOfAccounts accdoc ChartOfAccounts Node Class
_Product _Product
_ProductText _ProductText
_GLAccountInChartOfAccounts _GLAccountInChartOfAccounts

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 I_SAFTAccountingProduct.
-- 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: ISAFTACCPRODUCT

CREATE VIEW I_SAFTAccountingProduct AS
SELECT
  AccountingDocument,
  CompanyCode,
  FiscalYear,
  accdoc.Product AS Product,
  accdoc.GLAccount AS GLAccount,
  accdoc.DocumentDate AS InvoiceDate,
  accdoc._Product.ProductType AS ProductType,
  accdoc.ChartOfAccounts AS ChartOfAccounts
;