P_SDDocumentType

DDL: P_SDDOCUMENTTYPE Type: view BASIC

P_SDDocumentType is a Basic CDS View in SAP S/4HANA. It reads from 3 data sources (I_BillingDocumentType, I_DeliveryDocumentType, I_SalesDocumentType) and exposes 2 fields with key fields SDDocumentType, SDDocumentCategory.

3 data source(s) 2 fields

Data Sources (3)

SourceAliasJoin Type
I_BillingDocumentType I_BillingDocumentType from
I_DeliveryDocumentType I_DeliveryDocumentType union_all
I_SalesDocumentType I_SalesDocumentType union_all

Annotations (10)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName PSDDOCTYPE view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.representativeKey SDDocumentType view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
VDM.private true view
VDM.viewType #BASIC view

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY SDDocumentType BillingDocumentType
KEY SDDocumentCategory SDDocumentCategory 
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog: {
  sqlViewName: 'PSDDOCTYPE',
  preserveKey: true
}
@AccessControl.authorizationCheck:#NOT_REQUIRED
@ObjectModel.representativeKey: 'SDDocumentType'
@ObjectModel.usageType.dataClass: #CUSTOMIZING 
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #S
@VDM.private: true
@VDM.viewType: #BASIC

define view P_SDDocumentType  
  as select from I_BillingDocumentType {
     
  key BillingDocumentType as SDDocumentType,
  key SDDocumentCategory 
}
  union all select from I_DeliveryDocumentType { 
  
  key DeliveryDocumentType as SDDocumentType,
  key SDDocumentCategory   
} 
  union all select from I_SalesDocumentType { 
  
  key SalesDocumentType as SDDocumentType,
  key SDDocumentCategory   
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BILLINGDOCUMENTTYPE",
"I_DELIVERYDOCUMENTTYPE",
"I_SALESDOCUMENTTYPE"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More