C_RO_SAFTCustomer

DDL: C_RO_SAFTCUSTOMER SQL: CROSAFTCUSTOMER Type: view CONSUMPTION
20 Fields 1 Data Sources

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.

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 Source Ledger
KEY Ledger Item Ledger Ledger
KEY CompanyCode Item CompanyCode Receiver Company Code
KEY Customer Item Customer Sold-to Party
KEY StatryRptCategory Item StatryRptCategory Report ID
KEY StatryRptgEntity Item StatryRptgEntity Reporting Entity
KEY StatryRptRunID Item StatryRptRunID Report Run ID
KEY RO_SAFTStandardAccount Item RO_SAFTStandardAccount
TaxID5 Item CustomerTaxID5
ChartOfAccounts Item ChartOfAccounts Node Class
GLAccount Item GLAccount General Ledger
BusinessPartner
CustomerName I_Customer OrganizationBPName1 Name 1
CountryISOCode
Region
PostalCode
CityName
StreetName
HouseNumber
Building

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_SAFTCustomer.
-- 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: CROSAFTCUSTOMER
-- Parameters: P_FromPostingDate : dats, P_ToPostingDate : dats, P_AlternativeGLAccountIsUsed : saft_ro_alt_gl_account_flag

CREATE VIEW C_RO_SAFTCustomer AS
SELECT
  Item.SourceLedger AS SourceLedger,
  Item.Ledger AS Ledger,
  Item.CompanyCode AS CompanyCode,
  Item.Customer AS Customer,
  Item.StatryRptCategory AS StatryRptCategory,
  Item.StatryRptgEntity AS StatryRptgEntity,
  Item.StatryRptRunID AS StatryRptRunID,
  Item.RO_SAFTStandardAccount AS RO_SAFTStandardAccount,
  Item.CustomerTaxID5 AS TaxID5,
  Item.ChartOfAccounts AS ChartOfAccounts,
  Item.GLAccount AS GLAccount,
  Customer._CustomerToBusinessPartner._BusinessPartner.BusinessPartner AS BusinessPartner,
  Customer.OrganizationBPName1 AS CustomerName,
  cast( Customer._StandardAddress._Country.CountryISOCode as land1 ) AS CountryISOCode,
  Customer._StandardAddress.Region AS Region,
  Customer._StandardAddress.PostalCode AS PostalCode,
  Customer._StandardAddress.CityName AS CityName,
  Customer._StandardAddress.StreetName AS StreetName,
  Customer._StandardAddress.HouseNumber AS HouseNumber,
  Customer._StandardAddress.Building AS Building
INNER JOIN I_Customer AS Customer ON /* join condition not captured in parsed metadata */
;

Learn More