_PURORD

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

Fields (39)

KeyField CDS FieldsUsed in Views
AccrObjectLastChangeDateTime AccrObjectLastChangeDateTime 1
AccrSubobjHdrEndOfLifeDate AccrSubobjHdrEndOfLifeDate 1
AccrSubobjHdrStartOfLifeDate AccrSubobjHdrStartOfLifeDate 1
CompanyCode CompanyCode 1
CompanyCodeCurrency CompanyCodeCurrency 1
CostCenter CostCenter 3
CreatedByUser CreatedByUser 1
CreationDate CreationDate 1
GLAccount GLAccount 1
GoodsRecipientName GoodsRecipientName 1
InternalOrder InternalOrder 3
Material Material 1
MaterialGroup MaterialGroup 1
ProductType ProductType 3
ProfitCenter ProfitCenter 2
PurchaseOrderDate PurchaseOrderDate 1
PurchaseOrderItemCurrency PurchaseOrderItemCurrency 1
PurchaseOrderQuantityUnit PurchaseOrderQuantityUnit 1
PurchasingDocument PurchasingDocument 2
PurchasingDocumentItemText PurchasingDocumentItemText 1
PurchasingGroup PurchasingGroup 1
PurchasingOrganization PurchasingOrganization 1
SalesOrder SalesOrder 4
SalesOrderItem SalesOrderItem 2
ServicePerformer ServicePerformer 1
StandardPurchaseOrderQuantity StandardPurchaseOrderQuantity 1
Supplier Supplier 4
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 (
    ACCROBJECTLASTCHANGEDATETIME,
    ACCRSUBOBJHDRENDOFLIFEDATE,
    ACCRSUBOBJHDRSTARTOFLIFEDATE,
    COMPANYCODE,
    COMPANYCODECURRENCY,
    COSTCENTER,
    CREATEDBYUSER,
    CREATIONDATE,
    GLACCOUNT,
    GOODSRECIPIENTNAME,
    INTERNALORDER,
    MATERIAL,
    MATERIALGROUP,
    PRODUCTTYPE,
    PROFITCENTER,
    PURCHASEORDERDATE,
    PURCHASEORDERITEMCURRENCY,
    PURCHASEORDERQUANTITYUNIT,
    PURCHASINGDOCUMENT,
    PURCHASINGDOCUMENTITEMTEXT,
    PURCHASINGGROUP,
    PURCHASINGORGANIZATION,
    SALESORDER,
    SALESORDERITEM,
    SERVICEPERFORMER,
    STANDARDPURCHASEORDERQUANTITY,
    SUPPLIER,
    TOTALACCRAMOUNTINFREEDFNDCRCY1,
    TOTALACCRAMOUNTINFREEDFNDCRCY2,
    TOTALACCRAMOUNTINFREEDFNDCRCY3,
    TOTALACCRAMOUNTINFREEDFNDCRCY4,
    TOTALACCRAMOUNTINFREEDFNDCRCY5,
    TOTALACCRAMOUNTINFREEDFNDCRCY6,
    TOTALACCRAMOUNTINFREEDFNDCRCY7,
    TOTALACCRAMOUNTINFREEDFNDCRCY8,
    TOTALACCRAMOUNTINTRANSCRCY,
    TRANSACTIONCURRENCY,
    UNITOFMEASURE,
    UNLOADINGWAREHOUSESTAGINGAREA
);