P_RFQDocumentType

DDL: P_RFQDOCUMENTTYPE SQL: PMMRFQDOCTYP Type: view CONSUMPTION
5 Fields 1 Data Sources

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.

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 Source doc.cat.
KEY PurchasingDocumentType t161 bsart Stnd purch.ord.
RFQExternalProcessingType t161 rfq_process_type External Processing
RFQcXMLProcessType _RFQExtProcessingTypeText rfq_cxml_process_type
RFQAwardingType t161 rfx_processing_cd RFQ Awarding Type

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view P_RFQDocumentType.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: PMMRFQDOCTYP

CREATE VIEW P_RFQDocumentType AS
SELECT
  t161.bstyp AS PurchasingDocumentCategory,
  t161.bsart AS PurchasingDocumentType,
  t161.rfq_process_type AS RFQExternalProcessingType,
  _RFQExtProcessingTypeText.rfq_cxml_process_type AS RFQcXMLProcessType,
  t161.rfx_processing_cd AS RFQAwardingType
FROM t161
;

Learn More