_PURCHASEORDERTP

_PURCHASEORDERTP is an SAP database table in S/4HANA. It contains 13 fields.

Fields (13)

KeyField CDS FieldsUsed in Views
_IncotermsVersion _IncotermsVersion 1
_PurchasingGroup _PurchasingGroup 1
_PurchasingOrganization _PurchasingOrganization 1
CompanyCode CompanyCode 1
CreatedByUser CreatedByUser 1
CreationDate DocumentCreationDate 1
DocumentCurrency DocumentCurrency 1
IncotermsVersion IncotermsVersion 1
PurchaseOrderType PurchaseOrderType,PurchasingDocumentType 3
PurchasingGroup PurchasingGroup 3
PurchasingOrganization PurchasingOrganization 3
PurchasingProcessingStatus PurchasingProcessingStatus 1
Supplier Supplier 4

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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE _PURCHASEORDERTP (
    _INCOTERMSVERSION,
    _PURCHASINGGROUP,
    _PURCHASINGORGANIZATION,
    COMPANYCODE,
    CREATEDBYUSER,
    CREATIONDATE,
    DOCUMENTCURRENCY,
    INCOTERMSVERSION,
    PURCHASEORDERTYPE,
    PURCHASINGGROUP,
    PURCHASINGORGANIZATION,
    PURCHASINGPROCESSINGSTATUS,
    SUPPLIER
);