I_PURCHASINGDOCUMENTTYPE

CDS View

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)

ViewTypeJoinVDMDescription
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)

KeyField CDS FieldsUsed 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)
);