Fields (52)
| Key | Field | CDS Fields | Used 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
);
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