PURCHASEORDERITEM

73 Fields

PURCHASEORDERITEM is an SAP database table in S/4HANA. It contains 73 fields.

Fields (73)

KeyField CDS FieldsUsed in Views
KEY CalendarMonth CalendarMonth 1
KEY CalendarQuarter CalendarQuarter 1
KEY CalendarWeek CalendarWeek 1
KEY CalendarYear CalendarYear 1
KEY CompanyCode CompanyCode 10
KEY ebeln PurchasingDocument 1
KEY ebelp PurchasingDocumentItem 1
KEY ExtSourceSystem ExtSourceSystem 2
KEY PurchaseOrder PurchaseOrder 10
KEY PurchaseOrderItem PurchaseOrderItem 11
KEY PurchasingDocumentCategory PurchasingDocumentCategory 1
KEY PurchasingDocumentStatus PurchasingDocumentStatus 1
KEY PurchasingGroup PurchasingGroup,PurchasingGroupName 9
KEY PurchasingOrganization PurchasingOrganization,PurchasingOrganizationName 9
KEY Supplier Supplier,SupplierName 10
_Plant _Plant 2
_PurchaseRequisition _PurchaseRequisition 1
_PurchaseRequisitionItem _PurchaseRequisitionItem 1
_PurchasingGroup _PurchasingGroup 1
_PurchasingOrganization _PurchasingOrganization 1
_Supplier _Supplier 1
AccountAssignmentCategory AccountAssignmentCategory 4
CompanyCodeName CompanyCodeName 1
CreatedByUser CreatedByUser 3
DeliveryStatus DeliveryStatus,PurOrdItmNextDelivStatus 2
DeliveryStatusDescription DeliveryStatusDescription 2
DocumentCurrency DocumentCurrency 4
GoodsReceiptQty GoodsReceiptQty 1
IsCompletelyDelivered IsCompletelyDelivered 1
IsReturnsItem IsReturnsItem 2
Material Material,Product 11
MaterialGroup MaterialGroup,ProductGroup 10
MaterialGroupName MaterialGroupName 1
MaterialName MaterialName 2
MaxContractAmount MaxContractAmount 2
MultipleAcctAssgmtDistribution MultipleAcctAssgmtDistribution 4
NetPriceQuantity NetPriceQuantity 2
OrderPriceUnit OrderPriceUnit 1
OrderQuantity OrderQuantity 1
Plant Plant,PlantName 13
PlantName PlantName 2
ProductCollection ProductCollection 1
ProductSeason ProductSeason 1
ProductSeasonYear ProductSeasonYear 1
ProductTheme ProductTheme 1
ProductType ProductType 5
PurchaseContract PurchaseContract 4
PurchaseContractItem PurchaseContractItem 4
PurchaseOrderCategory PurchaseOrderCategory 3
PurchaseOrderDate PurchaseOrderDate 8
PurchaseOrderItemCategory PurchaseOrderItemCategory 4
PurchaseOrderItemText PurchaseOrderItemText 1
PurchaseOrderOutputStatusName PurchasingDocumentStatusName 2
PurchaseOrderQuantityUnit PurchaseOrderQuantityUnit 8
PurchaseOrderStatus PurchaseOrderItemStatus 2
PurchaseOrderType PurchaseOrderType 2
PurchaseRequisition PurchaseRequisition 5
PurchaseRequisitionItem PurchaseRequisitionItem 5
PurchasingCategory PurchasingCategory 1
PurchasingDocument PurchasingDocument 1
PurchasingDocumentItem PurchasingDocumentItem 1
PurchasingGroupName PurchasingGroupName 1
PurchasingOrganizationName PurchasingOrganizationName 1
PurgCatName PurgCatName 1
PurgDocHdrCompanyCode PurgDocHdrCompanyCode 1
ReceivingCompanyCode ReceivingCompanyCode 1
ScheduleLineOpenQty ScheduleLineOpenQty 1
ServicePerformer ServicePerformer 6
StillToInvoiceValue StillToInvoiceValue 1
StockSegment StockSegment 1
StorageLocation StorageLocation 2
StorageLocationName StorageLocationName 1
SupplierName SupplierName 2

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 PURCHASEORDERITEM (
    CALENDARMONTH,
    CALENDARQUARTER,
    CALENDARWEEK,
    CALENDARYEAR,
    COMPANYCODE,
    EBELN,
    EBELP,
    EXTSOURCESYSTEM,
    PURCHASEORDER,
    PURCHASEORDERITEM,
    PURCHASINGDOCUMENTCATEGORY,
    PURCHASINGDOCUMENTSTATUS,
    PURCHASINGGROUP,
    PURCHASINGORGANIZATION,
    SUPPLIER,
    _PLANT,
    _PURCHASEREQUISITION,
    _PURCHASEREQUISITIONITEM,
    _PURCHASINGGROUP,
    _PURCHASINGORGANIZATION,
    _SUPPLIER,
    ACCOUNTASSIGNMENTCATEGORY,
    COMPANYCODENAME,
    CREATEDBYUSER,
    DELIVERYSTATUS,
    DELIVERYSTATUSDESCRIPTION,
    DOCUMENTCURRENCY,
    GOODSRECEIPTQTY,
    ISCOMPLETELYDELIVERED,
    ISRETURNSITEM,
    MATERIAL,
    MATERIALGROUP,
    MATERIALGROUPNAME,
    MATERIALNAME,
    MAXCONTRACTAMOUNT,
    MULTIPLEACCTASSGMTDISTRIBUTION,
    NETPRICEQUANTITY,
    ORDERPRICEUNIT,
    ORDERQUANTITY,
    PLANT,
    PLANTNAME,
    PRODUCTCOLLECTION,
    PRODUCTSEASON,
    PRODUCTSEASONYEAR,
    PRODUCTTHEME,
    PRODUCTTYPE,
    PURCHASECONTRACT,
    PURCHASECONTRACTITEM,
    PURCHASEORDERCATEGORY,
    PURCHASEORDERDATE,
    PURCHASEORDERITEMCATEGORY,
    PURCHASEORDERITEMTEXT,
    PURCHASEORDEROUTPUTSTATUSNAME,
    PURCHASEORDERQUANTITYUNIT,
    PURCHASEORDERSTATUS,
    PURCHASEORDERTYPE,
    PURCHASEREQUISITION,
    PURCHASEREQUISITIONITEM,
    PURCHASINGCATEGORY,
    PURCHASINGDOCUMENT,
    PURCHASINGDOCUMENTITEM,
    PURCHASINGGROUPNAME,
    PURCHASINGORGANIZATIONNAME,
    PURGCATNAME,
    PURGDOCHDRCOMPANYCODE,
    RECEIVINGCOMPANYCODE,
    SCHEDULELINEOPENQTY,
    SERVICEPERFORMER,
    STILLTOINVOICEVALUE,
    STOCKSEGMENT,
    STORAGELOCATION,
    STORAGELOCATIONNAME,
    SUPPLIERNAME,
    PRIMARY KEY (CALENDARMONTH, CALENDARQUARTER, CALENDARWEEK, CALENDARYEAR, COMPANYCODE, EBELN, EBELP, EXTSOURCESYSTEM, PURCHASEORDER, PURCHASEORDERITEM, PURCHASINGDOCUMENTCATEGORY, PURCHASINGDOCUMENTSTATUS, PURCHASINGGROUP, PURCHASINGORGANIZATION, SUPPLIER)
);

Learn More