I_SAFTCompensationDocument

DDL: I_SAFTCOMPENSATIONDOCUMENT SQL: ISAFTCOMPDOC Type: view COMPOSITE

SAFT Compensation Documents

I_SAFTCompensationDocument is a Composite CDS View that provides data about "SAFT Compensation Documents" in SAP S/4HANA. It reads from 1 data source (I_JournalEntryItem) and exposes 50 fields with key fields SourceLedger, CompanyCode, FiscalYear, AccountingDocument, LedgerGLLineItem.

1 data source(s) 50 fields

Data Sources (1)

SourceAliasJoin Type
I_JournalEntryItem a from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName ISAFTCOMPDOC view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #BLOCKED_DATA_INCLUDED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label SAFT Compensation Documents view

Fields (50)

KeyFieldSource TableSource FieldDescription
KEY SourceLedger I_JournalEntryItem SourceLedger
KEY CompanyCode I_JournalEntryItem CompanyCode
KEY FiscalYear I_JournalEntryItem FiscalYear
KEY AccountingDocument I_JournalEntryItem AccountingDocument
KEY LedgerGLLineItem I_JournalEntryItem LedgerGLLineItem
KEY Ledger I_JournalEntryItem Ledger
ChartOfAccounts I_JournalEntryItem ChartOfAccounts
GLAccount I_JournalEntryItem GLAccount
AccountingDocumentCategory I_JournalEntryItem AccountingDocumentCategory
PostingDate I_JournalEntryItem PostingDate
AccountingDocumentCreationDate
CreationTime
DocumentItemText I_JournalEntryItem DocumentItemText
DebitCreditCode I_JournalEntryItem DebitCreditCode
CompanyCodeCurrency I_JournalEntryItem CompanyCodeCurrency
AmountInCompanyCodeCurrency I_JournalEntryItem AmountInCompanyCodeCurrency
ReferenceDocumentType I_JournalEntryItem ReferenceDocumentType
ReferenceDocument I_JournalEntryItem ReferenceDocument
AccountingDocumentItem I_JournalEntryItem AccountingDocumentItem
Customer I_JournalEntryItem Customer
Supplier I_JournalEntryItem Supplier
ControllingArea I_JournalEntryItem ControllingArea
CostCenter I_JournalEntryItem CostCenter
OrderID I_JournalEntryItem OrderID
PersonnelNumber I_JournalEntryItem PersonnelNumber
AmountInTransactionCurrency I_JournalEntryItem AmountInTransactionCurrency
WBSElement I_JournalEntryItem WBSElement
TaxCode I_JournalEntryItem TaxCode
TransactionCurrency I_JournalEntryItem TransactionCurrency
TransactionTypeDetermination I_JournalEntryItem TransactionTypeDetermination
FinancialAccountType I_JournalEntryItem FinancialAccountType
InvoiceReference I_JournalEntryItem InvoiceReference
InvoiceReferenceFiscalYear I_JournalEntryItem InvoiceReferenceFiscalYear
InvoiceItemReference I_JournalEntryItem InvoiceItemReference
SalesDocument I_JournalEntryItem SalesDocument
SalesDocumentItem I_JournalEntryItem SalesDocumentItem
ReversalReferenceDocument I_JournalEntryItem ReversalReferenceDocument
IsReversal I_JournalEntryItem IsReversal
_SourceLedger I_JournalEntryItem _SourceLedger
_CompanyCode I_JournalEntryItem _CompanyCode
_FiscalYear I_JournalEntryItem _FiscalYear
_JournalEntry I_JournalEntryItem _JournalEntry
_Ledger I_JournalEntryItem _Ledger
_DebitCreditCode I_JournalEntryItem _DebitCreditCode
_CompanyCodeCurrency I_JournalEntryItem _CompanyCodeCurrency
_AccountingDocumentCategory I_JournalEntryItem _AccountingDocumentCategory
_GLAccountInChartOfAccounts I_JournalEntryItem _GLAccountInChartOfAccounts
_ChartOfAccounts I_JournalEntryItem _ChartOfAccounts
_ReferenceDocumentType I_JournalEntryItem _ReferenceDocumentType
_Customer I_JournalEntryItem _Customer 
@AbapCatalog.sqlViewName: 'ISAFTCOMPDOC'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #BLOCKED_DATA_INCLUDED
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #MIXED
@VDM.viewType: #COMPOSITE
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'SAFT Compensation Documents'
define view I_SAFTCompensationDocument as select from I_JournalEntryItem as a {

  @ObjectModel.foreignKey.association: '_SourceLedger'
  key a.SourceLedger as SourceLedger,
  @ObjectModel.foreignKey.association: '_CompanyCode'
  key a.CompanyCode as CompanyCode,
  @ObjectModel.foreignKey.association: '_FiscalYear'
  key a.FiscalYear as FiscalYear,
  @ObjectModel.foreignKey.association: '_JournalEntry'
  key a.AccountingDocument as AccountingDocument,
  key a.LedgerGLLineItem as LedgerGLLineItem,
  @ObjectModel.foreignKey.association: '_Ledger'
  key a.Ledger as Ledger,
  
  @ObjectModel.foreignKey.association: '_ChartOfAccounts'
  a.ChartOfAccounts,
  @ObjectModel.foreignKey.association: '_GLAccountInChartOfAccounts'
  a.GLAccount,
  @ObjectModel.foreignKey.association: '_AccountingDocumentCategory'
  a.AccountingDocumentCategory,
  a.PostingDate,
  a._JournalEntry.AccountingDocumentCreationDate,
  a._JournalEntry.CreationTime,
  a.DocumentItemText,
  
  @ObjectModel.foreignKey.association: '_DebitCreditCode'
  a.DebitCreditCode as DebitCreditCode,
  
  @ObjectModel.foreignKey.association: '_CompanyCodeCurrency'
  @Semantics.currencyCode:true
  a.CompanyCodeCurrency as CompanyCodeCurrency,
  @DefaultAggregation: #SUM
  @Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} }
  a.AmountInCompanyCodeCurrency as AmountInCompanyCodeCurrency,
  
  @ObjectModel.foreignKey.association: '_ReferenceDocumentType'
  a.ReferenceDocumentType,
  a.ReferenceDocument,
  
  a.AccountingDocumentItem,
  a.Customer,
  a.Supplier,
  a.ControllingArea, //kokrs

  a.CostCenter, //kostl   

  a.OrderID, //aufnr

  a.PersonnelNumber, //pernr

  a.AmountInTransactionCurrency, //wrbtr_shl

  a.WBSElement, //projk

  a.TaxCode,  //mwskz

  a.TransactionCurrency,
  a.TransactionTypeDetermination, //ktosl 

  a.FinancialAccountType, //koart 

  a.InvoiceReference, //rebzg   

  a.InvoiceReferenceFiscalYear, //rebzj  

  a.InvoiceItemReference, //rebzz 

  a.SalesDocument,    //vbel2

  a.SalesDocumentItem,  //posn2 

  a.ReversalReferenceDocument,
  a.IsReversal,
  
  a._SourceLedger,
  a._CompanyCode,
  a._FiscalYear,
  a._JournalEntry,
  a._Ledger,
  a._DebitCreditCode,
  a._CompanyCodeCurrency,
  a._AccountingDocumentCategory,
  a._GLAccountInChartOfAccounts,
  a._ChartOfAccounts,
  a._ReferenceDocumentType,
  a._Customer   
  
} where ( a.BusinessTransactionType = 'AFAB' or a.BusinessTransactionType = 'TBRR' )
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_JOURNALENTRY",
"I_JOURNALENTRYITEM"
],
"ASSOCIATED":
[
"I_ACCOUNTINGDOCUMENTCATEGORY",
"I_CHARTOFACCOUNTS",
"I_COMPANYCODE",
"I_CURRENCY",
"I_CUSTOMER",
"I_DEBITCREDITCODE",
"I_FISCALYEARFORCOMPANYCODE",
"I_GLACCOUNTINCHARTOFACCOUNTS",
"I_JOURNALENTRY",
"I_LEDGER",
"I_REFERENCEDOCUMENTTYPE"
],
"BASE":
[
"I_JOURNALENTRYITEM"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More