P_RO_SAFTBSAK

DDL: P_RO_SAFTBSAK SQL: PROSAFTBSAK Type: view COMPOSITE

BSAK

P_RO_SAFTBSAK is a Composite CDS View that provides data about "BSAK" in SAP S/4HANA. It reads from 1 data source (I_OperationalAcctgDocItem) and exposes 11 fields with key fields CompanyCode, Supplier, SpecialGLTransactionType, SpecialGLCode, ClearingDate.

1 data source(s) 11 fields

Data Sources (1)

SourceAliasJoin Type
I_OperationalAcctgDocItem I_OperationalAcctgDocItem from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName PROSAFTBSAK view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #COMPOSITE view
VDM.private true view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label BSAK view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode CompanyCode
KEY Supplier Supplier
KEY SpecialGLTransactionType SpecialGLTransactionType
KEY SpecialGLCode SpecialGLCode
KEY ClearingDate ClearingDate
KEY ClearingJournalEntry ClearingJournalEntry
KEY AssignmentReference AssignmentReference
KEY FiscalYear FiscalYear
KEY AccountingDocument AccountingDocument
KEY AccountingDocumentItem AccountingDocumentItem
VATRegistration VATRegistration 
@AbapCatalog.sqlViewName: 'PROSAFTBSAK'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.viewType: #COMPOSITE
@VDM.private:true
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'BSAK'
define view P_RO_SAFTBSAK
  as select from I_OperationalAcctgDocItem
{

  key CompanyCode,
  key Supplier,
  key SpecialGLTransactionType,
  key SpecialGLCode,
  key ClearingDate,
  key ClearingJournalEntry,
  key AssignmentReference,
  key FiscalYear,
  key AccountingDocument,
  key AccountingDocumentItem,
      VATRegistration

}
   where FinancialAccountType = 'K'
   and ClearingJournalEntry <> ''
   and AccountingDocumentCategory <> 'D'
   and AccountingDocumentCategory <> 'M'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_OPERATIONALACCTGDOCITEM"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More