PurchaseDocumentTypesMD
Source SQL File - Google Cloud Cortex Data Foundation
Google Cloud Cortex Foudantion - Cortex Reporting - (s4) - PurchaseDocumentTypesMD
Overview
This view provides information about purchasing document types in SAP systems. It includes fields such as the purchasing document type, category, and text, as well as various control indicators and settings.
Data Sources
| Source Table/View | Description |
|---|---|
| t161 | Purchasing Document Types |
| t161t | Purchasing Document Types Texts |
Key Use Cases
- This view can be used to retrieve information about the different types of purchasing documents that are used in an SAP system.
- It can also be used to determine the settings and control indicators that are associated with each document type.
Query Logic
The view joins the t161 and t161t tables on the MANDT, BSART, and BSTYP fields. This ensures that the data from both tables is correctly aligned.
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 |
| ME29N | Cancel 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 |