P_SalesDocItem

DDL: P_SALESDOCITEM SQL: PSALESDOCITM Type: view COMPOSITE
13 Fields 1 Data Sources

P_SalesDocItem is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (I_SalesDocumentItem) and exposes 13 fields.

Data Sources (1)

SourceAliasJoin Type
I_SalesDocumentItem SalDocItem from

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName PSALESDOCITM view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #COMPOSITE view
VDM.private true view

Fields (13)

KeyFieldSource TableSource FieldDescription
SalesDocument I_SalesDocumentItem SalesDocument SD Document
SalesDocumentItem I_SalesDocumentItem SalesDocumentItem Sales Document Item
SDDocumentCategory I_SalesDocumentItem SDDocumentCategory Document Cat.
SalesDocumentItemText I_SalesDocumentItem SalesDocumentItemText Item Descr.
ControllingObject I_SalesDocumentItem ControllingObject Object number
WBSElement I_SalesDocumentItem WBSElement WBS Internal ID
FiscalYear I_SalesDocumentItem FiscalYear G/L Fiscal Year
SalesOrganization
DistributionChannel
ControllingArea
Division I_SalesDocumentItem Division Internal Division ID
BusinessArea I_SalesDocumentItem BusinessArea Business Area
CompanyCode

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_SalesDocItem.
-- 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: PSALESDOCITM

CREATE VIEW P_SalesDocItem AS
SELECT
  SalDocItem.SalesDocument AS SalesDocument,
  SalDocItem.SalesDocumentItem AS SalesDocumentItem,
  SalDocItem.SDDocumentCategory AS SDDocumentCategory,
  SalDocItem.SalesDocumentItemText AS SalesDocumentItemText,
  SalDocItem.ControllingObject AS ControllingObject,
  SalDocItem.WBSElement AS WBSElement,
  SalDocItem.FiscalYear AS FiscalYear,
  SalDocItem._SalesDocument.SalesOrganization AS SalesOrganization,
  SalDocItem._SalesDocument.DistributionChannel AS DistributionChannel,
  SalDocItem._SalesDocument.ControllingArea AS ControllingArea,
  SalDocItem.Division AS Division,
  SalDocItem.BusinessArea AS BusinessArea,
  SalDocItem._SalesDocument._SalesOrganization.CompanyCode AS CompanyCode
FROM I_SalesDocumentItem AS SalDocItem
;

Learn More