F_Mmim_Acdoca_Ele

DDL: F_MMIM_ACDOCA_ELE SQL: FMMIMACDOCAELE Type: view

Read Universal Journal Entry Line Items

F_Mmim_Acdoca_Ele is a CDS View that provides data about "Read Universal Journal Entry Line Items" in SAP S/4HANA. It reads from 2 data sources (acdoca, finsc_ledger) and exposes 10 fields with key fields Ledger, CompanyCode, FiscalYear, AccountingDocument, LedgerGLLineItem.

2 data source(s) 10 fields

Data Sources (2)

SourceAliasJoin Type
acdoca acdoca from
finsc_ledger finsc_ledger inner

Annotations (9)

NameValueLevelField
AbapCatalog.preserveKey true view
AbapCatalog.sqlViewName FMMIMACDOCAELE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Read Universal Journal Entry Line Items view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY Ledger acdoca rldnr
KEY CompanyCode rbukrs
KEY FiscalYear gjahr
KEY AccountingDocument belnr
KEY LedgerGLLineItem docln
ReferenceDocumentType awtyp
ReferenceDocumentContext aworg
ReferenceDocument awref
ReferenceDocumentItem
LogicalSystem awsys 
@AbapCatalog.preserveKey: true
@AbapCatalog.sqlViewName: 'FMMIMACDOCAELE'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Read Universal Journal Entry Line Items'
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.dataClass:#MIXED
@ClientHandling.algorithm: #SESSION_VARIABLE

define view F_Mmim_Acdoca_Ele as select from acdoca
  inner join finsc_ledger on acdoca.rldnr = finsc_ledger.rldnr
    and finsc_ledger.xleading = 'X'
{

key acdoca.rldnr as Ledger,
key rbukrs as CompanyCode,
key gjahr as FiscalYear,
key belnr as AccountingDocument,
key docln as LedgerGLLineItem,
    awtyp as ReferenceDocumentType,
    aworg as ReferenceDocumentContext,
    awref as ReferenceDocument,
    cast(right(awitem, 4) as mblpo) as ReferenceDocumentItem,
    awsys as LogicalSystem
      
} 
where awtyp = 'MKPF'               

/*+[internal] {
"BASEINFO":
{
"FROM":
[
"ACDOCA",
"FINSC_LEDGER"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More