P_PSMMatDocAccAssignments

DDL: P_PSMMATDOCACCASSIGNMENTS SQL: PPSMMATDOCAA Type: view BASIC
20 Fields 1 Data Sources 1 Associations

P_PSMMatDocAccAssignments is a Basic CDS View in SAP S/4HANA. It reads from 1 data source (I_MaterialDocumentRecord) and exposes 20 fields with key fields Ledger, CompanyCode, MaterialDocument, MaterialDocumentItem, MaterialDocumentYear. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_MaterialDocumentRecord _MatDoc from

Associations (1)

CardinalityTargetAliasCondition
[1] I_Ledger _Ledger _Ledger.IsLeadingLedger = 'X'

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName PPSMMATDOCAA view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.private true view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.buffering.status #NOT_ALLOWED view

Fields (20)

KeyFieldSource TableSource FieldDescription
KEY Ledger _Ledger Ledger Ledger
KEY CompanyCode I_MaterialDocumentRecord CompanyCode Receiver Company Code
KEY MaterialDocument I_MaterialDocumentRecord MaterialDocument Material Doc.
KEY MaterialDocumentItem I_MaterialDocumentRecord MaterialDocumentItem Material Document Item
KEY MaterialDocumentYear I_MaterialDocumentRecord MaterialDocumentYear Material Document Year
MaterialDocumentRecordType I_MaterialDocumentRecord MaterialDocumentRecordType
FiscalYear I_MaterialDocumentRecord FiscalYear G/L Fiscal Year
ReferenceDocument _JournalItem ReferenceDocument Reference Document
ReferenceDocumentItem _JournalItem ReferenceDocumentItem Reference item
ReferenceType
ReferenceOrganizationUnits
PostingDate I_MaterialDocumentRecord PostingDate Posting Date for GR
FinancialManagementArea _CompanyCode FinancialManagementArea FM Area
Fund
GrantID
BudgetPeriod _JournalItem BudgetPeriod Budget Period
FunctionalArea
FundedProgram _JournalItem FundedProgram Funded Program
FundsCenter
CommitmentItem I_MaterialDocumentRecord CommitmentItem Commitment item

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_PSMMatDocAccAssignments.
-- 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: PPSMMATDOCAA

CREATE VIEW P_PSMMatDocAccAssignments AS
SELECT
  _Ledger.Ledger AS Ledger,
  _MatDoc.CompanyCode AS CompanyCode,
  _MatDoc.MaterialDocument AS MaterialDocument,
  _MatDoc.MaterialDocumentItem AS MaterialDocumentItem,
  _MatDoc.MaterialDocumentYear AS MaterialDocumentYear,
  _MatDoc.MaterialDocumentRecordType AS MaterialDocumentRecordType,
  _MatDoc.FiscalYear AS FiscalYear,
  _JournalItem.ReferenceDocument AS ReferenceDocument,
  _JournalItem.ReferenceDocumentItem AS ReferenceDocumentItem,
  case when _JournalItem.ReferenceDocumentType is not initial then _JournalItem.ReferenceDocumentType else 'MKPF' end AS ReferenceType,
  case when _JournalItem.ReferenceDocumentUnits is not initial then _JournalItem.ReferenceDocumentUnits else _MatDoc.FiscalYear end AS ReferenceOrganizationUnits,
  _MatDoc.PostingDate AS PostingDate,
  _CompanyCode.FinancialManagementArea AS FinancialManagementArea,
  case when _MatDoc.Fund is not initial then _MatDoc.Fund else _JournalItem.Fund end AS Fund,
  case when _MatDoc.GrantID is not initial then _MatDoc.GrantID else _JournalItem.GrantID end AS GrantID,
  _JournalItem.BudgetPeriod AS BudgetPeriod,
  case when _MatDoc.FunctionalArea is not initial then _MatDoc.FunctionalArea else _JournalItem.FunctionalArea end AS FunctionalArea,
  _JournalItem.FundedProgram AS FundedProgram,
  case when _MatDoc.FundsCenter is not initial then _MatDoc.FundsCenter else _JournalItem.FundsCenter end AS FundsCenter,
  _MatDoc.CommitmentItem AS CommitmentItem
FROM I_MaterialDocumentRecord AS _MatDoc
LEFT OUTER JOIN I_Ledger AS _Ledger ON _Ledger.IsLeadingLedger = 'X'  -- association [1]
;

Learn More