C_SustCompanyCodeAddressDEX

DDL: C_SUSTCOMPANYCODEADDRESSDEX Type: view CONSUMPTION Package: VDM_SUS_FND_EXTRACTION

Company Code Address data extractor

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

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 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 _OrgAddressDefaultRprstn Country
Region _OrgAddressDefaultRprstn Region
CityName _OrgAddressDefaultRprstn CityName
PostalCode _OrgAddressDefaultRprstn PostalCode
StreetName _OrgAddressDefaultRprstn StreetName
HouseNumber _OrgAddressDefaultRprstn HouseNumber 
@EndUserText.label: 'Company Code Address data extractor'
@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,
      _OrgAddressDefaultRprstn.Country,
      _OrgAddressDefaultRprstn.Region,
      _OrgAddressDefaultRprstn.CityName,
      _OrgAddressDefaultRprstn.PostalCode,
      _OrgAddressDefaultRprstn.StreetName,
      _OrgAddressDefaultRprstn.HouseNumber
}where _CompanyCode.AddressID <> ''

Learn More