_PURORD

_PURORD is an SAP database table in S/4HANA. It contains 52 fields.

Fields (52)

KeyField CDS FieldsUsed in Views
AccountAssignmentNumber zekkn 1
AccrObjectLastChangeDateTime AccrObjectLastChangeDateTime 1
AccrSubobjHdrEndOfLifeDate AccrSubobjHdrEndOfLifeDate 1
AccrSubobjHdrStartOfLifeDate AccrSubobjHdrStartOfLifeDate 1
CompanyCode CompanyCode 1
CompanyCodeCurrency CompanyCodeCurrency 1
ControllingArea kokrs 1
CostCenter CostCenter,kostl 4
CreatedByUser CreatedByUser,ernam 2
CreationDate CreationDate 1
DocumentCurrency waers 1
GLAccount GLAccount,sakto 2
GoodsReceiptIsExpected wepos 1
GoodsReceiptIsNonValuated weunb 1
GoodsRecepientName wempf 1
GoodsRecipientName GoodsRecipientName 1
InternalOrder InternalOrder 3
InvoiceIsExpected repos 1
IsCompletelyDelivered elikz 1
IsFinallyInvoiced erekz 1
Material Material,matnr 2
MaterialGroup MaterialGroup 1
NetAmount netwr 1
ProductType ProductType 3
ProfitCenter prctr,ProfitCenter 3
ProjectNetwork nplnr 1
PurchaseOrderDate PurchaseOrderDate 1
PurchaseOrderItemCurrency PurchaseOrderItemCurrency 1
PurchaseOrderQuantityUnit PurchaseOrderQuantityUnit 1
PurchasingDocument ebeln,PurchasingDocument 3
PurchasingDocumentItem ebelp 1
PurchasingDocumentItemText PurchasingDocumentItemText,txz01 2
PurchasingGroup ekgrp,PurchasingGroup 2
PurchasingOrganization PurchasingOrganization 1
RequisitionerName afnam 1
SalesOrder KDAUF,SalesOrder 5
SalesOrderItem KDPOS,SalesOrderItem 3
ServicePerformer ServicePerformer 1
StandardPurchaseOrderQuantity StandardPurchaseOrderQuantity 1
Supplier lifnr,Supplier 5
TotalAccrAmountInFreeDfndCrcy1 TotalAccrAmountInFreeDfndCrcy1 1
TotalAccrAmountInFreeDfndCrcy2 TotalAccrAmountInFreeDfndCrcy2 1
TotalAccrAmountInFreeDfndCrcy3 TotalAccrAmountInFreeDfndCrcy3 1
TotalAccrAmountInFreeDfndCrcy4 TotalAccrAmountInFreeDfndCrcy4 1
TotalAccrAmountInFreeDfndCrcy5 TotalAccrAmountInFreeDfndCrcy5 1
TotalAccrAmountInFreeDfndCrcy6 TotalAccrAmountInFreeDfndCrcy6 1
TotalAccrAmountInFreeDfndCrcy7 TotalAccrAmountInFreeDfndCrcy7 1
TotalAccrAmountInFreeDfndCrcy8 TotalAccrAmountInFreeDfndCrcy8 1
TotalAccrAmountInTransCrcy TotalAccrAmountInTransCrcy 1
TransactionCurrency TransactionCurrency 1
UnitOfMeasure UnitOfMeasure 1
UnloadingWarehouseStagingArea UnloadingWarehouseStagingArea 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 _PURORD (
    ACCOUNTASSIGNMENTNUMBER,
    ACCROBJECTLASTCHANGEDATETIME,
    ACCRSUBOBJHDRENDOFLIFEDATE,
    ACCRSUBOBJHDRSTARTOFLIFEDATE,
    COMPANYCODE,
    COMPANYCODECURRENCY,
    CONTROLLINGAREA,
    COSTCENTER,
    CREATEDBYUSER,
    CREATIONDATE,
    DOCUMENTCURRENCY,
    GLACCOUNT,
    GOODSRECEIPTISEXPECTED,
    GOODSRECEIPTISNONVALUATED,
    GOODSRECEPIENTNAME,
    GOODSRECIPIENTNAME,
    INTERNALORDER,
    INVOICEISEXPECTED,
    ISCOMPLETELYDELIVERED,
    ISFINALLYINVOICED,
    MATERIAL,
    MATERIALGROUP,
    NETAMOUNT,
    PRODUCTTYPE,
    PROFITCENTER,
    PROJECTNETWORK,
    PURCHASEORDERDATE,
    PURCHASEORDERITEMCURRENCY,
    PURCHASEORDERQUANTITYUNIT,
    PURCHASINGDOCUMENT,
    PURCHASINGDOCUMENTITEM,
    PURCHASINGDOCUMENTITEMTEXT,
    PURCHASINGGROUP,
    PURCHASINGORGANIZATION,
    REQUISITIONERNAME,
    SALESORDER,
    SALESORDERITEM,
    SERVICEPERFORMER,
    STANDARDPURCHASEORDERQUANTITY,
    SUPPLIER,
    TOTALACCRAMOUNTINFREEDFNDCRCY1,
    TOTALACCRAMOUNTINFREEDFNDCRCY2,
    TOTALACCRAMOUNTINFREEDFNDCRCY3,
    TOTALACCRAMOUNTINFREEDFNDCRCY4,
    TOTALACCRAMOUNTINFREEDFNDCRCY5,
    TOTALACCRAMOUNTINFREEDFNDCRCY6,
    TOTALACCRAMOUNTINFREEDFNDCRCY7,
    TOTALACCRAMOUNTINFREEDFNDCRCY8,
    TOTALACCRAMOUNTINTRANSCRCY,
    TRANSACTIONCURRENCY,
    UNITOFMEASURE,
    UNLOADINGWAREHOUSESTAGINGAREA
);