I_RO_SAFTACCOUNTMAPPING
Mapping Accounting ID
I_RO_SAFTACCOUNTMAPPING is a CDS View in S/4HANA. Mapping Accounting ID. It contains 5 fields. 2 CDS views read from this table.
CDS Views using this table (2)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| P_RO_SAFTAccountMapping | view | from | CONSUMPTION | SAFT RO Account Mapping |
| P_RO_SAFTAccountMapping | view | union | CONSUMPTION | SAFT RO Account Mapping |
Fields (5)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | ChartOfAccounts | ChartOfAccounts | 1 |
| KEY | GLAccount | GLAccount | 1 |
| RO_SAFTAccountType | RO_SAFTAccountType | 1 | |
| RO_SAFTAccountTypeText | RO_SAFTAccountTypeText | 1 | |
| RO_SAFTStandardAccount | RO_SAFTStandardAccount | 1 |
@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
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_RO_SAFTACCOUNTTYPE",
"/CEECV/ROCACCMAP"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/