P_RFQDocumentType

DDL: P_RFQDOCUMENTTYPE SQL: PMMRFQDOCTYP Type: view CONSUMPTION

P_RFQDocumentType is a Consumption CDS View in SAP S/4HANA. It reads from 1 data source (t161) and exposes 5 fields with key fields PurchasingDocumentCategory, PurchasingDocumentType.

1 data source(s) 5 fields

Data Sources (1)

SourceAliasJoin Type
t161 t161 from

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName PMMRFQDOCTYP view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #CONSUMPTION view
VDM.private true view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY PurchasingDocumentCategory t161 bstyp
KEY PurchasingDocumentType t161 bsart
RFQExternalProcessingType t161 rfq_process_type
RFQcXMLProcessType _RFQExtProcessingTypeText rfq_cxml_process_type
RFQAwardingType t161 rfx_processing_cd 
@AbapCatalog.sqlViewName: 'PMMRFQDOCTYP'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.viewType : #CONSUMPTION
@VDM.private: true
@ClientHandling.algorithm: #SESSION_VARIABLE
define view P_RFQDocumentType as select from t161  
join mmpur_rfq_pr_ty as _RFQExtProcessingTypeText on t161.rfq_process_type = _RFQExtProcessingTypeText.rfq_process_type
{
  key t161.bstyp as PurchasingDocumentCategory,
  key t161.bsart as PurchasingDocumentType, 
  t161.rfq_process_type as RFQExternalProcessingType, 
  _RFQExtProcessingTypeText.rfq_cxml_process_type as RFQcXMLProcessType,
  t161.rfx_processing_cd as RFQAwardingType   
} where bstyp = 'R'                 
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"MMPUR_RFQ_PR_TY",
"T161"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More