CIC_PlantData

DDL: CIC_PLANTDATA Type: view_entity Package: CIC_PLANT

Proj. View on Plant Data

CIC_PlantData is a CDS View that provides data about "Proj. View on Plant Data" in SAP S/4HANA. It reads from 1 data source (t001w) and exposes 17 fields with key field Plant. It has 1 association to related views. Part of development package CIC_PLANT.

1 data source(s) 17 fields

Data Sources (1)

SourceAliasJoin Type
t001w t001w from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_ValuationArea _ValuationArea $projection.ValuationArea = _ValuationArea.ValuationArea

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Proj. View on Plant Data view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #CUSTOMIZING view

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY Plant werks
PlantName name1
Country land1
ValuationArea bwkey
PlantCustomer kunnr
PlantSupplier lifnr
FactoryCalendar fabkl
DefaultPurchasingOrganization ekorg
SalesOrganization vkorg
AddressID adrnr
PlantCategory vlfkz
DistributionChannel vtweg
Division spart
Language spras
IsMarkedForArchiving achvm
ShippingPoint vstel
CompanyCode _ValuationArea CompanyCode 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Proj. View on Plant Data'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
    serviceQuality: #A,
    sizeCategory: #S,
    dataClass: #CUSTOMIZING
}
define view entity CIC_PlantData
  as select from t001w
  association [0..1] to I_ValuationArea as _ValuationArea on $projection.ValuationArea = _ValuationArea.ValuationArea
{
  key werks as Plant,
      name1 as PlantName,
      land1 as Country,
      bwkey as ValuationArea,
      kunnr as PlantCustomer,
      lifnr as PlantSupplier,
      fabkl as FactoryCalendar,
      ekorg as DefaultPurchasingOrganization,
      vkorg as SalesOrganization,
      adrnr as AddressID,
      vlfkz as PlantCategory,
      vtweg as DistributionChannel,
      spart as Division,
      spras as Language,
      achvm as IsMarkedForArchiving,
      vstel as ShippingPoint,
      _ValuationArea.CompanyCode
}

Learn More