F_Mmim_Matdoc_Item_Account

DDL: F_MMIM_MATDOC_ITEM_ACCOUNT SQL: FMMIMMATDITMACC Type: view
46 Fields 1 Data Sources 1 Associations

Accounting information Material Document

F_Mmim_Matdoc_Item_Account is a CDS View that provides data about "Accounting information Material Document" in SAP S/4HANA. It reads from 1 data source (I_MaterialDocumentRecord) and exposes 46 fields with key fields MaterialDocument, MaterialDocumentYear, MaterialDocumentItem. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_MaterialDocumentRecord I_MaterialDocumentRecord from

Associations (1)

CardinalityTargetAliasCondition
[1..*] P_PSMinMatDoc _MATDOC_ITEM_ACCOUNT_PSM $projection.MaterialDocument = _MATDOC_ITEM_ACCOUNT_PSM.MaterialDocument and $projection.MaterialDocumentYear = _MATDOC_ITEM_ACCOUNT_PSM.MaterialDocumentYear and $projection.MaterialDocumentItem = _MATDOC_ITEM_ACCOUNT_PSM.MaterialDocumentItem and $projection.CompanyCode = _MATDOC_ITEM_ACCOUNT_PSM.CompanyCode and _MATDOC_ITEM_ACCOUNT_PSM.ReferenceType = 'MKPF' and _MATDOC_ITEM_ACCOUNT_PSM.MaterialDocumentRecordType = 'MDOC'

Annotations (12)

NameValueLevelField
AbapCatalog.preserveKey true view
AbapCatalog.sqlViewName FMMIMMATDITMACC view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Accounting information Material Document view
Search.searchable true view
UI.headerInfo.typeName Account Assigment view
UI.headerInfo.typeNamePlural Account Assigments view

Fields (46)

KeyFieldSource TableSource FieldDescription
KEY MaterialDocument MaterialDocument Material Doc.
KEY MaterialDocumentYear MaterialDocumentYear Material Document Year
KEY MaterialDocumentItem MaterialDocumentItem Material Document Item
Plant Plant Valuation Area
IssuingOrReceivingPlant IssuingOrReceivingPlant Transfer Plant
MultiAcctAssgmtOriglMatlDocItm MultiAcctAssgmtOriglMatlDocItm
QuantityInEntryUnit Quantity in Unit of Entry
EntryUnit EntryUnit Unit of Entry
GLAccount GLAccount General Ledger
GLAccountLongName
CostCenter CostCenter Cost Center
CostCenterName
FunctionalArea FunctionalArea Sendr Fctl Area
FunctionalAreaName
ProfitCenter ProfitCenter Profit Center
ProfitCenterName
MasterFixedAsset MasterFixedAsset Fixed Asset
FixedAsset FixedAsset Sub-number
FixedAssetDescription _FixedAsset FixedAssetDescription Description
BusinessArea BusinessArea Business Area
BusinessAreaName
ControllingArea ControllingArea Controlling Area
ControllingAreaName _ControllingArea ControllingAreaName Long Text
ChartOfAccounts _ControllingArea ChartOfAccounts Node Class
SalesOrder SalesOrder SD Document
SalesOrderItem SalesOrderItem Sales Order Item
WBSElement _WBSElementBasicData WBSElement WBS Internal ID
WBSDescription _WBSElementBasicData WBSDescription WBS Element Name
OrderID OrderID Order ID
CompanyCode CompanyCode Receiver Company Code
ServiceDocument ServiceDocument Service Document
ServiceDocumentItem ServiceDocumentItem Service Document Item
ServiceDocumentType ServiceDocumentType Service Document Type
ServiceDocumentTypeName
Fund _MATDOC_ITEM_ACCOUNT_PSM Fund Sender Fund
FundName _MATDOC_ITEM_ACCOUNT_PSM FundName Long Text
GrantID _MATDOC_ITEM_ACCOUNT_PSM GrantID Sender Grant
GrantName _MATDOC_ITEM_ACCOUNT_PSM GrantName
BudgetPeriod _MATDOC_ITEM_ACCOUNT_PSM BudgetPeriod Budget Period
BudgetPeriodName _MATDOC_ITEM_ACCOUNT_PSM BudgetPeriodName Long Text
FundedProgram _MATDOC_ITEM_ACCOUNT_PSM FundedProgram Funded Program
FundedProgramName _MATDOC_ITEM_ACCOUNT_PSM FundedProgramName
FundsCenter _MATDOC_ITEM_ACCOUNT_PSM FundsCenter Funds Center
FundsCenterName _MATDOC_ITEM_ACCOUNT_PSM FundsCenterName
CommitmentItem _MATDOC_ITEM_ACCOUNT_PSM CommitmentItem Commitment item
CommitmentItemName _MATDOC_ITEM_ACCOUNT_PSM CommitmentItemName Long Text

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 F_Mmim_Matdoc_Item_Account.
-- 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: FMMIMMATDITMACC

CREATE VIEW F_Mmim_Matdoc_Item_Account AS
SELECT
  MaterialDocument,
  MaterialDocumentYear,
  MaterialDocumentItem,
  Plant,
  IssuingOrReceivingPlant,
  MultiAcctAssgmtOriglMatlDocItm,
  cast(QuantityInEntryUnit as mmim_erfmg) AS QuantityInEntryUnit,
  EntryUnit,
  GLAccount,
  _GLAccount[1:ChartOfAccounts = ChartOfAccounts]._Text[1:Language = $session.system_language].GLAccountLongName AS GLAccountLongName,
  CostCenter,
  _CostCenter._Text[1:Language = $session.system_language].CostCenterName AS CostCenterName,
  FunctionalArea,
  _FunctionalArea._Text[1:Language = $session.system_language].FunctionalAreaName AS FunctionalAreaName,
  ProfitCenter,
  _ProfitCenter._Text[1:Language = $session.system_language].ProfitCenterName AS ProfitCenterName,
  MasterFixedAsset,
  FixedAsset,
  _FixedAsset.FixedAssetDescription AS FixedAssetDescription,
  BusinessArea,
  _BusinessArea._Text[1:Language = $session.system_language].BusinessAreaName AS BusinessAreaName,
  ControllingArea,
  _ControllingArea.ControllingAreaName AS ControllingAreaName,
  _ControllingArea.ChartOfAccounts AS ChartOfAccounts,
  SalesOrder,
  SalesOrderItem,
  _WBSElementBasicData.WBSElement AS WBSElement,
  _WBSElementBasicData.WBSDescription AS WBSDescription,
  OrderID,
  CompanyCode,
  ServiceDocument,
  ServiceDocumentItem,
  ServiceDocumentType,
  _ServiceDocumentType._ServiceDocumentTypeText[1:Language = $session.system_language].ServiceDocumentTypeName AS ServiceDocumentTypeName,
  _MATDOC_ITEM_ACCOUNT_PSM.Fund AS Fund,
  _MATDOC_ITEM_ACCOUNT_PSM.FundName AS FundName,
  _MATDOC_ITEM_ACCOUNT_PSM.GrantID AS GrantID,
  _MATDOC_ITEM_ACCOUNT_PSM.GrantName AS GrantName,
  _MATDOC_ITEM_ACCOUNT_PSM.BudgetPeriod AS BudgetPeriod,
  _MATDOC_ITEM_ACCOUNT_PSM.BudgetPeriodName AS BudgetPeriodName,
  _MATDOC_ITEM_ACCOUNT_PSM.FundedProgram AS FundedProgram,
  _MATDOC_ITEM_ACCOUNT_PSM.FundedProgramName AS FundedProgramName,
  _MATDOC_ITEM_ACCOUNT_PSM.FundsCenter AS FundsCenter,
  _MATDOC_ITEM_ACCOUNT_PSM.FundsCenterName AS FundsCenterName,
  _MATDOC_ITEM_ACCOUNT_PSM.CommitmentItem AS CommitmentItem,
  _MATDOC_ITEM_ACCOUNT_PSM.CommitmentItemName AS CommitmentItemName
FROM I_MaterialDocumentRecord
LEFT OUTER JOIN P_PSMinMatDoc AS _MATDOC_ITEM_ACCOUNT_PSM ON MaterialDocument = _MATDOC_ITEM_ACCOUNT_PSM.MaterialDocument AND MaterialDocumentYear = _MATDOC_ITEM_ACCOUNT_PSM.MaterialDocumentYear AND MaterialDocumentItem = _MATDOC_ITEM_ACCOUNT_PSM.MaterialDocumentItem AND CompanyCode = _MATDOC_ITEM_ACCOUNT_PSM.CompanyCode AND _MATDOC_ITEM_ACCOUNT_PSM.ReferenceType = 'MKPF' AND _MATDOC_ITEM_ACCOUNT_PSM.MaterialDocumentRecordType = 'MDOC'  -- association [1..*]
;

Learn More