I_PURCHASINGDOCUMENTITEM
Purchasing Document Item
I_PURCHASINGDOCUMENTITEM is a CDS View in S/4HANA. Purchasing Document Item. It contains 102 fields. 94 CDS views read from this table.
CDS Views using this table (94)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| C_DspDocFlwPurDocItemAttrib | view_entity | from | CONSUMPTION | PO Item Attributes for DDF |
| 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_entity | 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_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 | from | 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_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_MRPPurchaseOrder | view | inner | COMPOSITE | MRP Purchase Order |
| I_MRPTransferDemand | view_entity | inner | COMPOSITE | Transfer Demand |
| I_ProdCmplncLicRlvtPurgDocs | view | from | COMPOSITE | License Relevant Purchase Order Items |
| I_PurchaseOrderItemPurgIssue | view | inner | COMPOSITE | SOFM Purchase Order Item Purchasing Issue |
| I_PurchaseOrderOfSIT | view_entity | 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_ShippingNotifQuickView | view_entity | inner | COMPOSITE | MRP Shipping Notifications |
| I_SourcesOfSupply | view | from | COMPOSITE | Sources of Supply |
| I_SupAssgmtSitnOrdItemDet | view | union_all | COMPOSITE | View at Order item details for situation |
| Mmim_MatDocDocFlow | view_entity | inner | Material Documents Document Flow | |
| 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 | View for demand item SD |
| P_DDMaterialSOS | view | inner | CONSUMPTION | Source of Supply for DDR Materials |
| P_DDOrderDetails | view | union_all | CONSUMPTION | Order Details in Replenishment App |
| P_DDPurchaseOrder | view | inner | COMPOSITE | Purchase Order Basic Details |
| P_FilteredSourceOfSupply | view | inner | CONSUMPTION | Filtered Source of Supply |
| P_GetLastPostingDate | view_entity | from | COMPOSITE | Get last Posting Date of Material Documents |
| P_GRIR_USER | view_entity | from | CONSUMPTION | User for GRIR Reconcilaition |
| P_JITMatlRcpntDocuments | view_entity | from | COMPOSITE | Just-In-Time Material Combined Recipient Documents |
| P_JP_IRPurchaseDocumentHeader | view | inner | COMPOSITE | Invoice Receipt Purchase Document Header List |
| P_MY_SupplierInvoiceItem | view | inner | COMPOSITE | Supplier Invoice Item for MY GAF |
| P_POItemCastedAmounts | view | from | CONSUMPTION | PO Item Casted Amounts |
| P_PurchaseOrderProjectElement | view_entity | inner | COMPOSITE | PurchaseOrder with ProjElement and ScheduleLine |
| P_Purchaseorders_Fs | view | left_outer | BASIC | Private factsheet - Purchase Orders |
| 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 | Supplier Confirmation per Confirmation Category |
| 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 | PO Maintenance: Pur. Doc. Item with Account Assignment Line |
| P_PurReqnSuccssrDocs | view | from | COMPOSITE | Direct Successor documents of Pur Reqn |
| P_RFQSuccssrDocs | view | from | COMPOSITE | Successor documents of PR->RFq |
| P_RFQSuccssrDocs | view | union_all | COMPOSITE | Successor documents of PR->RFq |
| P_RU_MaterialRcptDateMM3 | view | inner | CONSUMPTION | FI RU get Material Receipt Date: MM-3 |
| P_RU_PurchaseOrderHistoryGRIR | view | from | CONSUMPTION | FI RU PurchaseOrder History GR/IR |
| P_RU_SuplrInvcAcctgItem | view | inner | CONSUMPTION | Supplier Invoice: Accounting Document & Accounting Item |
| P_RU_SuplrInvcLogsItem | view | inner | CONSUMPTION | Supplier Invoice: Accounting Document & Logistics Item |
| P_SalesOrderInSupplyPurgIssue1 | view | from | COMPOSITE | SOFM Purchasing Issue 1 |
| P_SalesOrderInSupplyPurgIssue4 | view | from | COMPOSITE | SOFM Purchasing Issue 4 |
| P_SCHDLNMIGRATION | view | inner | CONSUMPTION | Schedule Line Migration |
| P_SLLMINMAXRELEVANTPOITEMS | view | inner | COMPOSITE | PO history for min and max order price determination |
| P_SlsOrderInSupplyPurgIssue3 | view | from | COMPOSITE | SOFM Purchasing Issue 3 V2 |
| P_SlsOrderInSupplyPurgIssue3 | view | union_all | COMPOSITE | SOFM Purchasing Issue 3 V2 |
| P_SourcesOfSupply | view | inner | COMPOSITE | Collection of all individual SOS records |
| P_TotalGrInvQty | view | from | CONSUMPTION | Total GR and Invoice Quantity |
| shsm_ekpo_ekko | view | from | Value Help for Purchasing Document |
Fields (102)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | Material | Material,matnr,Product | 28 |
| KEY | MaterialGroup | MaterialGroup,matkl,ProductGroup | 19 |
| KEY | Plant | MRPPlant,Plant,werks | 32 |
| KEY | PurchasingDocument | OrderID,PurchaseOrder,PurchasingDocument,PurchasingDocumentNumber,RequestForQuotation,SchedulingAgreement,SourceDocument,StockTransportOrder,SubsequentDocument | 46 |
| KEY | PurchasingDocumentItem | PurchaseOrderItem,PurchasingDocumentItem,PurchasingDocumentItemNumber,SchedulingAgreementItem,SourceDocumentItem,SubsequentDocumentItem | 52 |
| KEY | PurchasingDocumentItemUniqueID | MaintOrdProcurementDocument,PurchasingDocumentItemUniqueID | 4 |
| KEY | RequestForQuotationItem | PrecedingDocumentItem | 1 |
| KEY | SupplierQuotation | PrecedingDocument | 1 |
| KEY | SupplierQuotationItem | PrecedingDocumentItem | 1 |
| _CompanyCode | _CompanyCode | 4 | |
| _ConsumptionPosting | _ConsumptionPosting | 2 | |
| _DocumentCurrency | _DocumentCurrency | 5 | |
| _ManufacturerMaterial | _ManufacturerMaterial | 1 | |
| _Material | _Material | 3 | |
| _MaterialGroup | _MaterialGroup | 3 | |
| _OrderQuantityUnit | _OrderQuantityUnit | 2 | |
| _Plant | _Plant | 6 | |
| _ProductType | _ProductType | 1 | |
| _PurchaseContract | _PurchaseContract | 1 | |
| _PurchaseContractItem | _PurchaseContractItem | 1 | |
| _PurchasingDocument | _PurchasingDocument,_Schedgagrmthdr | 10 | |
| _PurchasingInfoRecord | _PurchasingInfoRecord | 1 | |
| _PurgDocumentCategory | _PurgDocumentCategory | 3 | |
| _PurgDocumentItemCategory | _PurgDocumentItemCategory | 2 | |
| AccountAssignmentCategory | AccountAssignmentCategory,knttp | 6 | |
| BaseUnit | BaseUnit,lmein | 9 | |
| BudgetPeriod | BudgetPeriod | 2 | |
| CommitmentItem | CommitmentItemShortID | 1 | |
| CompanyCode | bukrs,CompanyCode | 8 | |
| ConsumptionPosting | ConsumptionPosting | 2 | |
| DocumentCurrency | Currency,DocumentCurrency,MaintOrdOpComponentCurrency | 16 | |
| EvaldRcptSettlmtIsAllowed | EvaldRcptSettlmtIsAllowed | 2 | |
| ExpectedOverallLimitAmount | ExpectedOverallLimitAmount | 2 | |
| FunctionalArea | FunctionalArea | 2 | |
| Fund | Fund | 2 | |
| FundsCenter | FundsCenter | 2 | |
| GoodsReceiptDurationInDays | GoodsReceiptDurationInDays,MaterialGoodsReceiptDuration | 3 | |
| GoodsReceiptIsExpected | GoodsReceiptIsExpected,wepos | 11 | |
| GoodsReceiptIsNonValuated | GoodsReceiptIsNonValuated | 3 | |
| GrantID | GrantID | 2 | |
| GrossAmount | GrossAmount | 2 | |
| IncotermsClassification | IncotermsClassification | 1 | |
| IncotermsLocation1 | IncotermsLocation1 | 1 | |
| IncotermsLocation2 | IncotermsLocation2 | 1 | |
| IncotermsTransferLocation | IncotermsTransferLocation | 1 | |
| InventorySpecialStockType | InventorySpecialStockType | 5 | |
| InvoiceIsExpected | InvoiceIsExpected | 3 | |
| InvoiceIsGoodsReceiptBased | InvoiceIsGoodsReceiptBased,webre | 8 | |
| IsCompletelyDelivered | elikz,IsCompletelyDelivered | 14 | |
| IsEndOfPurposeBlocked | IsEndOfPurposeBlocked | 7 | |
| IsFinallyInvoiced | IsFinallyInvoiced | 9 | |
| IsOrderAcknRqd | IsOrderAcknRqd | 2 | |
| IsReturnsItem | IsReturnsItem,retpo | 6 | |
| IsStatisticalItem | IsStatisticalItem | 2 | |
| ManualDeliveryAddressID | ManualDeliveryAddressID | 1 | |
| Manufacturer | Manufacturer | 1 | |
| ManufacturerMaterial | ManufacturerMaterial,MaterialNumber | 4 | |
| ManufacturerPartNmbr | ManufacturerPartNmbr | 1 | |
| MaterialType | MaterialType | 2 | |
| MultipleAcctAssgmtDistribution | MultipleAcctAssgmtDistribution,vrtkz | 5 | |
| NetAmount | NetAmount,NetValueInDocCurrency,netwr | 10 | |
| NetPriceAmount | netpr,NetPriceAmount | 13 | |
| NetPriceQuantity | NetPriceQuantity,peinh | 7 | |
| NonDeductibleInputTaxAmount | NonDeductibleInputTaxAmount | 2 | |
| OrderItemQtyToBaseQtyDnmntr | ConvDenominatorToBaseUnit,OrderItemQtyToBaseQtyDnmntr,umren | 7 | |
| OrderItemQtyToBaseQtyNmrtr | ConvNumeratorToBaseUnit,OrderItemQtyToBaseQtyNmrtr,umrez | 7 | |
| OrderPriceUnit | bprme,OrderPriceUnit | 5 | |
| OrderPriceUnitToOrderUnitNmrtr | BPUMZ,OrderPriceUnitToOrderUnitNmrtr | 4 | |
| OrderQuantity | FldLogsPOTotalQty,MENGE_EKPO,OrderQuantity,PurchaseOrderItemQuantity,PurchasingDocumentOrderQty,RequirementQuantityInBaseUnit | 17 | |
| OrderQuantityUnit | BaseUnit,meins,MEINS_EKPO,OrderQuantityUnit,OrderUnit,OrderUnitOfMeassure,PurchaseOrderItemQuantityUnit,PurchaseOrderQuantityUnit,PurgDocOrderQuantityUnit | 33 | |
| OrdPriceUnitToOrderUnitDnmntr | bpumn,OrdPriceUnitToOrderUnitDnmntr | 4 | |
| OverallLimitAmount | OverallLimitAmount | 3 | |
| PartialDeliveryIsAllowed | PartialDeliveryIsAllowed | 4 | |
| PartialInvoiceDistribution | PartialInvoiceDistribution | 3 | |
| PlannedDeliveryDurationInDays | MaterialPlannedDeliveryDurn,PlannedDeliveryDurationInDays | 3 | |
| PlndOrderReplnmtElmntType | PlndOrderReplnmtElmntType | 1 | |
| ProductType | ProductType,ProductTypeCode,PurgDocProductType | 6 | |
| ProfitCenter | ProfitCenter | 3 | |
| PurchaseContract | konnr,PurchaseContract,PurchaseOutlineAgreement | 4 | |
| PurchaseContractItem | KTPNR,PurchaseContractItem,PurchaseOutlineAgreementItem | 3 | |
| PurchaseRequisition | PurchaseRequisition | 8 | |
| PurchaseRequisitionItem | PurchaseRequisitionItem | 7 | |
| PurchasingDocumentCategory | PurchasingDocumentCategory,SourceDocumentType,SubsequentDocumentCategory | 16 | |
| PurchasingDocumentDeletionCode | loekz,PurchasingDocItemDeletionCode,PurchasingDocumentDeletionCode | 10 | |
| PurchasingDocumentItemCategory | ItemCategory,MaterialProcurementCategory,pstyp,PurchasingDocumentItemCategory | 13 | |
| PurchasingDocumentItemText | ComponentDescription,PurchasingDocumentItemText,PurchasingText,ShortText | 18 | |
| PurchasingInfoRecord | PurchasingInfoRecord | 3 | |
| ReferenceDeliveryAddressID | ReferenceDeliveryAddressID | 1 | |
| RequirementTracking | RequirementTracking | 2 | |
| RequisitionerName | RequisitionerName | 2 | |
| ServicePackage | ServicePackage | 2 | |
| ServicePerformer | ServicePerformer | 2 | |
| StockType | TargetStockType | 1 | |
| StorageLocation | lgort,StorageLocation | 6 | |
| Subcontractor | Subcontractor | 1 | |
| SupplierConfirmationControlKey | bstae,ConfirmationControl,SupplierConfirmationControlKey | 3 | |
| SupplierMaterialNumber | SupplierMaterialNumber | 3 | |
| TargetQuantity | TargetQuantity | 4 | |
| TaxCode | TaxCode | 3 | |
| TaxJurisdiction | TaxJurisdiction | 2 | |
| UnderdelivTolrtdLmtRatioInPct | UnderdelivTolrtdLmtRatioInPct | 1 | |
| ValuationType | ValuationType | 2 |
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Purchasing Document Item'
@AccessControl.authorizationCheck:#CHECK
@AccessControl.privilegedAssociations: [ '_ManualDeliveryAddress', '_ReferenceDeliveryAddress' ]
@AccessControl.personalData.blocking:#REQUIRED
@VDM.viewType: #BASIC
@AbapCatalog.sqlViewName: 'IMMPURGDOCITEM'
@AbapCatalog.preserveKey: true
@ObjectModel.representativeKey: 'PurchasingDocumentItem'
@Metadata.ignorePropagatedAnnotations: true
@AbapCatalog.compiler.compareFilter:true
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
define view I_PurchasingDocumentItem
as select from ekpo
association [1..1] to I_PurchasingDocument as _PurchasingDocument on $projection.PurchasingDocument = _PurchasingDocument.PurchasingDocument
association [0..*] to I_PurgDocScheduleLine as _ScheduleLine on $projection.PurchasingDocument = _ScheduleLine.PurchasingDocument
and $projection.PurchasingDocumentItem = _ScheduleLine.PurchasingDocumentItem
association [0..1] to I_Purchaserequisition as _PurchaseRequisition on $projection.PurchaseRequisition = _PurchaseRequisition.PurchaseRequisition
association [0..1] to I_Purchaserequisitionitem as _PurchaseRequisitionItem on $projection.PurchaseRequisition = _PurchaseRequisitionItem.PurchaseRequisition
and $projection.PurchaseRequisitionItem = _PurchaseRequisitionItem.PurchaseRequisitionItem
association [0..1] to I_PurchaseContract as _PurchaseContract on $projection.PurchaseContract = _PurchaseContract.PurchaseContract
association [0..1] to I_PurchaseContractItem as _PurchaseContractItem on $projection.PurchaseContract = _PurchaseContractItem.PurchaseContract
and $projection.PurchaseContractItem = _PurchaseContractItem.PurchaseContractItem
association [0..1] to I_PurchasingInfoRecordApi01 as _PurchasingInfoRecord on $projection.PurchasingInfoRecord = _PurchasingInfoRecord.PurchasingInfoRecord
association [0..1] to I_CompanyCode as _CompanyCode on $projection.CompanyCode = _CompanyCode.CompanyCode
association [0..1] to I_Plant as _Plant on $projection.Plant = _Plant.Plant
association [0..1] to I_StorageLocation as _StorageLocation on $projection.Plant = _StorageLocation.Plant
and $projection.StorageLocation = _StorageLocation.StorageLocation
association [0..1] to I_Material as _Material on $projection.Material = _Material.Material
association [0..1] to I_Material as _ManufacturerMaterial on $projection.ManufacturerMaterial = _ManufacturerMaterial.Material
association [0..1] to I_Material as _ConfigurableProduct on $projection.CrossPlantConfigurableProduct = _ConfigurableProduct.Material
association [0..1] to I_MaterialGroup as _MaterialGroup on $projection.MaterialGroup = _MaterialGroup.MaterialGroup
association [0..1] to I_UnitOfMeasure as _BaseUnit on $projection.BaseUnit = _BaseUnit.UnitOfMeasure
association [0..1] to I_UnitOfMeasure as _OrderQuantityUnit on $projection.OrderQuantityUnit = _OrderQuantityUnit.UnitOfMeasure
association [0..1] to I_UnitOfMeasure as _VolumeUnit on $projection.VolumeUnit = _VolumeUnit.UnitOfMeasure
association [0..1] to I_UnitOfMeasure as _WeightUnit on $projection.WeightUnit = _WeightUnit.UnitOfMeasure
association [0..1] to I_UnitOfMeasure as _OrderPriceUnit on $projection.OrderPriceUnit = _OrderPriceUnit.UnitOfMeasure
association [0..1] to I_Address as _ManualDeliveryAddress on $projection.ManualDeliveryAddressID = _ManualDeliveryAddress.AddressID
association [0..1] to I_Address as _ReferenceDeliveryAddress on $projection.ReferenceDeliveryAddressID = _ReferenceDeliveryAddress.AddressID
association [0..1] to I_PurchasingDocumentCategory as _PurgDocumentCategory on $projection.PurchasingDocumentCategory = _PurgDocumentCategory.PurchasingDocumentCategory
association [0..1] to I_PurgDocumentItemCategory as _PurgDocumentItemCategory on $projection.PurchasingDocumentItemCategory = _PurgDocumentItemCategory.PurchasingDocumentItemCategory
association [0..1] to I_Supplier as _Manufacturer on $projection.Manufacturer = _Manufacturer.Supplier
association [0..1] to I_Supplier as _Subcontractor on $projection.Subcontractor = _Subcontractor.Supplier
association [0..1] to I_Supplier as _PriorSupplier on $projection.PriorSupplier = _PriorSupplier.Supplier
association [0..1] to I_Customer as _Customer on $projection.Customer = _Customer.Customer
association [0..1] to I_IncotermsClassification as _IncotermsClassification on $projection.IncotermsClassification = _IncotermsClassification.IncotermsClassification
association [0..1] to I_BusinessPartner as _ServicePerformer on $projection.ServicePerformer = _ServicePerformer.BusinessPartner
association [0..1] to I_ProductTypeCode as _ProductType on $projection.ProductType = _ProductType.ProductTypeCode
association [0..1] to I_ProductCategory as _ProductCategory on $projection.ArticleCategory = _ProductCategory.ProductCategory
association [0..1] to I_AccountAssignmentCategory as _AccountAssignmentCategory on $projection.AccountAssignmentCategory = _AccountAssignmentCategory.AccountAssignmentCategory
association [0..1] to I_ConsumptionPosting as _ConsumptionPosting on $projection.ConsumptionPosting = _ConsumptionPosting.ConsumptionPosting
association [0..1] to I_AllocationTable as _AllocationTable on $projection.AllocationTable = _AllocationTable.AllocationTable
association [0..1] to I_AllocationTableItem as _AllocationTableItem on $projection.AllocationTableItem = _AllocationTableItem.AllocationTableItem
and $projection.AllocationTable = _AllocationTableItem.AllocationTable
association [0..1] to I_RetailPromotion as _RetailPromotion on $projection.RetailPromotion = _RetailPromotion.RetailPromotion
association [0..1] to E_PurchasingDocumentItem as _ItemExtension on $projection.PurchasingDocument = _ItemExtension.PurchasingDocument
and $projection.PurchasingDocumentItem = _ItemExtension.PurchasingDocumentItem
----Brazil Extension Associations
association [0..1] to I_BR_MaterialOrigin as _BR_MaterialOrigin on _BR_MaterialOrigin.BR_MaterialOrigin = $projection.BR_MaterialOrigin
association [0..1] to I_BR_MaterialUsage as _BR_MaterialUsage on _BR_MaterialUsage.BR_MaterialUsage = $projection.BR_MaterialUsage
association [0..1] to I_BR_CFOPCategory as _BR_CFOPCategory on _BR_CFOPCategory.BR_CFOPCategory = $projection.BR_CFOPCategory
association [0..1] to I_BR_NCM as _BR_NCM on _BR_NCM.CountryCode = 'BR'
and _BR_NCM.BR_NCM = $projection.BR_NCM
{
@ObjectModel.foreignKey.association: '_PurchasingDocument'
key ekpo.ebeln as PurchasingDocument,
key ekpo.ebelp as PurchasingDocumentItem,
ekpo.uniqueid as PurchasingDocumentItemUniqueID,
@ObjectModel.foreignKey.association: '_PurgDocumentCategory'
ekpo.bstyp as PurchasingDocumentCategory,
ekpo.loekz as PurchasingDocumentDeletionCode,
@ObjectModel.foreignKey.association: '_Material'
ekpo.matnr as Material,
ekpo.idnlf as SupplierMaterialNumber,
@ObjectModel.foreignKey.association: '_ManufacturerMaterial'
ekpo.ematn as ManufacturerMaterial,
ekpo.mfrpn as ManufacturerPartNmbr,
@ObjectModel.foreignKey.association: '_Manufacturer'
ekpo.mfrnr as Manufacturer,
@Semantics.text: true
ekpo.txz01 as PurchasingDocumentItemText,
@ObjectModel.foreignKey.association: '_CompanyCode'
ekpo.bukrs as CompanyCode,
@ObjectModel.foreignKey.association: '_Plant'
ekpo.werks as Plant,
@ObjectModel.foreignKey.association: '_ManualDeliveryAddress'
ekpo.adrnr as ManualDeliveryAddressID,
@ObjectModel.foreignKey.association: '_ReferenceDeliveryAddress'
ekpo.adrn2 as ReferenceDeliveryAddressID,
@ObjectModel.foreignKey.association: '_Customer'
ekpo.kunnr as Customer,
@ObjectModel.foreignKey.association: '_Subcontractor'
ekpo.emlif as Subcontractor,
ekpo.lblkz as SupplierIsSubcontractor,
@ObjectModel.foreignKey.association: '_ConfigurableProduct'
ekpo.satnr as CrossPlantConfigurableProduct,
@ObjectModel.foreignKey.association: '_ProductCategory'
ekpo.attyp as ArticleCategory,
ekpo.kanba as PlndOrderReplnmtElmntType,
@Semantics.unitOfMeasure: true
ekpo.punei as ProductPurchasePointsQtyUnit,
@Semantics.quantity.unitOfMeasure: 'ProductPurchasePointsQtyUnit'
@DefaultAggregation: #NONE
ekpo.anzpu as ProductPurchasePointsQty,
//_Plant.AddressID as PlantAddressID,
@ObjectModel.foreignKey.association: '_StorageLocation'
cast (ekpo.lgort as vdm_storage_location preserving type) as StorageLocation,
@ObjectModel.foreignKey.association: '_MaterialGroup'
ekpo.matkl as MaterialGroup,
@Semantics.unitOfMeasure: true
ekpo.meins as OrderQuantityUnit,
ekpo.umrez as OrderItemQtyToBaseQtyNmrtr,
ekpo.umren as OrderItemQtyToBaseQtyDnmntr,
@Semantics.quantity.unitOfMeasure: 'OrderPriceUnit'
@DefaultAggregation: #NONE
cast (ekpo.peinh as vdm_price_unit preserving type) as NetPriceQuantity,
ekpo.elikz as IsCompletelyDelivered,
ekpo.erekz as IsFinallyInvoiced,
ekpo.wepos as GoodsReceiptIsExpected,
ekpo.repos as InvoiceIsExpected,
ekpo.eglkz as OutwardDeliveryIsComplete,
ekpo.webre as InvoiceIsGoodsReceiptBased,
ekpo.weunb as GoodsReceiptIsNonValuated,
ekpo.banfn as PurchaseRequisition,
// @ObjectModel.foreignKey.association: '_PurchaseRequisitionItem'
ekpo.bnfpo as PurchaseRequisitionItem,
ekpo.packno as ServicePackage,
@ObjectModel.foreignKey.association: '_ServicePerformer'
ekpo.serviceperformer as ServicePerformer,
@ObjectModel.foreignKey.association: '_ProductType'
ekpo.producttype as ProductType,
ekpo.mtart as MaterialType,
@ObjectModel.foreignKey.association: '_PurchaseContractItem'
ekpo.ktpnr as PurchaseContractItem,
@ObjectModel.foreignKey.association: '_PurchaseContract'
ekpo.konnr as PurchaseContract,
// @ObjectModel.foreignKey.association: '_RequestForQuotation'
ekpo.requestforquotation as RequestForQuotation,
// @ObjectModel.foreignKey.association: '_RequestForQuotationItem'
ekpo.requestforquotationitem as RequestForQuotationItem,
ekpo.xersy as EvaldRcptSettlmtIsAllowed,
ekpo.uebtk as UnlimitedOverdeliveryIsAllowed,
ekpo.uebto as OverdelivTolrtdLmtRatioInPct,
ekpo.untto as UnderdelivTolrtdLmtRatioInPct,
ekpo.afnam as RequisitionerName,
ekpo.berid as MRPArea,
@ObjectModel.foreignKey.association: '_IncotermsClassification'
ekpo.inco1 as IncotermsClassification,
ekpo.inco2 as IncotermsTransferLocation,
ekpo.inco2_l as IncotermsLocation1,
ekpo.inco3_l as IncotermsLocation2,
@ObjectModel.foreignKey.association: '_PriorSupplier'
ekpo.kolif as PriorSupplier,
ekpo.ean11 as InternationalArticleNumber,
ekpo.bstae as SupplierConfirmationControlKey,
ekpo.prsdr as PriceIsToBePrinted,
@Semantics.unitOfMeasure: true
ekpo.lmein as BaseUnit,
@ObjectModel.foreignKey.association: '_PurgDocumentItemCategory'
ekpo.pstyp as PurchasingDocumentItemCategory,
ekpo.ko_prctr as ProfitCenter,
@Semantics.unitOfMeasure: true
ekpo.bprme as OrderPriceUnit,
@Semantics.unitOfMeasure: true
ekpo.voleh as VolumeUnit,
@Semantics.unitOfMeasure: true
ekpo.gewei as WeightUnit,
ekpo.vrtkz as MultipleAcctAssgmtDistribution,
ekpo.twrkz as PartialInvoiceDistribution,
ekpo.meprf as PricingDateControl,
ekpo.stapo as IsStatisticalItem,
ekpo.uebpo as PurchasingParentItem,
ekpo.lewed as GoodsReceiptLatestCreationDate,
ekpo.retpo as IsReturnsItem,
ekpo.bsgru as PurchasingOrderReason,
ekpo.knttp as AccountAssignmentCategory,
@ObjectModel.foreignKey.association: '_PurchasingInfoRecord'
ekpo.infnr as PurchasingInfoRecord,
@Semantics.amount.currencyCode: 'DocumentCurrency'
@DefaultAggregation: #NONE
ekpo.netwr as NetAmount,
@Semantics.amount.currencyCode: 'DocumentCurrency'
@DefaultAggregation: #NONE
ekpo.brtwr as GrossAmount,
@Semantics.amount.currencyCode: 'DocumentCurrency'
@Aggregation.default: #NONE
ekpo.effwr as EffectiveAmount,
@Semantics.amount.currencyCode: 'DocumentCurrency'
@DefaultAggregation: #NONE
ekpo.kzwi1 as Subtotal1Amount,
@Semantics.amount.currencyCode: 'DocumentCurrency'
@DefaultAggregation: #NONE
ekpo.kzwi2 as Subtotal2Amount,
@Semantics.amount.currencyCode: 'DocumentCurrency'
@DefaultAggregation: #NONE
ekpo.kzwi3 as Subtotal3Amount,
@Semantics.amount.currencyCode: 'DocumentCurrency'
@DefaultAggregation: #NONE
ekpo.kzwi4 as Subtotal4Amount,
@Semantics.amount.currencyCode: 'DocumentCurrency'
@DefaultAggregation: #NONE
ekpo.kzwi5 as Subtotal5Amount,
@Semantics.amount.currencyCode: 'DocumentCurrency'
@DefaultAggregation: #NONE
ekpo.kzwi6 as Subtotal6Amount,
@Semantics.quantity.unitOfMeasure: 'OrderQuantityUnit'
@DefaultAggregation: #NONE
ekpo.ktmng as TargetQuantity,
@Semantics.quantity.unitOfMeasure: 'OrderQuantityUnit'
@DefaultAggregation: #NONE
ekpo.menge as OrderQuantity,
@Semantics.amount.currencyCode: 'DocumentCurrency'
@DefaultAggregation: #NONE
ekpo.netpr as NetPriceAmount,
@Semantics.amount.currencyCode: 'DocumentCurrency'
@DefaultAggregation: #NONE
ekpo.zwert as TargetAmount,
@Semantics.quantity.unitOfMeasure: 'VolumeUnit'
@DefaultAggregation: #NONE
ekpo.volum as ItemVolume,
@Semantics.quantity.unitOfMeasure: 'WeightUnit'
@DefaultAggregation: #NONE
ekpo.brgew as ItemGrossWeight,
@Semantics.quantity.unitOfMeasure: 'WeightUnit'
@DefaultAggregation: #NONE
ekpo.ntgew as ItemNetWeight,
ekpo.bpumz as OrderPriceUnitToOrderUnitNmrtr,
ekpo.bpumn as OrdPriceUnitToOrderUnitDnmntr,
ekpo.abdat as SchedAgrmtCumQtyReconcileDate,
@Semantics.quantity.unitOfMeasure: 'OrderQuantityUnit'
ekpo.abftz as SchedAgrmtAgreedCumQty,
ekpo.drdat as ItemLastTransmissionDate,
ekpo.etfz1 as ScheduleLineFirmOrderInDays,
ekpo.etfz2 as SchedLineSemiFirmOrderInDays,
ekpo.mahn1 as NoDaysReminder1,
ekpo.mahn2 as NoDaysReminder2,
ekpo.mahn3 as NoDaysReminder3,
ekpo.bednr as RequirementTracking,
ekpo.kzabs as IsOrderAcknRqd,
ekpo.insmk as StockType,
ekpo.mwskz as TaxCode,
ekpo.txjcd as TaxJurisdiction,
ekpo.evers as ShippingInstruction,
@Semantics.amount.currencyCode: 'DocumentCurrency'
@DefaultAggregation: #NONE
ekpo.navnw as NonDeductibleInputTaxAmount,
ekpo.bwtar as ValuationType,
ekpo.bwtty as ValuationCategory,
ekpo.abskz as ItemIsRejectedBySupplier,
ekpo.prdat as PurgDocPriceDate,
ekpo.spinf as IsInfoRecordUpdated,
@Semantics.quantity.unitOfMeasure: 'OrderQuantityUnit'
ekpo.abmng as PurgDocReleaseOrderQuantity,
ekpo.labnr as PurgDocOrderAcknNumber,
ekpo.schpr as PurgDocEstimatedPrice,
@Semantics.booleanIndicator: true
ekpo.borgr_miss as IsInfoAtRegistration,
ekpo.ltsnr as SupplierSubrange,
ekpo.kostl as CostCenter,
ekpo.sakto as GLAccount,
ekpo.ps_psp_pnr as WBSElementInternalID,
ekpo.geber as Fund,
ekpo.budget_pd as BudgetPeriod,
ekpo.fistl as FundsCenter,
ekpo.fipos as CommitmentItem,
ekpo.fkber as FunctionalArea,
ekpo.grant_nbr as GrantID,
ekpo.kblnr as EarmarkedFunds,
ekpo.kblnr as EarmarkedFundsDocument,
ekpo.kblpos as EarmarkedFundsItem,
ekpo.kblpos as EarmarkedFundsDocumentItem,
ekpo.plifz as PlannedDeliveryDurationInDays,
ekpo.webaz as GoodsReceiptDurationInDays,
ekpo.kztlf as PartialDeliveryIsAllowed,
@ObjectModel.foreignKey.association: '_ConsumptionPosting'
ekpo.kzvbr as ConsumptionPosting,
ekpo.abueb as SchedgAgrmtRelCreationProfile,
ekpo.spe_cq_ctrltype as SchedAgrmtCumulativeQtyControl,
ekpo.spe_cq_nocq as CumulativeQuantityIsNotSent,
ekpo.mhdrz as MinRemainingShelfLife,
cast (ekpo.iprkz as vdm_dattp preserving type) as ShelfLifeExpirationDatePeriod, //Data element without conversion exit
ekpo.ssqss as QualityMgmtCtrlKey,
ekpo.sobkz as InventorySpecialStockType,
ekpo.fabkz as IsRelevantForJITDelivSchedule,
ekpo.nfabd as NextJITDelivSchedSendingDate,
ekpo.nlabd as NextFcstDelivSchedSendingDate,
ekpo.kzstu as FirmTradeOffZoneBindMRP,
ekpo.zgtyp as QualityCertificateType,
ekpo.anfnr as SupplierQuotation,
ekpo.anfps as SupplierQuotationItem,
ekpo.isvco as IntrastatServiceCode,
ekpo.stawn as CommodityCode,
ekpo.lfret as DeliveryDocumentType,
ekpo.mfrgr as MaterialFreightGroup,
ekpo.nrfhg as DiscountInKindEligibility,
ekpo.novet as PurgItemIsBlockedForDelivery,
ekpo.reslo as IssuingStorageLocation,
@ObjectModel.foreignKey.association: '_AllocationTable'
ekpo.abeln as AllocationTable,
@ObjectModel.foreignKey.association: '_AllocationTableItem'
ekpo.abelp as AllocationTableItem,
@ObjectModel.foreignKey.association: '_RetailPromotion'
ekpo.aktnr as RetailPromotion,
// Down Payment
ekpo.dptyp as DownPaymentType,
ekpo.dppct as DownPaymentPercentageOfTotAmt,
@Semantics.amount.currencyCode: 'DocumentCurrency'
ekpo.dpamt as DownPaymentAmount,
ekpo.dpdat as DownPaymentDueDate,
ekpo.creationtime as CreationTime,
ekpo.creationdate as CreationDate,
// S/4 Limit
@Semantics.amount.currencyCode: 'DocumentCurrency'
ekpo.expected_value as ExpectedOverallLimitAmount,
@Semantics.amount.currencyCode: 'DocumentCurrency'
ekpo.limit_amount as OverallLimitAmount,
ekpo.contract_for_limit as PurContractForOverallLimit,
ekpo.sgt_rcat as RequirementSegment,
//Brazil Extension
@ObjectModel.foreignKey.association: '_BR_MaterialOrigin'
ekpo.j_1bmatorg as BR_MaterialOrigin,
@ObjectModel.foreignKey.association: '_BR_MaterialUsage'
ekpo.j_1bmatuse as BR_MaterialUsage,
@ObjectModel.foreignKey.association: '_BR_CFOPCategory'
ekpo.j_1bindust as BR_CFOPCategory,
@ObjectModel.foreignKey.association: '_BR_NCM'
ekpo.j_1bnbm as BR_NCM,
ekpo.j_1bnbm as ConsumptionTaxCtrlCode,
ekpo.j_1bownpro as BR_IsProducedInHouse,
ekpo.extmaterialforpurg as PurchasingCentralMaterial,
@Semantics.amount.currencyCode: 'DocumentCurrency'
ekpo.target_value as PurgDocItmTargetAmount,
ekpo.spe_crm_ref_so as ThirdPtyOrdProcgExtReference,
ekpo.spe_crm_ref_item as ThirdPtyOrdProcgExtRefItem,
ekpo.blk_reason_id as PurgDocItmBlkRsnCode,
_PurchasingDocument.IsEndOfPurposeBlocked,
@Semantics.currencyCode: true
_PurchasingDocument.DocumentCurrency,
_PurchasingDocument._DocumentCurrency,
_CompanyCode,
_Plant,
_StorageLocation,
_Material,
_ManufacturerMaterial,
_ConfigurableProduct,
//_deletionTypeCode
_MaterialGroup,
_BaseUnit,
_OrderQuantityUnit,
// _PurchasingDocumentItemCategory,
// _ProfitCenter,
_VolumeUnit,
_WeightUnit,
_OrderPriceUnit,
_ManualDeliveryAddress,
_ReferenceDeliveryAddress,
// _DisplayDeliveryAddress,
_PurgDocumentCategory,
_PurgDocumentItemCategory,
_ProductCategory,
_IncotermsClassification,
_PurchasingDocument,
// _ServicePackage,
// _AccountAssignment,
_ScheduleLine,
// _PurchaseContractItem,
_PurchaseRequisitionItem,
_PurchasingInfoRecord,
_Manufacturer,
_Customer,
_Subcontractor,
_PriorSupplier,
_PurchaseRequisition,
_PurchaseContract,
_PurchaseContractItem,
_ServicePerformer,
_ProductType,
_AccountAssignmentCategory,
_ConsumptionPosting,
_AllocationTable,
_AllocationTableItem,
_RetailPromotion,
// Brazilian fields
_BR_MaterialOrigin,
_BR_MaterialUsage,
_BR_CFOPCategory,
_BR_NCM
}