I_SlsAcctgSlsDdctdBenchmarkOvw

DDL: I_SLSACCTGSLSDDCTDBENCHMARKOVW SQL: ISASDDBKOVW Type: view COMPOSITE
49 Fields 1 Data Sources

Sales Deductions Benchmark Card

I_SlsAcctgSlsDdctdBenchmarkOvw is a Composite CDS View that provides data about "Sales Deductions Benchmark Card" in SAP S/4HANA. It reads from 1 data source (P_SlsAcctgSlsDdctdBenchmarkOvw) and exposes 49 fields with key fields Ledger, CompanyCode, MaterialGroup, CustomerGroup, SalesDistrict.

Data Sources (1)

SourceAliasJoin Type
P_SlsAcctgSlsDdctdBenchmarkOvw P_SlsAcctgSlsDdctdBenchmarkOvw from

Parameters (8)

NameTypeDefault
P_CompanyCode fis_bukrs
P_PlanningCategory fcom_category
P_Interval1FromFiscalPeriod fis_period_from
P_Interval1ToFiscalPeriod fis_period_to
P_Interval1Year fis_gjahr
P_Interval2FromFiscalPeriod fis_period_from
P_Interval2ToFiscalPeriod fis_period_to
P_Interval2Year fis_gjahr

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName ISASDDBKOVW view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Sales Deductions Benchmark Card view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view

Fields (49)

KeyFieldSource TableSource FieldDescription
KEY Ledger Ledger Ledger
KEY CompanyCode CompanyCode Receiver Company Code
KEY MaterialGroup MaterialGroup Product Group
KEY CustomerGroup CustomerGroup Customer Group
KEY SalesDistrict SalesDistrict Sales District
KEY CustomerSupplierCountry CustomerSupplierCountry Customer or Supplier Country/Region
KEY CustomerSupplierIndustry CustomerSupplierIndustry Industry
KEY GlobalCurrency GlobalCurrency GM Billing Element: Global Currency
KEY ProductGroup ProductGroup Product Sold Group
KEY Customer Customer Sold-to Party
KEY ProfitCenter ProfitCenter Profit Center
KEY GLAccount GLAccount General Ledger
KEY SalesOrganization SalesOrganization Sales Organization
KEY SoldProductGroup SoldProductGroup Product Sold Group
KEY GLAccountHierarchy GLAccountHierarchy
KEY Plant Plant Valuation Area
KEY ControllingArea ControllingArea Controlling Area
KEY PostingDate PostingDate Posting Date for GR
KEY SalesDocument SalesDocument SD Document
PlanningCategory PlanningCategory Plan Category
Division Division Internal Division ID
DistributionChannel DistributionChannel RefDistCh-Cust/Mat.
GLAccountAuthorizationGroup _GLAccountInCompanyCode AuthorizationGroup AuthorizGroup
AuthorizationGroup _AccountingDocumentType AuthorizationGroup AuthorizGroup
AccountingDocumentType AccountingDocumentType Journal Entry Type
ActlSlsDeductionAmtInGlobCrcy
PlnSlsDeductionAmtInGlobCrcy
LastYrActlSlsDdctdAmtInGCrcy
ValuationArea ValuationArea Valuation Area
OrganizationDivision OrganizationDivision Org. Division
CostCenter CostCenter Cost Center
FunctionalArea FunctionalArea Sendr Fctl Area
BusinessArea BusinessArea Business Area
Segment Segment Segment number
FinancialAccountType FinancialAccountType Fin. Account Type
OrderID OrderID Order ID
Supplier Supplier Supplier
ServiceDocumentType ServiceDocumentType Transaction Type
ServiceDocument ServiceDocument Transaction ID
AssetClass AssetClass Asset Class
_Customer _Customer
_GLAccountInCompanyCode _GLAccountInCompanyCode
_AccountingDocumentType _AccountingDocumentType
_SalesDocument _SalesDocument
_Order _Order
_CurrentProfitCenter _CurrentProfitCenter
_CurrentCostCenter _CurrentCostCenter
_Supplier _Supplier
_ServiceDocument _ServiceDocument

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_SlsAcctgSlsDdctdBenchmarkOvw.
-- 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: ISASDDBKOVW
-- Parameters: P_CompanyCode : fis_bukrs, P_PlanningCategory : fcom_category, P_Interval1FromFiscalPeriod : fis_period_from, P_Interval1ToFiscalPeriod : fis_period_to, P_Interval1Year : fis_gjahr, P_Interval2FromFiscalPeriod : fis_period_from, P_Interval2ToFiscalPeriod : fis_period_to, P_Interval2Year : fis_gjahr

CREATE VIEW I_SlsAcctgSlsDdctdBenchmarkOvw AS
SELECT
  Ledger,
  CompanyCode,
  MaterialGroup,
  CustomerGroup,
  SalesDistrict,
  CustomerSupplierCountry,
  CustomerSupplierIndustry,
  GlobalCurrency,
  ProductGroup,
  Customer,
  ProfitCenter,
  GLAccount,
  SalesOrganization,
  SoldProductGroup,
  GLAccountHierarchy,
  Plant,
  ControllingArea,
  PostingDate,
  SalesDocument,
  PlanningCategory,
  Division,
  DistributionChannel,
  _GLAccountInCompanyCode.AuthorizationGroup AS GLAccountAuthorizationGroup,
  _AccountingDocumentType.AuthorizationGroup AS AuthorizationGroup,
  AccountingDocumentType,
  (-1 * ActlSlsDeductionAmtInGlobCrcy) AS ActlSlsDeductionAmtInGlobCrcy,
  (-1 * PlnSlsDeductionAmtInGlobCrcy) AS PlnSlsDeductionAmtInGlobCrcy,
  (-1 * LastYrActlSlsDdctdAmtInGCrcy) AS LastYrActlSlsDdctdAmtInGCrcy,
  ValuationArea,
  OrganizationDivision,
  CostCenter,
  FunctionalArea,
  BusinessArea,
  Segment,
  FinancialAccountType,
  OrderID,
  Supplier,
  ServiceDocumentType,
  ServiceDocument,
  AssetClass
FROM P_SlsAcctgSlsDdctdBenchmarkOvw
;

Learn More