PurchaseDocumentTypesMD
Source SQL File - Google Cloud Cortex Data Foundation
Google Cloud Cortex Foudantion - Cortex Reporting - (ecc) - PurchaseDocumentTypesMD
Overview
This view provides information about purchasing document types in SAP systems. It includes data on document type, category, and various control settings.
Data Sources
| Source Table/View | Description |
|---|---|
| t161 | Purchasing Document Types |
| t161t | Purchasing Document Types Texts |
Key Use Cases
- Understanding different types of purchasing documents in SAP
- Customizing purchasing document settings
- Analyzing purchasing processes and identifying areas for improvement
Query Logic
The view joins the t161 and t161t tables on the MANDT, BSART, and BSTYP fields to retrieve both purchasing document type data and corresponding texts.
Possible relation with SAP Transactions
| Transaction Code | Transaction Description |
|---|---|
| ME21N | Create Purchase Order |
| ME22N | Change Purchase Order |
| ME23N | Display Purchase Order |
| ME28 | Release Purchase Order |
Data Lineage
Under Development
Table/View Fields
| Field | Field Description | Description in SAP Dictionary (Comming soon) |
|---|---|---|
| Client_MANDT | Client | |
| PurchasingDocumentType_BSART | Purchasing Document Type | |
| PurchasingDocumentCategory_BSTYP | Purchasing Document Category | |
| PurchasingDocumentTypeText_BATXT | Purchasing Document Type Text | |
| Language_SPRAS | Language |