P_RO_SAFTBsad

DDL: P_RO_SAFTBSAD SQL: PROSAFTBSAD Type: view COMPOSITE

BSAD

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

1 data source(s) 11 fields

Data Sources (1)

SourceAliasJoin Type
I_OperationalAcctgDocItem I_OperationalAcctgDocItem from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName PROSAFTBSAD 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 BSAD view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode CompanyCode
KEY Customer Customer
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: 'PROSAFTBSAD'
@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: 'BSAD'
define view P_RO_SAFTBsad
  as select from I_OperationalAcctgDocItem
{

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

}
   where FinancialAccountType = 'D'
   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