PURCHASEORDER

37 Fields

PURCHASEORDER is an SAP database table in S/4HANA. It contains 37 fields.

Fields (37)

KeyField CDS FieldsUsed in Views
KEY AccountAssignmentNumber AccountAssignmentNumber 1
KEY PurchaseOrder PurchaseOrder 6
KEY PurchaseOrderItem PurchaseOrderItem 1
KEY PurchasingDocument PurchaseOrder 1
AccountingDocument AccountingDocument 1
CalendarMonth CalendarMonth 1
CalendarQuarter CalendarQuarter 1
CalendarWeek CalendarWeek 1
CalendarYear CalendarYear 1
CompanyCode CompanyCode 7
CostCenter CostCenter 1
DocumentDate DocumentDate 2
InspectionLotCreatedOn InspectionLotCreatedOn 1
IsEndOfPurposeBlocked IsEndOfPurposeBlocked 1
Material Material 1
MaterialGroup MaterialGroup 1
Plant Plant 1
procstat PurchasingProcessingStatus 1
ProductType ProductTypeCode 1
PurchaseOrderDate PurchaseOrderDate 1
PurchaseOrderType PurchaseOrderType 1
PurchasingCompletenessStatus PurchasingCompletenessStatus 2
PurchasingDocumentCategory PurchasingDocumentCategory 1
PurchasingDocumentDeletionCode PurchasingDocumentDeletionCode 1
PurchasingDocumentOrigin PurchasingDocumentOrigin 1
PurchasingDocumentStatus PurchasingDocumentStatus 1
PurchasingDocumentType PurchasingDocumentType 1
PurchasingGroup PurchasingGroup 4
PurchasingOrganization PurchasingOrganization 3
ReleaseIsNotCompleted ReleaseIsNotCompleted 2
ServicePerformer ServicePerformer 1
Supplier Supplier 4
SupplierCountry SupplierCountry 1
WBSDescription WBSDescription 1
WBSElement WBSElement 1
WBSElementInternalID WBSElementInternalID 1
YearQuarter YearQuarter 1

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 PURCHASEORDER (
    ACCOUNTASSIGNMENTNUMBER,
    PURCHASEORDER,
    PURCHASEORDERITEM,
    PURCHASINGDOCUMENT,
    ACCOUNTINGDOCUMENT,
    CALENDARMONTH,
    CALENDARQUARTER,
    CALENDARWEEK,
    CALENDARYEAR,
    COMPANYCODE,
    COSTCENTER,
    DOCUMENTDATE,
    INSPECTIONLOTCREATEDON,
    ISENDOFPURPOSEBLOCKED,
    MATERIAL,
    MATERIALGROUP,
    PLANT,
    PROCSTAT,
    PRODUCTTYPE,
    PURCHASEORDERDATE,
    PURCHASEORDERTYPE,
    PURCHASINGCOMPLETENESSSTATUS,
    PURCHASINGDOCUMENTCATEGORY,
    PURCHASINGDOCUMENTDELETIONCODE,
    PURCHASINGDOCUMENTORIGIN,
    PURCHASINGDOCUMENTSTATUS,
    PURCHASINGDOCUMENTTYPE,
    PURCHASINGGROUP,
    PURCHASINGORGANIZATION,
    RELEASEISNOTCOMPLETED,
    SERVICEPERFORMER,
    SUPPLIER,
    SUPPLIERCOUNTRY,
    WBSDESCRIPTION,
    WBSELEMENT,
    WBSELEMENTINTERNALID,
    YEARQUARTER,
    PRIMARY KEY (ACCOUNTASSIGNMENTNUMBER, PURCHASEORDER, PURCHASEORDERITEM, PURCHASINGDOCUMENT)
);

Learn More