I_PURCHASINGDOCUMENTTYPE
Purchasing Document Type
I_PURCHASINGDOCUMENTTYPE is a CDS View in S/4HANA. Purchasing Document Type. It contains 3 fields. 51 CDS views read from this table.
CDS Views using this table (51)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| C_CFinPurchaseOrderTypeVH | view | from | CONSUMPTION | CFin Value Help for Purchase Order Types |
| C_CntrlPurContrHierTypeVH | view | from | CONSUMPTION | Contract Type VH in Central Purchase Contract Hierarchy |
| C_CntrlPurContrTypeValueHelp | view | from | CONSUMPTION | View for Contract Type F4 Help in Central Purchase Contract |
| C_POItemOrderTypeValueHelp | view | from | CONSUMPTION | Order Type Value Help |
| C_POMntnDocumentTypeValueHelp | view | from | CONSUMPTION | Value Help for Order Types in "Manage Purchase Orders" |
| C_PurchaseOrderTypeValueHelp | view | from | CONSUMPTION | Purchase Order Type |
| C_PurchaseOrderWorkflowEmail | view | left_outer | CONSUMPTION | Purchase Order Details for Workflow Deadline Email |
| C_PurchasingDocTypeValueHelp | view | from | CONSUMPTION | Purchasing Doc Type Value Help |
| C_PurchasingDocTypeVH | view | from | CONSUMPTION | Purchasing Doc Type VH |
| C_PurReqnTypeForWorkflow | view | from | CONSUMPTION | Purchasing Document Type |
| C_RfqTypeVH | view | from | CONSUMPTION | Value help for RFQ Type |
| C_SchedAgrmtMassUpdtTypeVH | view | from | CONSUMPTION | Value Help for Scheduling Agreement Type |
| C_SegmtnPurOrderTypeVH_F9070 | view_entity | from | CONSUMPTION | Purchasing Order Type |
| C_SSPPurchasingDocumentType | view | from | CONSUMPTION | Purchasing Document Type Value Help |
| C_SubordinateCntrlContrTypeVH | view | from | CONSUMPTION | Contract Type VH for Subordinate Central Contracts |
| I_ARunRequirementDocumentType | view | union | BASIC | Requirement document type |
| I_ARunSupSelRulePurOrdTypeVH | view | from | BASIC | |
| I_ARunSupSelRulePurReqnTypeVH | view | from | BASIC | |
| I_CentralSupplierQuotationType | view | from | BASIC | Basic View for Central Supplier Quotation Type |
| I_CnsldtnRlvtStkTransptDocType | view_entity | from | COMPOSITE | Consolidation stock transport doc types |
| I_CntrlPurContrClassification | view | from | BASIC | Central Purchase Contract Classification |
| I_CntrlReqForQuotationType | view | from | BASIC | Basic view for Central Request For Quotation Type Value Help |
| I_MRPExtRqmtOrderTypeText | view_entity | union_all | BASIC | External Requirements Order Type - Text |
| I_PPS_PurchaseOrdItemCategory | view_entity | from | BASIC | Purchase Order Item Type |
| I_PPS_PurchaseReqnDocumentType | view_entity | from | BASIC | Purchase Requisition Document Type |
| I_PPS_PurchaseReqnItemCategory | view_entity | from | BASIC | Item Category for Purchase Requisition |
| I_PPS_PurchaseReqnSOSContract | view_entity | inner | COMPOSITE | PPS Contracts for PurReqn Assign SOS |
| I_PPS_PurchasingDocumentType | view_entity | from | BASIC | Purchasing Document Type |
| I_PPS_PurContrHdrPrtnFuncVH | view_entity | from | BASIC | PPS Purchase Contract Header Partners |
| I_PPS_PurContrItemCategory | view_entity | from | BASIC | Item Category for PPS Purchase Contract |
| I_PPS_PurContrItmPrtnFuncVH | view_entity | from | BASIC | PPS Purchase Contract Item Partners |
| I_PPS_PurgDocCntctAll | view_entity | inner | BASIC | Doc Type generated from asterisk values |
| I_PPS_PurgDocTypeVH | view_entity | from | COMPOSITE | Purchasing Document Type |
| I_PPS_PurOrdDocType | view_entity | from | BASIC | PPS Relevant Purchase Order Types |
| I_PPS_PurOrdHdrPrtnFuncVH | view_entity | from | COMPOSITE | Purchase Order Header Partner function |
| I_PPS_PurOrdItmPrtnFuncVH | view_entity | from | COMPOSITE | Purchase Order Item Partner function |
| I_PurchaseContractType | view | from | BASIC | Purchase Contract Type |
| I_Purchasecontracttype_Vh | view | from | BASIC | Value Help for Purchase contract |
| I_PurchaseOrderType | view | from | BASIC | Purchase Order Type |
| I_PurchaseReqnDocumentType | view | from | BASIC | Purchase Requisition Document Type |
| I_PurchaseRequisitionType | view | from | BASIC | Purchase Requisition Document Type |
| I_PurContractPartnerFunctionVH | view | from | COMPOSITE | Pur. Contr. Partner Function Value Help |
| I_RequestForQuotationType | view | from | BASIC | RFQ Type |
| I_Schedgagrmttypevh | view | from | BASIC | Scheduling Agreement Document Type |
| I_SupplierQuotationType | view | from | BASIC | Supplier Quotation Type |
| P_CntrlPurContrClassification | view | from | BASIC | |
| P_MMIM_PURDOCTY_M_BEST_BSA_01 | view | from | COMPOSITE | |
| P_MRPExtRqmtOrderType | view_entity | union_all | BASIC | |
| P_POItemOrderTypeValueHelp | view | from | CONSUMPTION | PView for PO type Value help |
| P_WrkflwPurchaseOrderItem | view | inner | CONSUMPTION | P View of Purchase Order item Workflow |
| P_WrkflwPurRequisitionItem | view | inner | CONSUMPTION |
Fields (3)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | PurchasingDocumentCategory | PurchasingDocumentCategory | 4 |
| KEY | PurchasingDocumentType | ARunSupplySelRuleAttribVal,PurchaseRequisitionType,PurchasingDocumentType,RFQType,SuplrQtnType | 15 |
| _Category | _Category | 2 |
Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.
-- Purchasing Document Type
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_PURCHASINGDOCUMENTTYPE (
PURCHASINGDOCUMENTCATEGORY,
PURCHASINGDOCUMENTTYPE,
_CATEGORY,
PRIMARY KEY (PURCHASINGDOCUMENTCATEGORY, PURCHASINGDOCUMENTTYPE)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA