PURCHASEORDER

45 Fields

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

Fields (45)

KeyField CDS FieldsUsed in Views
KEY PurchaseOrder PurchaseOrder 5
KEY PurchaseOrderItem PurchaseOrderItem 1
KEY PurchasingDocument PurchaseOrder 1
AccountingDocument AccountingDocument 1
BaseUnit BaseUnit 1
CompanyCode CompanyCode 6
ControllingObjectDescription ControllingObjectDescription 1
DocumentCurrency DocumentCurrency 1
DocumentDate DocumentDate 2
InspectionLotCreatedOn InspectionLotCreatedOn 1
IsCompletelyDelivered IsCompletelyDelivered 1
IsEndOfPurposeBlocked IsEndOfPurposeBlocked 1
MasterProject MasterProject 1
MasterProjectName MasterProjectName 1
Material Material 1
NetAmount NetAmount 1
NetPriceAmount NetPriceAmount 1
NetPriceQuantity NetPriceQuantity 1
NetworkActivity NetworkActivity 1
NetworkActivityDescription NetworkActivityDescription 1
NetworkActivityInternalID NetworkActivityInternalID 1
OrderPriceUnit OrderPriceUnit 1
OrderQuantity TotalQuantity 1
Plant Plant 1
procstat PurchasingProcessingStatus 1
ProjectNetwork ProjectNetwork 1
ProjectNetworkDescription ProjectNetworkDescription 1
ProjectNetworkInternalID ProjectNetworkInternalID 1
PurchaseOrderItemText MaterialName,PurchaseOrderItemText 1
PurchaseOrderType PurchaseOrderType 1
PurchaseRequisition PurchaseRequisition 1
PurchaseRequisitionItem PurchaseRequisitionItem 1
PurchasingCompletenessStatus PurchasingCompletenessStatus 2
PurchasingDocumentCategory PurchasingDocumentCategory 1
PurchasingDocumentDeletionCode PurchasingDocumentDeletionCode 2
PurchasingDocumentOrigin PurchasingDocumentOrigin 1
PurchasingDocumentType PurchasingDocumentType 1
PurchasingGroup PurchasingGroup 3
PurchasingOrganization PurchasingOrganization 2
ReleaseIsNotCompleted ReleaseIsNotCompleted 2
ServicePerformer ServicePerformer 1
Supplier Supplier 3
WBSDescription WBSDescription 1
WBSElement WBSElement 1
WBSElementInternalID WBSElementInternalID 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 (
    PURCHASEORDER,
    PURCHASEORDERITEM,
    PURCHASINGDOCUMENT,
    ACCOUNTINGDOCUMENT,
    BASEUNIT,
    COMPANYCODE,
    CONTROLLINGOBJECTDESCRIPTION,
    DOCUMENTCURRENCY,
    DOCUMENTDATE,
    INSPECTIONLOTCREATEDON,
    ISCOMPLETELYDELIVERED,
    ISENDOFPURPOSEBLOCKED,
    MASTERPROJECT,
    MASTERPROJECTNAME,
    MATERIAL,
    NETAMOUNT,
    NETPRICEAMOUNT,
    NETPRICEQUANTITY,
    NETWORKACTIVITY,
    NETWORKACTIVITYDESCRIPTION,
    NETWORKACTIVITYINTERNALID,
    ORDERPRICEUNIT,
    ORDERQUANTITY,
    PLANT,
    PROCSTAT,
    PROJECTNETWORK,
    PROJECTNETWORKDESCRIPTION,
    PROJECTNETWORKINTERNALID,
    PURCHASEORDERITEMTEXT,
    PURCHASEORDERTYPE,
    PURCHASEREQUISITION,
    PURCHASEREQUISITIONITEM,
    PURCHASINGCOMPLETENESSSTATUS,
    PURCHASINGDOCUMENTCATEGORY,
    PURCHASINGDOCUMENTDELETIONCODE,
    PURCHASINGDOCUMENTORIGIN,
    PURCHASINGDOCUMENTTYPE,
    PURCHASINGGROUP,
    PURCHASINGORGANIZATION,
    RELEASEISNOTCOMPLETED,
    SERVICEPERFORMER,
    SUPPLIER,
    WBSDESCRIPTION,
    WBSELEMENT,
    WBSELEMENTINTERNALID,
    PRIMARY KEY (PURCHASEORDER, PURCHASEORDERITEM, PURCHASINGDOCUMENT)
);

Learn More