Fields (39)
| Key | Field | CDS Fields | Used 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
);
Learn More
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA