C_RO_SAFTCustomer

DDL: C_RO_SAFTCUSTOMER SQL: CROSAFTCUSTOMER Type: view CONSUMPTION

Customer Master Data for RO SAFT

C_RO_SAFTCustomer is a Consumption CDS View that provides data about "Customer Master Data for RO SAFT" in SAP S/4HANA. It reads from 1 data source (I_Customer) and exposes 20 fields with key fields SourceLedger, Ledger, CompanyCode, Customer, StatryRptCategory.

1 data source(s) 20 fields

Data Sources (1)

SourceAliasJoin Type
I_Customer Customer inner

Parameters (3)

NameTypeDefault
P_FromPostingDate dats
P_ToPostingDate dats
P_AlternativeGLAccountIsUsed saft_ro_alt_gl_account_flag

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName CROSAFTCUSTOMER view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.personalData.blocking #BLOCKED_DATA_INCLUDED view
AccessControl.authorizationCheck #CHECK view
Metadata.allowExtensions true view
EndUserText.label Customer Master Data for RO SAFT view

Fields (20)

KeyFieldSource TableSource FieldDescription
KEY SourceLedger Item SourceLedger
KEY Ledger Item Ledger
KEY CompanyCode Item CompanyCode
KEY Customer Item Customer
KEY StatryRptCategory Item StatryRptCategory
KEY StatryRptgEntity Item StatryRptgEntity
KEY StatryRptRunID Item StatryRptRunID
KEY RO_SAFTStandardAccount Item RO_SAFTStandardAccount
VATRegistration Item CustomerVATRegistration
ChartOfAccounts Item ChartOfAccounts
GLAccount Item GLAccount
BusinessPartner
CustomerName I_Customer OrganizationBPName1
CountryISOCode
Region
PostalCode
CityName
StreetName
HouseNumber
Building 
@AbapCatalog.sqlViewName: 'CROSAFTCUSTOMER'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@VDM.viewType: #CONSUMPTION
@ObjectModel.usageType.serviceQuality: #X
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #MIXED
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.personalData.blocking: #BLOCKED_DATA_INCLUDED
@AccessControl.authorizationCheck: #CHECK
@Metadata.allowExtensions:true
@EndUserText.label: 'Customer Master Data for RO SAFT'
define view C_RO_SAFTCustomer
  with parameters
    P_FromPostingDate            : dats,
    P_ToPostingDate              : dats,
    P_AlternativeGLAccountIsUsed : saft_ro_alt_gl_account_flag

  as select distinct from C_RO_SAFTJournalEntryItemC( P_AlternativeGLAccountIsUsed : $parameters.P_AlternativeGLAccountIsUsed, P_VATRegistration : '' ) as Item

    inner join I_Customer as Customer on Customer.Customer = Item.Customer

{
  key Item.SourceLedger,
  key Item.Ledger,
  key Item.CompanyCode,
  key Item.Customer,
  key Item.StatryRptCategory,
  key Item.StatryRptgEntity,
  key Item.StatryRptRunID,
  key Item.RO_SAFTStandardAccount,
      Item.CustomerVATRegistration as VATRegistration,
      Item.ChartOfAccounts,
      Item.GLAccount,
      Customer._CustomerToBusinessPartner._BusinessPartner.BusinessPartner,
      Customer.OrganizationBPName1 as CustomerName,
      cast( Customer._StandardAddress._Country.CountryISOCode as land1 ) as CountryISOCode,
      Customer._StandardAddress.Region,
      Customer._StandardAddress.PostalCode,
      Customer._StandardAddress.CityName,
      Customer._StandardAddress.StreetName,
      Customer._StandardAddress.HouseNumber,
      Customer._StandardAddress.Building
}
where
      Item.Customer    <> ''
  and Item.Customer    is not null
  and Item.RO_SAFTCustomerTaxType     <> '7'
  and Item.PostingDate between $parameters.P_FromPostingDate and $parameters.P_ToPostingDate
  and Item.RO_SAFTStandardAccount <> ''
  and Item.RO_SAFTStandardAccount is not null
  and Item.FinancialAccountType = 'D'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"C_RO_SAFTJOURNALENTRYITEMC",
"I_ADDRESS",
"I_BUSINESSPARTNER",
"I_COUNTRY",
"I_CUSTOMER",
"I_CUSTOMERTOBUSINESSPARTNER"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More