C_SustCompanyCodeAddressDEX

DDL: C_SUSTCOMPANYCODEADDRESSDEX Type: view CONSUMPTION

Company Code Address data extractor for PFM

C_SustCompanyCodeAddressDEX is a Consumption CDS View (Fact) that provides data about "Company Code Address data extractor for PFM" in SAP S/4HANA. It reads from 1 data source (I_CompanyCode) and exposes 8 fields with key field CompanyCode.

1 data source(s) 8 fields

Data Sources (1)

SourceAliasJoin Type
I_CompanyCode _CompanyCode from

Annotations (17)

NameValueLevelField
EndUserText.label Company Code Address data extractor for PFM view
AbapCatalog.sqlViewName CSUSTCCADRSDEX view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
AccessControl.personalData.blocking #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.sapObjectNodeType.name CompanyCode view
ObjectModel.modelingPattern #NONE view
VDM.viewType #CONSUMPTION view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
Analytics.dataCategory #FACT view
Analytics.internalName #LOCAL view
Analytics.dataExtraction.enabled true view
Metadata.ignorePropagatedAnnotations true view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_CompanyCode CompanyCode
AddressID I_CompanyCode AddressID
Country _Address Country
Region _Address Region
CityName _Address CityName
PostalCode _Address PostalCode
StreetName _Address StreetName
HouseNumber _Address HouseNumber 
@EndUserText.label: 'Company Code Address data extractor for PFM'
@AbapCatalog: {
    sqlViewName: 'CSUSTCCADRSDEX',
    compiler.compareFilter: true
}
@AccessControl: {
     authorizationCheck: #PRIVILEGED_ONLY,
     personalData.blocking: #NOT_REQUIRED
}
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel: {
      usageType: {
         sizeCategory: #XL,
         serviceQuality: #C,
         dataClass:#CUSTOMIZING
      },
      sapObjectNodeType.name: 'CompanyCode',
      supportedCapabilities: [#EXTRACTION_DATA_SOURCE],
      modelingPattern: #NONE
}
@VDM: {
      viewType: #CONSUMPTION,
      lifecycle.contract.type: #PUBLIC_LOCAL_API
}
@Analytics: {
        dataCategory: #FACT,
        internalName: #LOCAL,
        dataExtraction.enabled: true
}
@Metadata: {
        ignorePropagatedAnnotations: true
}

define view C_SustCompanyCodeAddressDEX
  as select from I_CompanyCode as _CompanyCode
{
  key _CompanyCode.CompanyCode,
      _CompanyCode.AddressID,
      _Address.Country,
      _Address.Region,
      _Address.CityName,
      _Address.PostalCode,
      _Address.StreetName,
      _Address.HouseNumber
}where _CompanyCode.AddressID <> ''
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_ADDRESS",
"I_COMPANYCODE"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More