fac_ad_cds_vendor

DDL: FAC_AD_CDS_VENDOR SQL: FACADV_VENDOR Type: view

Value-Help for Suppliers

fac_ad_cds_vendor is a CDS View that provides data about "Value-Help for Suppliers" in SAP S/4HANA. It reads from 1 data source (lfa1) and exposes 15 fields with key field lifnr.

1 data source(s) 15 fields

Data Sources (1)

SourceAliasJoin Type
lfa1 lfa1 from

Annotations (11)

NameValueLevelField
EndUserText.label Value-Help for Suppliers view
AbapCatalog.sqlViewName FACADV_VENDOR view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
AccessControl.personalData.blocking #REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.dataCategory #VALUE_HELP view
Metadata.ignorePropagatedAnnotations true view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY lifnr lifnr
sortl sortl
land1 land1
pstlz pstlz
mcod3 mcod3
mcod1 mcod1
ktokk ktokk
ort01 ort01
name1 name1
stcd1 stcd1
stcd2 stcd2
stcd3 stcd3
stcd4 stcd4
stcd5 stcd5
stceg stceg 
@EndUserText.label: 'Value-Help for Suppliers'
@AbapCatalog.sqlViewName: 'FACADV_VENDOR'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@AccessControl.personalData.blocking: #REQUIRED
@ClientHandling.algorithm : #SESSION_VARIABLE
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.dataCategory: #VALUE_HELP
@Metadata.ignorePropagatedAnnotations: true

define view fac_ad_cds_vendor as select from lfa1
{
    key lifnr,

       sortl,
       land1,
       pstlz,
       mcod3,
       mcod1,
       ktokk,
       ort01,
       name1,
       stcd1,
       stcd2,
       stcd3,
       stcd4,
       stcd5,
       stceg
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"LFA1"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More