P_SlsAcctgSlsDdctdBenchmarkOvw

DDL: P_SLSACCTGSLSDDCTDBENCHMARKOVW SQL: PSASDDBKOVW Type: view COMPOSITE
47 Fields 1 Data Sources

P_SlsAcctgSlsDdctdBenchmarkOvw is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (I_ActualPlanLineItemSemTag) and exposes 47 fields with key fields Ledger, CompanyCode, MaterialGroup, CustomerGroup, CustomerSupplierCountry.

Data Sources (1)

SourceAliasJoin Type
I_ActualPlanLineItemSemTag I_ActualPlanLineItemSemTag 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 (9)

NameValueLevelField
AbapCatalog.sqlViewName PSASDDBKOVW view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
AccessControl.personalData.blocking #NOT_REQUIRED view
VDM.private true view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view

Fields (47)

KeyFieldSource TableSource FieldDescription
KEY Ledger Ledger Ledger
KEY CompanyCode CompanyCode Receiver Company Code
KEY MaterialGroup MaterialGroup Product Group
KEY CustomerGroup CustomerGroup Customer Group
KEY CustomerSupplierCountry CustomerSupplierCountry Customer or Supplier Country/Region
KEY CustomerSupplierIndustry CustomerSupplierIndustry Industry
KEY SalesDistrict SalesDistrict Sales District
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
PlanningCategory PlanningCategory Plan Category
Division Division Internal Division ID
DistributionChannel DistributionChannel RefDistCh-Cust/Mat.
AccountingDocumentType I_ActualPlanLineItemSemTag AccountingDocumentType Journal Entry Type
GLAccountAuthorizationGroup _GLAccountInCompanyCode AuthorizationGroup AuthorizGroup
AuthorizationGroup _AccountingDocumentType AuthorizationGroup AuthorizGroup
FiscalYear
ValuationArea ValuationArea Valuation Area
OrganizationDivision OrganizationDivision Org. Division
Plant Plant Valuation Area
ControllingArea ControllingArea Controlling Area
CostCenter CostCenter Cost Center
FunctionalArea FunctionalArea Sendr Fctl Area
BusinessArea BusinessArea Business Area
Segment Segment Segment number
FinancialAccountType FinancialAccountType Fin. Account Type
SalesDocument SalesDocument SD Document
OrderID OrderID Order ID
Supplier Supplier Supplier
ServiceDocumentType ServiceDocumentType Transaction Type
ServiceDocument ServiceDocument Transaction ID
AssetClass AssetClass Asset Class
PostingDate PostingDate Posting Date for GR
_Customer _Customer
_AccountingDocumentType _AccountingDocumentType
_GLAccountInCompanyCode _GLAccountInCompanyCode
_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 P_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: PSASDDBKOVW
-- 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 P_SlsAcctgSlsDdctdBenchmarkOvw AS
SELECT
  Ledger,
  CompanyCode,
  MaterialGroup,
  CustomerGroup,
  CustomerSupplierCountry,
  CustomerSupplierIndustry,
  SalesDistrict,
  GlobalCurrency,
  ProductGroup,
  Customer,
  ProfitCenter,
  GLAccount,
  SalesOrganization,
  SoldProductGroup,
  GLAccountHierarchy,
  PlanningCategory,
  Division,
  DistributionChannel,
  I_ActualPlanLineItemSemTag.AccountingDocumentType AS AccountingDocumentType,
  _GLAccountInCompanyCode.AuthorizationGroup AS GLAccountAuthorizationGroup,
  _AccountingDocumentType.AuthorizationGroup AS AuthorizationGroup,
  $parameters.P_Interval1Year AS FiscalYear,
  ValuationArea,
  OrganizationDivision,
  Plant,
  ControllingArea,
  CostCenter,
  FunctionalArea,
  BusinessArea,
  Segment,
  FinancialAccountType,
  SalesDocument,
  OrderID,
  Supplier,
  ServiceDocumentType,
  ServiceDocument,
  AssetClass,
  PostingDate
FROM I_ActualPlanLineItemSemTag
;

Learn More