C_RO_SAFTCustomerC

DDL: C_RO_SAFTCUSTOMERC SQL: CROSAFTCUSTOMERC Type: view CONSUMPTION Package: GLO_FIN_IS_SAFT_RO
21 Fields 1 Data Sources

Customer Data for RO SAFT - Cube

C_RO_SAFTCustomerC is a Consumption CDS View (Cube) that provides data about "Customer Data for RO SAFT - Cube" in SAP S/4HANA. It reads from 1 data source (P_RO_SAFTCustomer) and exposes 21 fields with key fields SourceLedger, Ledger, CompanyCode, Customer, TaxID5. Part of development package GLO_FIN_IS_SAFT_RO.

Data Sources (1)

SourceAliasJoin Type
P_RO_SAFTCustomer P_RO_SAFTCustomer from

Parameters (4)

NameTypeDefault
P_FromPostingDate dats
P_ToPostingDate dats
P_FiscalYear gjahr
P_AlternativeGLAccountIsUsed saft_ro_alt_gl_account_flag

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName CROSAFTCUSTOMERC view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
VDM.viewType #CONSUMPTION view
Analytics.dataCategory #CUBE view
Analytics.internalName #LOCAL 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 #MANDATORY view
Metadata.allowExtensions true view
EndUserText.label Customer Data for RO SAFT - Cube view

Fields (21)

KeyFieldSource TableSource FieldDescription
KEY SourceLedger SourceLedger Source Ledger
KEY Ledger Ledger Ledger
KEY CompanyCode CompanyCode Receiver Company Code
KEY Customer Customer Sold-to Party
KEY TaxID5 TaxID5 Tax Number 5
KEY RO_SAFTStandardAccount RO_SAFTStandardAccount
GLAccount General Ledger
BusinessPartner BusinessPartner Issuing Authority
CustomerName CustomerName Name of Customer
CountryISOCode CountryISOCode
Region Region Venue Region
PostalCode PostalCode Postal Code
CityName
StreetName StreetName Text
HouseNumber HouseNumber House Number
Building Building Building code
CompanyCodeCurrency CompanyCodeCurrency Local Currency
ItemIsReportingRelevant
StatryRptCategory
StatryRptgEntity
StatryRptRunID

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view C_RO_SAFTCustomerC.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: CROSAFTCUSTOMERC
-- Parameters: P_FromPostingDate : dats, P_ToPostingDate : dats, P_FiscalYear : gjahr, P_AlternativeGLAccountIsUsed : saft_ro_alt_gl_account_flag

CREATE VIEW C_RO_SAFTCustomerC AS
SELECT
  SourceLedger,
  Ledger,
  CompanyCode,
  Customer,
  TaxID5,
  RO_SAFTStandardAccount,
  cast(GLAccount as fis_racct) AS GLAccount,
  BusinessPartner,
  CustomerName,
  CountryISOCode,
  Region,
  PostalCode,
  left(CityName, 35) AS CityName,
  StreetName,
  HouseNumber,
  Building,
  CompanyCodeCurrency,
  'X' AS ItemIsReportingRelevant,
  ' ' AS StatryRptCategory,
  ' ' AS StatryRptgEntity,
  '00000000' AS StatryRptRunID
FROM P_RO_SAFTCustomer
;

Learn More