P_RO_SAFTBSEC

@AbapCatalog.sqlViewName: 'PROSAFTBSEC'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@VDM.private:true
@VDM.viewType: #BASIC
@ObjectModel.usageType.sizeCategory: #M
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #NOT_REQUIRED

@EndUserText.label: 'Bsec'
define view P_RO_SAFTBSEC as select from bsec
{
  key bsec.bukrs                                              as CompanyCode,
  key bsec.belnr                                              as AccountingDocument,
  key cast( bsec.gjahr as fis_gjahr_no_conv preserving type ) as FiscalYear,
  key bsec.buzei                                              as AccountingDocumentItem,
      cast(bsec.name1 as ad_name1)                            as BusinessPartnerName1,
      bsec.land1                                              as Country,
      cast(bsec.ort01 as ad_city1)                            as CityName,
      bsec.pstlz                                              as PostalCode,
      bsec.regio                                              as Region,
      bsec.stcd1                                              as TaxID1,
      bsec.stcd2                                              as TaxID2,
      bsec.stcd3                                              as TaxID3,
      bsec.stcd4                                              as TaxID4,
      bsec.stcd5                                              as TaxID5,
      bsec.stras                                              as StreetAddressName,
      cast(bsec.stkzn as bu_natural_person)                   as IsNaturalPerson,
      bsec.xcpdk                                              as IsOneTimeAccount
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"BSEC"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/