C_RO_SAFTSupplierC

DDL: C_RO_SAFTSUPPLIERC SQL: CROSAFTSUPPLIERC Type: view CONSUMPTION
21 Fields 1 Data Sources

Supplier Data for RO SAFT - Cube

C_RO_SAFTSupplierC is a Consumption CDS View (Cube) that provides data about "Supplier Data for RO SAFT - Cube" in SAP S/4HANA. It reads from 1 data source (P_RO_SAFTSupplier) and exposes 21 fields with key fields SourceLedger, Ledger, CompanyCode, Supplier, TaxID5.

Data Sources (1)

SourceAliasJoin Type
P_RO_SAFTSupplier P_RO_SAFTSupplier 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 CROSAFTSUPPLIERC 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 Supplier 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 Supplier Supplier Supplier
KEY TaxID5 TaxID5 Tax Number 5
KEY RO_SAFTStandardAccount RO_SAFTStandardAccount
GLAccount General Ledger
BusinessPartner BusinessPartner Issuing Authority
SupplierName SupplierName Supplier Name
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_SAFTSupplierC.
-- 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: CROSAFTSUPPLIERC
-- Parameters: P_FromPostingDate : dats, P_ToPostingDate : dats, P_FiscalYear : gjahr, P_AlternativeGLAccountIsUsed : saft_ro_alt_gl_account_flag

CREATE VIEW C_RO_SAFTSupplierC AS
SELECT
  SourceLedger,
  Ledger,
  CompanyCode,
  Supplier,
  TaxID5,
  RO_SAFTStandardAccount,
  cast(GLAccount as fis_racct) AS GLAccount,
  BusinessPartner,
  SupplierName,
  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_SAFTSupplier
;

Learn More