I_PPS_PurContrDocType

DDL: I_PPS_PURCONTRDOCTYPE Type: view_entity BASIC

PPS Relevant Purchase Contract Types

I_PPS_PurContrDocType is a Basic CDS View that provides data about "PPS Relevant Purchase Contract Types" in SAP S/4HANA. It reads from 1 data source (t161) and exposes 4 fields with key fields PurchasingDocumentCategory, PurchaseContractType. It has 1 association to related views.

1 data source(s) 4 fields

Data Sources (1)

SourceAliasJoin Type
t161 t161 from

Associations (1)

CardinalityTargetAliasCondition
[1..1] t161t _Text $projection.PurchaseContractType = _Text.bsart and $projection.PurchasingDocumentCategory = _Text.bstyp and _Text.spras = $session.system_language

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label PPS Relevant Purchase Contract Types view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #BASIC view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY PurchasingDocumentCategory bstyp
KEY PurchaseContractType bsart
IsDefaultDocument default_doc_ty
PurchasingDocumentTypeName _Text batxt 
@AbapCatalog.viewEnhancementCategory: [#NONE]

@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'PPS Relevant Purchase Contract Types'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
    serviceQuality: #X,
    sizeCategory: #S,
    dataClass: #MIXED
}
@VDM.viewType: #BASIC
 // @JIRA-KEY<S4PPS-10691>   

define view entity I_PPS_PurContrDocType  as select from t161
 association [1..1] to t161t as _Text on  $projection.PurchaseContractType = _Text.bsart
                                       and $projection.PurchasingDocumentCategory = _Text.bstyp
                                       and _Text.spras       = $session.system_language
{
    key bstyp as PurchasingDocumentCategory,
    key bsart as PurchaseContractType ,
    default_doc_ty as IsDefaultDocument,
    @Semantics.text: true
    _Text.batxt as PurchasingDocumentTypeName

}

 where pps_relevant = 'X' and

   bstyp = 'K'
 
                   ;
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"T161",
"T161T"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More