I_CustomerPurchaseOrderTypeTxt

DDL: I_CUSTOMERPURCHASEORDERTYPETXT SQL: ICUSTPOTYPETXT Type: view BASIC

Customer Purchase Order Type - Text

I_CustomerPurchaseOrderTypeTxt is a Basic CDS View that provides data about "Customer Purchase Order Type - Text" in SAP S/4HANA. It reads from 1 data source (t176t) and exposes 5 fields with key fields CustomerPurchaseOrderType, Language. It has 2 associations to related views.

1 data source(s) 5 fields

Data Sources (1)

SourceAliasJoin Type
t176t t176t from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_CustomerPurchaseOrderType _CustomerPurchaseOrderType $projection.CustomerPurchaseOrderType = _CustomerPurchaseOrderType.CustomerPurchaseOrderType
[0..1] I_Language _Language $projection.Language = _Language.Language

Annotations (15)

NameValueLevelField
AbapCatalog.sqlViewName ICUSTPOTYPETXT view
EndUserText.label Customer Purchase Order Type - Text view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.dataCategory #TEXT view
ObjectModel.usageType.dataClass #META view
ObjectModel.representativeKey CustomerPurchaseOrderType view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
Analytics.dataExtraction.enabled true view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #NOT_REQUIRED view
AbapCatalog.buffering.status #ACTIVE view
AbapCatalog.buffering.type #FULL view
Search.searchable true view
Metadata.ignorePropagatedAnnotations true view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY CustomerPurchaseOrderType bsark
KEY Language spras
CustomerPurchaseOrderTypeDesc
_CustomerPurchaseOrderType _CustomerPurchaseOrderType
_Language _Language 
@AbapCatalog.sqlViewName: 'ICUSTPOTYPETXT'
@EndUserText.label: 'Customer Purchase Order Type - Text'
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.dataCategory: #TEXT
@ObjectModel.usageType.dataClass: #META 
@ObjectModel.representativeKey: 'CustomerPurchaseOrderType'
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #S
@ObjectModel.supportedCapabilities: [ #LANGUAGE_DEPENDENT_TEXT, #CDS_MODELING_ASSOCIATION_TARGET, #SQL_DATA_SOURCE,
                                      #CDS_MODELING_DATA_SOURCE, #SEARCHABLE_ENTITY, #EXTRACTION_DATA_SOURCE ]
@ObjectModel.modelingPattern: [ #LANGUAGE_DEPENDENT_TEXT ]
@Analytics.dataExtraction.enabled: true
@VDM.viewType: #BASIC
@AccessControl.authorizationCheck:#NOT_REQUIRED
@AbapCatalog.buffering.status: #ACTIVE
@AbapCatalog.buffering.type: #FULL
@Search.searchable: true
@Metadata.ignorePropagatedAnnotations:true
define view I_CustomerPurchaseOrderTypeTxt 
    as select from t176t
    association [0..1] to I_CustomerPurchaseOrderType as _CustomerPurchaseOrderType on $projection.CustomerPurchaseOrderType = _CustomerPurchaseOrderType.CustomerPurchaseOrderType
    association [0..1] to I_Language                  as _Language                  on $projection.Language = _Language.Language
{
        @ObjectModel.foreignKey.association: '_CustomerPurchaseOrderType'
    key bsark as  CustomerPurchaseOrderType,
    
        @ObjectModel.foreignKey.association: '_Language'
        @Semantics.language: true
    key spras as Language,

        @Search.defaultSearchElement: true
        @Search.fuzzinessThreshold: 0.8
        @Semantics.text: true
        cast(vtext as bezei20)     as CustomerPurchaseOrderTypeDesc,

        //Associations

        _CustomerPurchaseOrderType,
        _Language
};

Learn More