C_TranspPurchasingOrgVH

DDL: C_TRANSPPURCHASINGORGVH Type: view CONSUMPTION

Transp Purchasing Organization VH

C_TranspPurchasingOrgVH is a Consumption CDS View that provides data about "Transp Purchasing Organization VH" in SAP S/4HANA. It reads from 1 data source (I_TranspOrganizationalUnit) and exposes 5 fields with key field OrganizationalUnit.

1 data source(s) 5 fields

Data Sources (1)

SourceAliasJoin Type
I_TranspOrganizationalUnit I_TranspOrganizationalUnit from

Annotations (15)

NameValueLevelField
AbapCatalog.compiler.compareFilter true view
AbapCatalog.sqlViewName CTRANSPPURORGVH view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
AccessControl.personalData.blocking #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.representativeKey OrganizationalUnit view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #CUSTOMIZING view
Search.searchable true view
VDM.viewType #CONSUMPTION view
VDM.lifecycle.contract.type #NONE view
EndUserText.label Transp Purchasing Organization VH view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY OrganizationalUnit OrganizationalUnit
OrgUnitValidityStartDate OrgUnitValidityStartDate
OrgUnitValidityEndDate OrgUnitValidityEndDate
OrganizationalUnitExternalID
OrganizationalUnitName 
@AbapCatalog:              {compiler:                   {compareFilter: true},
                            sqlViewName:                'CTRANSPPURORGVH',
                            preserveKey:                true}
@AccessControl:            {authorizationCheck:         #NOT_REQUIRED, 
                            personalData.blocking:      #NOT_REQUIRED}
@ClientHandling.algorithm:  #SESSION_VARIABLE
@ObjectModel:              {representativeKey:          'OrganizationalUnit',
                            dataCategory:               #VALUE_HELP,
                            usageType:                  {serviceQuality: #C,
                                                         sizeCategory:   #L,
                                                         dataClass:      #CUSTOMIZING}}
@Search:                   {searchable: true}
@VDM:                      {viewType:                    #CONSUMPTION,
                            lifecycle.contract.type:     #NONE }

@EndUserText.label:         'Transp Purchasing Organization VH'



define view C_TranspPurchasingOrgVH
  as select from I_TranspOrganizationalUnit       
{
      @UI.hidden: true
  key OrganizationalUnit,
      @UI.hidden: true
      OrgUnitValidityStartDate,
      @UI.hidden: true
      OrgUnitValidityEndDate,
      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.8
      @Search.ranking: #HIGH
      cast ( OrganizationalUnitExternalID as /scmb/pur_org_ext_id preserving type ) as OrganizationalUnitExternalID,
      cast ( _OrganizationalUnitText[1:Language = $session.system_language ].OrganizationalUnitName as /scmb/org_descr preserving type ) as OrganizationalUnitName
}
where
      OrganizationalUnitFunction = '2'
  and OrganizationalUnitRole     = '1'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_TRANSPORGANIZATIONALUNIT",
"I_TRANSPORGANIZATIONALUNITTEXT"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More