I_PURCHASINGDOCUMENTITEM

CDS View
217 Fields 105 CDS Views

Purchasing Document Item

I_PURCHASINGDOCUMENTITEM is a CDS View in S/4HANA. Purchasing Document Item. It contains 217 fields. 105 CDS views read from this table.

CDS Views using this table (105)

ViewTypeJoinVDMDescription
C_DspDocFlwPurDocItemAttrib view from CONSUMPTION PO Item Attributes for DDF
C_ExchPurContrItemSchedgKPI view from CONSUMPTION Exchange Purchase Contract Item Scheduling for KPI
C_FldLogsProcRcptCstmFldExtn view from CONSUMPTION Consumption For Extensibility
C_GB_StRpAuditMMFileC view_entity inner CONSUMPTION GB HRMC Audit File for MM - Cube
C_GRIRPurchasingDocItem view from CONSUMPTION GR/IR Purchasing Document Item
C_InvcExcdGRPurgDocItm view from CONSUMPTION Overpaid GR in Purchasing Document Item
C_POItemQtyAndValueDCCalc view from CONSUMPTION PO Item Qty and Value in DC Calc Fields
C_ProcurementSmartFilter view inner CONSUMPTION Global Filter for Procurement Overview Page
C_PurContrSourceNomination view from CONSUMPTION Purchase Contract Header View
C_PurgDocFldValChg view inner CONSUMPTION Change Information Purchasing Document
C_PurgDocItemPurgIssue view from CONSUMPTION Purg Doc Item Purchasing Issue
C_PurgDocSuplrConfObj view inner CONSUMPTION Supplier Confirmations Object Page
C_PurOrdMaintainOutlAIValHelp view from CONSUMPTION PO Maintenance: Value Help for Outline Agreement Items
C_PurReqnSchedAgrmtVH view from CONSUMPTION Sched Agreement val help for Prof PR
C_RelPurOrdStkTranspOrdDlvr view from CONSUMPTION Reltd Purchase Order/Stk Transport Order
C_RequirementTrackingPurRFQ view from CONSUMPTION RFQ by Requirement Tracking
C_SlsDocFlfmtPurgDocItem view from CONSUMPTION Sales Doc Fulfillment: Purg Doc Item
C_SuplrEvalChangedScores view inner CONSUMPTION Supplier Evaluation Changed Scores
C_UnlmtdOvrdelivPurOrder view from CONSUMPTION Unlimited Over Delivery Purchase Order
I_AlignPOSchedLineQtyInBsUoM view from BASIC Qty in Base unit of measure
I_AlignPurOrdHdrItmSched view from COMPOSITE PO Header, Item and Schedule Line Data
I_CFinPurchasingDocHistory view inner COMPOSITE CFin Purchasing Document: History
I_CFinPurchasingDocumentItem view union_all COMPOSITE CFin Purchasing Document: Item
I_CFinPurgDocAccountAssignment view inner COMPOSITE CFin Purchasing Doc: Account Assignment
I_CFinPurgDocScheduleLine view inner COMPOSITE CFin Purchasing Document: Schedule Line
I_DigitalVehiclePurOrderItem view_entity inner COMPOSITE Vehicle Purchase Order
I_FieldLogisticsPurchaseOrder view_entity from COMPOSITE Field Logistics Purchase Order
I_FldLogsDocFlwInbDeliv view from COMPOSITE Field Logistics : Inbound Delivery
I_FldLogsKitOutbDelivIndrctRef view_entity from COMPOSITE Kit Outbound Delivery with Indirect PO Ref
I_FldLogsKitOutbDelivIndrctRef view_entity inner COMPOSITE Kit Outbound Delivery with Indirect PO Ref
I_FldLogsKitOutbDelivItmRef view_entity inner COMPOSITE Kit Outbound Delivery Item Reference Document
I_FldLogsOutbDelivAtRmteInfo view_entity from COMPOSITE Outbound Delivery Info At Remote
I_FldLogsPrdcssrDocRemote view from COMPOSITE Field Logistics Predecessor documents
I_FldLogsProcessReceiptsTP view inner TRANSACTIONAL Field Logistics : Process Receipts
I_FldLogsProcRcptFollowOnDocs view from COMPOSITE Field Logistics Follow on Documents
I_FldLogsProcRcptOutpReq view_entity from COMPOSITE FL Process Receipts Output Request
I_FldLogsPurchaseOrderVH view inner COMPOSITE Field Logistics : Process Receipts PO Value Help
I_FldLogsPurchasingItem view_entity from COMPOSITE Field Logistics Purchasing Items
I_FldLogsRcptHndlgUnitOutpReq view_entity from COMPOSITE FL Process Receipts Output Request
I_FldLogsRetServicePurOrdVH view from COMPOSITE Service PO F4 Help for FL Returns
I_FldLogsSTOFrmPurOrd view_entity from COMPOSITE STO Details by Purchase Order
I_MRPPurchaseOrder view inner COMPOSITE MRP Purchase Order
I_MRPTransferDemand view_entity inner COMPOSITE Transfer Demand
I_PPS_PurchaseOrderItemTaxCode view_entity from BASIC Purchase order item tax
I_PPS_PurchasingDocumentItem view_entity from BASIC Purchasing Document
I_PPS_PurContrItemCount view_entity from COMPOSITE Count number of Items
I_PPS_PurOrdDocumentTotalC_2 view_entity from COMPOSITE Purchase Order Document Total - Cube
I_PPS_PurOrdDocumentTotalC_2 view_entity union_all COMPOSITE Purchase Order Document Total - Cube
I_PrepaymentRefDocTotalAmtPO view_entity inner COMPOSITE Prepayment Document Total Amount
I_ProdCmplncLicRlvtPurgDocs view from COMPOSITE License Relevant Purchase Order Items
I_PurchaseOrderItemPurgIssue view inner COMPOSITE SOFM Purchase Order Item Purchasing Issue
I_PurchaseOrderOfSIT view from TRANSACTIONAL Value Help for Purchase Order
I_PurchasingDocumentItemStdVH view from COMPOSITE Purchasing Document Item
I_PurOrdAccrsCFinPurgDocAssgmt view inner COMPOSITE PurOrdAccrs: CFin PO Item Assgmt
I_PurOrdAccrsCFinPurgDocItem view union_all COMPOSITE PurOrdAccrs: Purchasing Document Item
I_RFM_PurContrItmCnsmpnOth view from COMPOSITE Pur Contr Itm Cnsmpn Oth
I_RfqItem_Api01 view from BASIC Item in Request for Quotation
I_SchedAgrmtReleaseListItem view from COMPOSITE Schedule Agreement Release List Item
I_SourcesOfSupply view from COMPOSITE Sources of Supply
I_SupAssgmtSitnOrdItemDet view union_all COMPOSITE View at Order item details for situation
OIJ09_SourceNominationSchedule view inner Source Schedule
P_AnaEketSdmMiration view inner COMPOSITE Pur Docs not migrated to MMPUR_ANA_EKET
P_AnaEketSdmMiration1 view inner COMPOSITE Pur Docs not migrated to MMPUR_ANA_EKET
P_ARUNDMNDITEM view union COMPOSITE
P_DDMaterialSOS view inner CONSUMPTION
P_DDOrderDetails view union_all CONSUMPTION
P_DDPurchaseOrder view inner COMPOSITE
P_FilteredSourceOfSupply view inner CONSUMPTION Filtered Source of Supply
P_GetLastPostingDate view from COMPOSITE
P_GRIR_USER view from CONSUMPTION
P_JITMatlRcpntDocuments view from COMPOSITE
P_JP_IRPurchaseDocumentHeader view inner COMPOSITE
P_MY_SupplierInvoiceItem view inner COMPOSITE
P_POItemCastedAmounts view from CONSUMPTION PO Item Casted Amounts
P_PrepaymentRefDocTotalAmount view inner COMPOSITE Prepayment Document Total Amount
P_PrepaymentRefDocTotalAmtPO view_entity inner COMPOSITE
P_PurchaseOrderItemForCIC view_entity from BASIC
P_Purchaseorders_Fs view left_outer BASIC
P_PurchasingGroupAnalysis1 view from CONSUMPTION Purchasing Group Analysis 1
P_PurchDocAmntInDocCurr view from COMPOSITE Purch Document Amnt In Document Currency
P_PurchDocWthGRIRFlagNotSet view inner CONSUMPTION Purchasing Document filtered by date
P_PurDocItemCurConv view from CONSUMPTION Purchase Document with Currency Conversion for dates
P_PurDocItmforReturnDel view from CONSUMPTION Purchasing Document Item for Return Del
P_PurgDocMissingSuplrConf view from CONSUMPTION P view for missing confirmations
P_Purgdocscheduleline view inner CONSUMPTION Purchasing Document Schedule Lines
P_PurgDocSuplrConf view inner CONSUMPTION
P_PurgOrdSchKeyDate view inner CONSUMPTION View for Delivery Date and Quantity
P_PurOrdItemTimeVar view inner CONSUMPTION Purchase Order Item for Time Variance
P_PurOrdMaintainPDocWAccAsLine view from CONSUMPTION
P_PurReqnSuccssrDocs view from COMPOSITE
P_RFQSuccssrDocs view from COMPOSITE
P_RFQSuccssrDocs view union_all COMPOSITE
P_RU_MaterialRcptDateMM3 view inner CONSUMPTION
P_RU_PurchaseOrderHistoryGRIR view from CONSUMPTION
P_RU_SuplrInvcAcctgItem view inner CONSUMPTION
P_RU_SuplrInvcLogsItem view inner CONSUMPTION
P_SalesOrderInSupplyPurgIssue1 view from COMPOSITE
P_SalesOrderInSupplyPurgIssue4 view from COMPOSITE
P_SCHDLNMIGRATION view inner CONSUMPTION Schedule Line Migration
P_SLLMINMAXRELEVANTPOITEMS view inner COMPOSITE
P_SlsOrderInSupplyPurgIssue3 view from COMPOSITE
P_SlsOrderInSupplyPurgIssue3 view union_all COMPOSITE
P_SourcesOfSupply view inner COMPOSITE
P_TotalGrInvQty view from CONSUMPTION
shsm_ekpo_ekko view from Value Help for Purchasing Document

Fields (217)

KeyField CDS FieldsUsed in Views
KEY Material Material,matnr,Product 29
KEY MaterialGroup MaterialGroup,matkl,ProductGroup 18
KEY Plant Plant,storage_plant,werks 33
KEY PurchasingDocument OrderID,PurchaseOrder,PurchasingDocument,PurchasingDocumentNumber,RequestForQuotation,SchedulingAgreement,SourceDocument,StockTransportOrder,SubsequentDocument 49
KEY PurchasingDocumentItem PurchaseOrderItem,PurchasingDocumentItem,PurchasingDocumentItemNumber,SchedulingAgreementItem,SourceDocumentItem,SubsequentDocumentItem 57
KEY PurchasingDocumentItemUniqueID MaintOrdProcurementDocument,PurchasingDocumentItemUniqueID 4
KEY RequestForQuotationItem PrecedingDocumentItem,RequestForQuotationItem 2
KEY SupplierQuotation PrecedingDocument,SupplierQuotation 2
KEY SupplierQuotationItem PrecedingDocumentItem 1
_AccountAssignmentCategory _AccountAssignmentCategory 1
_AllocationTable _AllocationTable 1
_AllocationTableItem _AllocationTableItem 1
_BaseUnit _BaseUnit 1
_BR_CFOPCategory _BR_CFOPCategory 1
_BR_MaterialOrigin _BR_MaterialOrigin 1
_BR_MaterialUsage _BR_MaterialUsage 1
_BR_NCM _BR_NCM 1
_CompanyCode _CompanyCode 5
_ConfigurableProduct _ConfigurableProduct 1
_ConsumptionPosting _ConsumptionPosting 3
_Customer _Customer 1
_DocumentCurrency _DocumentCurrency 6
_IncotermsClassification _IncotermsClassification 1
_ManualDeliveryAddress _ManualDeliveryAddress 1
_Manufacturer _Manufacturer 1
_ManufacturerMaterial _ManufacturerMaterial 2
_Material _Material 3
_MaterialGroup _MaterialGroup 4
_OrderPriceUnit _OrderPriceUnit 1
_OrderQuantityUnit _OrderQuantityUnit 3
_Plant _Plant 7
_PriorSupplier _PriorSupplier 1
_ProductCategory _ProductCategory 1
_ProductType _ProductType 1
_PurchaseContract _PurchaseContract 2
_PurchaseContractItem _PurchaseContractItem 2
_PurchaseRequisition _PurchaseRequisition 1
_PurchaseRequisitionItem _PurchaseRequisitionItem 1
_PurchasingDocument _PurchasingDocument,_Schedgagrmthdr 10
_PurchasingInfoRecord _PurchasingInfoRecord 2
_PurgDocumentCategory _PurgDocumentCategory 4
_PurgDocumentItemCategory _PurgDocumentItemCategory 3
_ReferenceDeliveryAddress _ReferenceDeliveryAddress 1
_RetailPromotion _RetailPromotion 1
_ScheduleLine _ScheduleLine 1
_ServicePerformer _ServicePerformer 1
_StorageLocation _StorageLocation 1
_Subcontractor _Subcontractor 1
_VolumeUnit _VolumeUnit 1
_WeightUnit _WeightUnit 1
AccountAssignmentCategory AccountAssignmentCategory,knttp 7
AllocationTable AllocationTable 1
AllocationTableItem AllocationTableItem 1
ArticleCategory ArticleCategory 1
BaseUnit BaseUnit,lmein 9
BR_CFOPCategory BR_CFOPCategory 1
BR_IsProducedInHouse BR_IsProducedInHouse 1
BR_MaterialOrigin BR_MaterialOrigin 1
BR_MaterialUsage BR_MaterialUsage 1
BR_NCM BR_NCM 1
BudgetPeriod BudgetPeriod 3
CommitmentItem CommitmentItemShortID 2
CommodityCode CommodityCode 1
CompanyCode bukrs,CompanyCode 9
ConsumptionPosting ConsumptionPosting 3
CostCenter CostCenter 1
CreationDate CreationDate 1
CreationTime CreationTime 1
CrossPlantConfigurableProduct CrossPlantConfigurableProduct 1
CumulativeQuantityIsNotSent CumulativeQuantityIsNotSent 1
Customer Customer 1
DeliveryDocumentType DeliveryDocumentType 1
DiscountInKindEligibility DiscountInKindEligibility 1
DocumentCurrency Currency,DocumentCurrency,MaintOrdOpComponentCurrency 17
DownPaymentAmount DownPaymentAmount 1
DownPaymentDueDate DownPaymentDueDate 1
DownPaymentPercentageOfTotAmt DownPaymentPercentageOfTotAmt 1
DownPaymentType DownPaymentType 1
EarmarkedFundsDocument EarmarkedFundsDocument 1
EffectiveAmount EffectiveAmount 1
EvaldRcptSettlmtIsAllowed EvaldRcptSettlmtIsAllowed 3
ExpectedOverallLimitAmount ExpectedOverallLimitAmount 3
FirmTradeOffZoneBindMRP FirmTradeOffZoneBindMRP 1
FunctionalArea FunctionalArea 3
Fund Fund 3
FundsCenter FundsCenter 3
GLAccount GLAccount 1
GoodsReceiptDurationInDays GoodsReceiptDurationInDays,MaterialGoodsReceiptDuration 3
GoodsReceiptIsExpected GoodsReceiptIsExpected,wepos 12
GoodsReceiptIsNonValuated GoodsReceiptIsNonValuated 4
GoodsReceiptLatestCreationDate GoodsReceiptLatestCreationDate 1
GrantID GrantID 3
GrossAmount GrossAmount 3
IncotermsClassification IncotermsClassification 2
IncotermsLocation1 IncotermsLocation1 2
IncotermsLocation2 IncotermsLocation2 2
IncotermsTransferLocation IncotermsTransferLocation 2
InternationalArticleNumber InternationalArticleNumber 1
IntrastatServiceCode IntrastatServiceCode 1
InventorySpecialStockType InventorySpecialStockType 5
InvoiceIsExpected InvoiceIsExpected 4
InvoiceIsGoodsReceiptBased InvoiceIsGoodsReceiptBased,webre 9
IsCompletelyDelivered complete_indicator,elikz,IsCompletelyDelivered 15
IsEndOfPurposeBlocked IsEndOfPurposeBlocked 8
IsFinallyInvoiced IsFinallyInvoiced 10
IsInfoAtRegistration IsInfoAtRegistration 1
IsOrderAcknRqd IsOrderAcknRqd 2
IsRelevantForJITDelivSchedule IsRelevantForJITDelivSchedule 1
IsReturnsItem IsReturnsItem,retpo,return_indicator 8
IsStatisticalItem IsStatisticalItem 3
IssuingStorageLocation IssuingStorageLocation,SupplyingStorageLocation 2
ItemGrossWeight ItemGrossWeight 1
ItemIsRejectedBySupplier ItemIsRejectedBySupplier 1
ItemLastTransmissionDate ItemLastTransmissionDate 1
ItemNetWeight ItemNetWeight 1
ItemVolume ItemVolume 1
ManualDeliveryAddressID ManualDeliveryAddressID 2
Manufacturer Manufacturer 2
ManufacturerMaterial ManufacturerMaterial,MaterialNumber 5
ManufacturerPartNmbr ManufacturerPartNmbr 2
MaterialFreightGroup MaterialFreightGroup 1
MaterialType MaterialType 3
MinRemainingShelfLife MinRemainingShelfLife 1
MRPArea MRPArea 1
MultipleAcctAssgmtDistribution MultipleAcctAssgmtDistribution,vrtkz 6
NetAmount NetAmount,NetValueInDocCurrency,netwr 11
NetPriceAmount netpr,NetPriceAmount 13
NetPriceQuantity NetPriceQuantity,peinh 8
NextFcstDelivSchedSendingDate NextFcstDelivSchedSendingDate 1
NextJITDelivSchedSendingDate NextJITDelivSchedSendingDate 1
NoDaysReminder1 NoDaysReminder1 1
NoDaysReminder2 NoDaysReminder2 1
NoDaysReminder3 NoDaysReminder3 1
NonDeductibleInputTaxAmount NonDeductibleInputTaxAmount 3
OrderItemQtyToBaseQtyDnmntr ConvDenominatorToBaseUnit,OrderItemQtyToBaseQtyDnmntr,quantity_denominator,umren 8
OrderItemQtyToBaseQtyNmrtr ConvNumeratorToBaseUnit,OrderItemQtyToBaseQtyNmrtr,quantity_numerator,umrez 8
OrderPriceUnit bprme,OrderPriceUnit 6
OrderPriceUnitToOrderUnitNmrtr BPUMZ,OrderPriceUnitToOrderUnitNmrtr 5
OrderQuantity FldLogsPOTotalQty,MENGE_EKPO,OrderQuantity,PurchaseOrderItemQuantity,PurchasingDocumentOrderQty,quantity,RequirementQuantityInBaseUnit 18
OrderQuantityUnit BaseUnit,meins,MEINS_EKPO,OrderQuantityUnit,OrderUnit,OrderUnitOfMeassure,PurchaseOrderItemQuantityUnit,PurchaseOrderQuantityUnit,PurgDocOrderQuantityUnit,quantity_unit 35
OrdPriceUnitToOrderUnitDnmntr bpumn,OrdPriceUnitToOrderUnitDnmntr 4
OutwardDeliveryIsComplete OutwardDeliveryIsComplete 1
OverallLimitAmount OverallLimitAmount 3
OverdelivTolrtdLmtRatioInPct OverdelivTolrtdLmtRatioInPct 1
PartialDeliveryIsAllowed PartialDeliveryIsAllowed 4
PartialInvoiceDistribution PartialInvoiceDistribution 4
PlannedDeliveryDurationInDays MaterialPlannedDeliveryDurn,PlannedDeliveryDurationInDays 3
PlndOrderReplnmtElmntType PlndOrderReplnmtElmntType 2
PriceIsToBePrinted PriceIsToBePrinted 1
PricingDateControl PricingDateControl 1
PriorSupplier PriorSupplier 1
ProductPurchasePointsQty ProductPurchasePointsQty 1
ProductPurchasePointsQtyUnit ProductPurchasePointsQtyUnit 1
ProductType ProductType,ProductTypeCode,PurgDocProductType 5
ProfitCenter ProfitCenter 4
PurchaseContract konnr,PurchaseContract,PurchaseOutlineAgreement 5
PurchaseContractItem KTPNR,PurchaseContractItem,PurchaseOutlineAgreementItem 4
PurchaseRequisition PurchaseRequisition 8
PurchaseRequisitionItem PurchaseRequisitionItem 7
PurchasingDocumentCategory PurchasingDocumentCategory,SourceDocumentType,SubsequentDocumentCategory 18
PurchasingDocumentDeletionCode deletion_indicator,loekz,PurchasingDocItemDeletionCode,PurchasingDocumentDeletionCode 11
PurchasingDocumentItemCategory aspect_type,ItemCategory,MaterialProcurementCategory,pstyp,PurchasingDocumentItemCategory 15
PurchasingDocumentItemText ComponentDescription,PurchasingDocumentItemText,PurchasingText,ShortText,text 18
PurchasingInfoRecord PurchasingInfoRecord 4
PurchasingOrderReason PurchasingOrderReason 1
PurchasingParentItem PurchasingParentItem 1
PurContractForOverallLimit PurContractForOverallLimit 1
PurgDocItmBlkRsnCode PurgDocItmBlkRsnCode 1
PurgDocItmTargetAmount PurgDocItmTargetAmount 1
PurgDocOrderAcknNumber PurgDocOrderAcknNumber 1
PurgDocPriceDate PurgDocPriceDate 1
PurgDocReleaseOrderQuantity PurgDocReleaseOrderQuantity 1
PurgItemIsBlockedForDelivery PurgItemIsBlockedForDelivery 1
QualityCertificateType QualityCertificateType 1
QualityMgmtCtrlKey QualityMgmtCtrlKey 1
ReferenceDeliveryAddressID ReferenceDeliveryAddressID 1
RequestForQuotation RequestForQuotation 1
RequirementSegment RequirementSegment 1
RequirementTracking RequirementTracking 3
RequisitionerName RequisitionerName 4
RetailPromotion RetailPromotion 1
SchedAgrmtAgreedCumQty SchedAgrmtAgreedCumQty 1
SchedAgrmtCumQtyReconcileDate SchedAgrmtCumQtyReconcileDate 1
SchedAgrmtCumulativeQtyControl SchedAgrmtCumulativeQtyControl 1
SchedgAgrmtRelCreationProfile SchedgAgrmtRelCreationProfile 1
SchedLineSemiFirmOrderInDays SchedLineSemiFirmOrderInDays 1
ScheduleLineFirmOrderInDays ScheduleLineFirmOrderInDays 1
ServicePackage ServicePackage 3
ServicePerformer ServicePerformer 2
ShelfLifeExpirationDatePeriod ShelfLifeExpirationDatePeriod 1
ShippingInstruction ShippingInstruction 1
StockSegment StockSegment 1
StockType TargetStockType 1
StorageLocation lgort,ReceivingStorageLocation,StorageLocation 8
Subcontractor Subcontractor 2
Subtotal1Amount Subtotal1Amount 1
Subtotal2Amount Subtotal2Amount 1
Subtotal3Amount Subtotal3Amount 1
Subtotal4Amount Subtotal4Amount 1
Subtotal5Amount Subtotal5Amount 1
Subtotal6Amount Subtotal6Amount 1
SupplierConfirmationControlKey bstae,ConfirmationControl,SupplierConfirmationControlKey 4
SupplierIsSubcontractor SupplierIsSubcontractor 1
SupplierMaterialNumber SupplierMaterialNumber 3
SupplierSubrange SupplierSubrange 1
TargetAmount TargetAmount 1
TargetQuantity TargetQuantity 6
TaxCode TaxCode 4
TaxJurisdiction TaxJurisdiction 3
ThirdPtyOrdProcgExtReference ThirdPtyOrdProcgExtReference 1
ThirdPtyOrdProcgExtRefItem ThirdPtyOrdProcgExtRefItem 1
UnderdelivTolrtdLmtRatioInPct UnderdelivTolrtdLmtRatioInPct 2
UnlimitedOverdeliveryIsAllowed UnlimitedOverdeliveryIsAllowed 1
ValuationCategory ValuationCategory 1
ValuationType ValuationType 3
VolumeUnit VolumeUnit 1
WeightUnit WeightUnit 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.

-- Purchasing Document Item
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_PURCHASINGDOCUMENTITEM (
    MATERIAL,
    MATERIALGROUP,
    PLANT,
    PURCHASINGDOCUMENT,
    PURCHASINGDOCUMENTITEM,
    PURCHASINGDOCUMENTITEMUNIQUEID,
    REQUESTFORQUOTATIONITEM,
    SUPPLIERQUOTATION,
    SUPPLIERQUOTATIONITEM,
    _ACCOUNTASSIGNMENTCATEGORY,
    _ALLOCATIONTABLE,
    _ALLOCATIONTABLEITEM,
    _BASEUNIT,
    _BR_CFOPCATEGORY,
    _BR_MATERIALORIGIN,
    _BR_MATERIALUSAGE,
    _BR_NCM,
    _COMPANYCODE,
    _CONFIGURABLEPRODUCT,
    _CONSUMPTIONPOSTING,
    _CUSTOMER,
    _DOCUMENTCURRENCY,
    _INCOTERMSCLASSIFICATION,
    _MANUALDELIVERYADDRESS,
    _MANUFACTURER,
    _MANUFACTURERMATERIAL,
    _MATERIAL,
    _MATERIALGROUP,
    _ORDERPRICEUNIT,
    _ORDERQUANTITYUNIT,
    _PLANT,
    _PRIORSUPPLIER,
    _PRODUCTCATEGORY,
    _PRODUCTTYPE,
    _PURCHASECONTRACT,
    _PURCHASECONTRACTITEM,
    _PURCHASEREQUISITION,
    _PURCHASEREQUISITIONITEM,
    _PURCHASINGDOCUMENT,
    _PURCHASINGINFORECORD,
    _PURGDOCUMENTCATEGORY,
    _PURGDOCUMENTITEMCATEGORY,
    _REFERENCEDELIVERYADDRESS,
    _RETAILPROMOTION,
    _SCHEDULELINE,
    _SERVICEPERFORMER,
    _STORAGELOCATION,
    _SUBCONTRACTOR,
    _VOLUMEUNIT,
    _WEIGHTUNIT,
    ACCOUNTASSIGNMENTCATEGORY,
    ALLOCATIONTABLE,
    ALLOCATIONTABLEITEM,
    ARTICLECATEGORY,
    BASEUNIT,
    BR_CFOPCATEGORY,
    BR_ISPRODUCEDINHOUSE,
    BR_MATERIALORIGIN,
    BR_MATERIALUSAGE,
    BR_NCM,
    BUDGETPERIOD,
    COMMITMENTITEM,
    COMMODITYCODE,
    COMPANYCODE,
    CONSUMPTIONPOSTING,
    COSTCENTER,
    CREATIONDATE,
    CREATIONTIME,
    CROSSPLANTCONFIGURABLEPRODUCT,
    CUMULATIVEQUANTITYISNOTSENT,
    CUSTOMER,
    DELIVERYDOCUMENTTYPE,
    DISCOUNTINKINDELIGIBILITY,
    DOCUMENTCURRENCY,
    DOWNPAYMENTAMOUNT,
    DOWNPAYMENTDUEDATE,
    DOWNPAYMENTPERCENTAGEOFTOTAMT,
    DOWNPAYMENTTYPE,
    EARMARKEDFUNDSDOCUMENT,
    EFFECTIVEAMOUNT,
    EVALDRCPTSETTLMTISALLOWED,
    EXPECTEDOVERALLLIMITAMOUNT,
    FIRMTRADEOFFZONEBINDMRP,
    FUNCTIONALAREA,
    FUND,
    FUNDSCENTER,
    GLACCOUNT,
    GOODSRECEIPTDURATIONINDAYS,
    GOODSRECEIPTISEXPECTED,
    GOODSRECEIPTISNONVALUATED,
    GOODSRECEIPTLATESTCREATIONDATE,
    GRANTID,
    GROSSAMOUNT,
    INCOTERMSCLASSIFICATION,
    INCOTERMSLOCATION1,
    INCOTERMSLOCATION2,
    INCOTERMSTRANSFERLOCATION,
    INTERNATIONALARTICLENUMBER,
    INTRASTATSERVICECODE,
    INVENTORYSPECIALSTOCKTYPE,
    INVOICEISEXPECTED,
    INVOICEISGOODSRECEIPTBASED,
    ISCOMPLETELYDELIVERED,
    ISENDOFPURPOSEBLOCKED,
    ISFINALLYINVOICED,
    ISINFOATREGISTRATION,
    ISORDERACKNRQD,
    ISRELEVANTFORJITDELIVSCHEDULE,
    ISRETURNSITEM,
    ISSTATISTICALITEM,
    ISSUINGSTORAGELOCATION,
    ITEMGROSSWEIGHT,
    ITEMISREJECTEDBYSUPPLIER,
    ITEMLASTTRANSMISSIONDATE,
    ITEMNETWEIGHT,
    ITEMVOLUME,
    MANUALDELIVERYADDRESSID,
    MANUFACTURER,
    MANUFACTURERMATERIAL,
    MANUFACTURERPARTNMBR,
    MATERIALFREIGHTGROUP,
    MATERIALTYPE,
    MINREMAININGSHELFLIFE,
    MRPAREA,
    MULTIPLEACCTASSGMTDISTRIBUTION,
    NETAMOUNT,
    NETPRICEAMOUNT,
    NETPRICEQUANTITY,
    NEXTFCSTDELIVSCHEDSENDINGDATE,
    NEXTJITDELIVSCHEDSENDINGDATE,
    NODAYSREMINDER1,
    NODAYSREMINDER2,
    NODAYSREMINDER3,
    NONDEDUCTIBLEINPUTTAXAMOUNT,
    ORDERITEMQTYTOBASEQTYDNMNTR,
    ORDERITEMQTYTOBASEQTYNMRTR,
    ORDERPRICEUNIT,
    ORDERPRICEUNITTOORDERUNITNMRTR,
    ORDERQUANTITY,
    ORDERQUANTITYUNIT,
    ORDPRICEUNITTOORDERUNITDNMNTR,
    OUTWARDDELIVERYISCOMPLETE,
    OVERALLLIMITAMOUNT,
    OVERDELIVTOLRTDLMTRATIOINPCT,
    PARTIALDELIVERYISALLOWED,
    PARTIALINVOICEDISTRIBUTION,
    PLANNEDDELIVERYDURATIONINDAYS,
    PLNDORDERREPLNMTELMNTTYPE,
    PRICEISTOBEPRINTED,
    PRICINGDATECONTROL,
    PRIORSUPPLIER,
    PRODUCTPURCHASEPOINTSQTY,
    PRODUCTPURCHASEPOINTSQTYUNIT,
    PRODUCTTYPE,
    PROFITCENTER,
    PURCHASECONTRACT,
    PURCHASECONTRACTITEM,
    PURCHASEREQUISITION,
    PURCHASEREQUISITIONITEM,
    PURCHASINGDOCUMENTCATEGORY,
    PURCHASINGDOCUMENTDELETIONCODE,
    PURCHASINGDOCUMENTITEMCATEGORY,
    PURCHASINGDOCUMENTITEMTEXT,
    PURCHASINGINFORECORD,
    PURCHASINGORDERREASON,
    PURCHASINGPARENTITEM,
    PURCONTRACTFOROVERALLLIMIT,
    PURGDOCITMBLKRSNCODE,
    PURGDOCITMTARGETAMOUNT,
    PURGDOCORDERACKNNUMBER,
    PURGDOCPRICEDATE,
    PURGDOCRELEASEORDERQUANTITY,
    PURGITEMISBLOCKEDFORDELIVERY,
    QUALITYCERTIFICATETYPE,
    QUALITYMGMTCTRLKEY,
    REFERENCEDELIVERYADDRESSID,
    REQUESTFORQUOTATION,
    REQUIREMENTSEGMENT,
    REQUIREMENTTRACKING,
    REQUISITIONERNAME,
    RETAILPROMOTION,
    SCHEDAGRMTAGREEDCUMQTY,
    SCHEDAGRMTCUMQTYRECONCILEDATE,
    SCHEDAGRMTCUMULATIVEQTYCONTROL,
    SCHEDGAGRMTRELCREATIONPROFILE,
    SCHEDLINESEMIFIRMORDERINDAYS,
    SCHEDULELINEFIRMORDERINDAYS,
    SERVICEPACKAGE,
    SERVICEPERFORMER,
    SHELFLIFEEXPIRATIONDATEPERIOD,
    SHIPPINGINSTRUCTION,
    STOCKSEGMENT,
    STOCKTYPE,
    STORAGELOCATION,
    SUBCONTRACTOR,
    SUBTOTAL1AMOUNT,
    SUBTOTAL2AMOUNT,
    SUBTOTAL3AMOUNT,
    SUBTOTAL4AMOUNT,
    SUBTOTAL5AMOUNT,
    SUBTOTAL6AMOUNT,
    SUPPLIERCONFIRMATIONCONTROLKEY,
    SUPPLIERISSUBCONTRACTOR,
    SUPPLIERMATERIALNUMBER,
    SUPPLIERSUBRANGE,
    TARGETAMOUNT,
    TARGETQUANTITY,
    TAXCODE,
    TAXJURISDICTION,
    THIRDPTYORDPROCGEXTREFERENCE,
    THIRDPTYORDPROCGEXTREFITEM,
    UNDERDELIVTOLRTDLMTRATIOINPCT,
    UNLIMITEDOVERDELIVERYISALLOWED,
    VALUATIONCATEGORY,
    VALUATIONTYPE,
    VOLUMEUNIT,
    WEIGHTUNIT,
    PRIMARY KEY (MATERIAL, MATERIALGROUP, PLANT, PURCHASINGDOCUMENT, PURCHASINGDOCUMENTITEM, PURCHASINGDOCUMENTITEMUNIQUEID, REQUESTFORQUOTATIONITEM, SUPPLIERQUOTATION, SUPPLIERQUOTATIONITEM)
);

Learn More