I_RO_SAFTACCOUNTMAPPING

CDS View

Mapping Accounting ID

I_RO_SAFTACCOUNTMAPPING is a CDS View in S/4HANA. Mapping Accounting ID. It contains 2 fields. 7 CDS views read from this table.

Used by 7 CDS view(s) 2 fields

CDS Views using this table (7)

ViewTypeJoinVDMDescription
P_RO_SAFTCActgBalance view_entity inner CONSUMPTION Customer Balances
P_RO_SAFTCActgJournalItemExc view_entity inner CONSUMPTION GL Item and Header for RO SAFT
P_RO_SAFTCACTGSIITEM0 view_entity inner CONSUMPTION Sales Item
P_RO_SAFTCustomer view inner CONSUMPTION Customer Data for RO SAFT
P_RO_SAFTJournalEntryItemExc view inner CONSUMPTION Acdoca Exclude 8/9 GL accounts
P_RO_SAFTOplAcctgDocItmExc view inner CONSUMPTION Bseg Exclude 8/9 GL accounts
P_RO_SAFTSupplier view inner CONSUMPTION Supplier Data for RO SAFT

Fields (2)

KeyField CDS FieldsUsed in Views
KEY RO_SAFTStandardAccount CASrcSaftStandardAccount,RO_SAFTStandardAccount 7
RO_SAFTIsDefaultZeroQuantity RO_SAFTIsDefaultZeroQuantity 3 
@AbapCatalog.sqlViewName: 'IROSAFTACCMAP'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@VDM.viewType: #BASIC
@ObjectModel.usageType.serviceQuality: #X
@ObjectModel.usageType.sizeCategory: #S
@ObjectModel.usageType.dataClass: #CUSTOMIZING
@AccessControl.personalData.blocking: #NOT_REQUIRED
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Mapping Accounting ID'
define view I_RO_SAFTAccountMapping
  as select from /ceecv/rocaccmap     as AccountMapping
    join         I_RO_SAFTAccountType as AccountType on AccountMapping.acctype = AccountType.RO_SAFTAccountType
{
  key AccountMapping.ktopl               as ChartOfAccounts,
  key AccountMapping.saknr               as GLAccount,
      AccountMapping.staccid             as RO_SAFTStandardAccount,
      AccountMapping.acctype             as RO_SAFTAccountType,

      case AccountMapping.acctype
        when '01' then 'Activ'
        when '02' then 'Pasiv'
        when '03' then 'Bifunctional'
      end                                as RO_SAFTAccountTypeText,
      AccountMapping.defaultzeroquantity as RO_SAFTIsDefaultZeroQuantity,
      AccountMapping.excltrdata          as GLAccountIsNotProdnRelevant

}

Learn More