I_PURREQNSSPITEM
Purchase Requisition Item
I_PURREQNSSPITEM is a CDS View in S/4HANA. Purchase Requisition Item. It contains 139 fields. 2 CDS views read from this table.
CDS Views using this table (2)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_OpnCtlgItmPrpslForPurReqn | view | from | COMPOSITE | Open Catalog Item Proposal For PR |
| P_Purrequisitionitem | view | from | COMPOSITE |
Fields (139)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | PurchaseReqnItemUniqueID | PurchaseReqnItemUniqueID | 2 |
| KEY | PurchaseRequisition | PurchaseRequisition | 2 |
| KEY | PurchaseRequisitionItem | PurchaseRequisitionItem | 2 |
| _AccAssgnmtCategory | _AccAssgnmtCategory | 1 | |
| _Address | _Address | 1 | |
| _CalcFields | _CalcFields | 1 | |
| _Currency | _Currency | 1 | |
| _CurrentDfltEmailAddress | _CurrentDfltEmailAddress | 1 | |
| _CurrentDfltFaxNumber | _CurrentDfltFaxNumber | 1 | |
| _Material | _Material | 1 | |
| _MaterialGroup | _MaterialGroup | 1 | |
| _PhoneNumber | _PhoneNumber | 1 | |
| _Plant | _Plant | 1 | |
| _PurchaseOrder | _PurchaseOrder | 1 | |
| _PurchaseRequisition | _PurchaseRequisition | 1 | |
| _PurchasingDocumentType | _PurchasingDocumentType | 1 | |
| _PurchasingGroup | _PurchasingGroup | 1 | |
| _PurchasingInfoRecord | _PurchasingInfoRecord | 1 | |
| _PurchasingOrganization | _PurchasingOrganization | 1 | |
| _PurReqnAcctAssgmt | _PurReqnAcctAssgmt | 1 | |
| _StorageLocation | _StorageLocation | 1 | |
| _Supplier | _Supplier | 1 | |
| _SupplyingPlant | _SupplyingPlant | 1 | |
| _UnitOfMeasure | _UnitOfMeasure | 1 | |
| AccountAssignmentCategory | AccountAssignmentCategory | 1 | |
| BaseUnit | BaseUnit | 1 | |
| Batch | Batch | 1 | |
| BudgetPeriod | BudgetPeriod | 1 | |
| BusinessUser | BusinessUser | 1 | |
| CntrlReqnIsRpldBfrApprvl | CntrlReqnIsRpldBfrApprvl | 1 | |
| CompanyCode | CompanyCode | 1 | |
| ConsumptionPosting | ConsumptionPosting | 1 | |
| CostCenter | CostCenter | 1 | |
| CreatedByUser | CreatedByUser | 1 | |
| CreationDate | CreationDate | 1 | |
| DelivDateCategory | DelivDateCategory | 1 | |
| DeliveryAddressID | DeliveryAddressID | 1 | |
| DeliveryDate | DeliveryDate | 1 | |
| EarmarkedFundsDocument | EarmarkedFundsDocument | 1 | |
| EarmarkedFundsDocumentItem | EarmarkedFundsDocumentItem | 1 | |
| ExpectedOverallLimitAmount | ExpectedOverallLimitAmount | 1 | |
| ExtCompanyCodeForPurg | ExtCompanyCodeForPurg | 1 | |
| ExtContractForOverallLimit | ExtContractForOverallLimit | 1 | |
| ExtContractForPurg | ExtContractForPurg | 1 | |
| ExtContractItemForOverallLimit | ExtContractItemForOverallLimit | 1 | |
| ExtContractItemForPurg | ExtContractItemForPurg | 1 | |
| ExtDesiredSupplierForPurg | ExtDesiredSupplierForPurg | 1 | |
| ExternalApprovalStatus | ExternalApprovalStatus | 1 | |
| ExtFixedSupplierForPurg | ExtFixedSupplierForPurg | 1 | |
| ExtInfoRecordForPurg | ExtInfoRecordForPurg | 1 | |
| ExtMaterialForPurg | ExtMaterialForPurg | 1 | |
| ExtPlantForPurg | ExtPlantForPurg | 1 | |
| ExtPurchaseRequisitionType | ExtPurchaseRequisitionType | 1 | |
| ExtPurgOrgForPurg | ExtPurgOrgForPurg | 1 | |
| ExtSourceSystem | ExtSourceSystem | 1 | |
| FixedSupplier | FixedSupplier | 1 | |
| FunctionalArea | FunctionalArea | 1 | |
| Fund | Fund | 1 | |
| FundedProgram | FundedProgram | 1 | |
| FundsCenter | FundsCenter | 1 | |
| GLAccount | GLAccount | 1 | |
| GoodsReceiptIsExpected | GoodsReceiptIsExpected | 1 | |
| GoodsReceiptIsNonValuated | GoodsReceiptIsNonValuated | 1 | |
| GrantID | GrantID | 1 | |
| InvoiceIsExpected | InvoiceIsExpected | 1 | |
| IsClosed | IsClosed | 1 | |
| IsDeleted | IsDeleted | 1 | |
| IsPurReqnBlocked | IsPurReqnBlocked | 1 | |
| IsPurReqnCmplt | IsPurReqnCmplt | 1 | |
| ItemDeliveryAddressID | ItemDeliveryAddressID | 1 | |
| ItemNetAmount | ItemNetAmount | 1 | |
| Language | Language | 1 | |
| ManualDeliveryAddressID | ManualDeliveryAddressID | 1 | |
| Manufacturer | Manufacturer | 1 | |
| ManufacturerMaterial | ManufacturerMaterial | 1 | |
| ManufacturerPartNmbr | ManufacturerPartNmbr | 1 | |
| Material | Material | 1 | |
| MaterialGoodsReceiptDuration | MaterialGoodsReceiptDuration | 1 | |
| MaterialGroup | MaterialGroup | 1 | |
| MaterialPlannedDeliveryDurn | MaterialPlannedDeliveryDurn | 1 | |
| MaterialRevisionLevel | MaterialRevisionLevel | 1 | |
| MinRemainingShelfLife | MinRemainingShelfLife | 1 | |
| MRPController | MRPController | 1 | |
| MultipleAcctAssgmtDistribution | MultipleAcctAssgmtDistribution | 1 | |
| OpnCtlgItemPrpslID | OpnCtlgItemPrpslID | 1 | |
| OrderedQuantity | OrderedQuantity | 1 | |
| OverallLimitAmount | OverallLimitAmount | 1 | |
| PerformancePeriodEndDate | PerformancePeriodEndDate | 1 | |
| PerformancePeriodStartDate | PerformancePeriodStartDate | 1 | |
| Plant | Plant | 1 | |
| PlantAddressID | PlantAddressID | 1 | |
| ProcessingStatus | ProcessingStatus | 1 | |
| ProcmtHubRefDeliveryAddressID | ProcmtHubRefDeliveryAddressID | 1 | |
| ProcmtHubStorageLocation | ProcmtHubStorageLocation | 1 | |
| ProcurementHubSourceSystem | ProcurementHubSourceSystem | 1 | |
| ProductType | ProductType | 1 | |
| PurchaseContract | PurchaseContract | 1 | |
| PurchaseContractItem | PurchaseContractItem | 1 | |
| PurchaseOrderPriceType | PurchaseOrderPriceType | 1 | |
| PurchaseRequisitionIsFixed | PurchaseRequisitionIsFixed | 1 | |
| PurchaseRequisitionItemText | PurchaseRequisitionItemText | 1 | |
| PurchaseRequisitionPrice | PurchaseRequisitionPrice | 1 | |
| PurchaseRequisitionReleaseDate | PurchaseRequisitionReleaseDate | 1 | |
| PurchaseRequisitionStatus | PurchaseRequisitionStatus | 1 | |
| PurchaseRequisitionType | PurchaseRequisitionType | 1 | |
| PurchasingDocument | PurchasingDocument | 1 | |
| PurchasingDocumentCategory | PurchasingDocumentCategory | 1 | |
| PurchasingDocumentItem | PurchasingDocumentItem | 1 | |
| PurchasingDocumentItemCategory | PurchasingDocumentItemCategory | 1 | |
| PurchasingGroup | PurchasingGroup | 1 | |
| PurchasingInfoRecord | PurchasingInfoRecord | 1 | |
| PurchasingOrganization | PurchasingOrganization | 1 | |
| PurReqCreationDate | PurReqCreationDate | 1 | |
| PurReqnCmpltnsCat | PurReqnCmpltnsCat | 1 | |
| PurReqnIsValdInCntrlReqnProcg | PurReqnIsValdInCntrlReqnProcg | 1 | |
| PurReqnItemCurrency | PurReqnItemCurrency | 1 | |
| PurReqnOrigin | PurReqnOrigin | 1 | |
| PurReqnPriceQuantity | PurReqnPriceQuantity | 1 | |
| PurReqnReleaseStatus | PurReqnReleaseStatus | 1 | |
| PurReqnSourceOfSupplyType | PurReqnSourceOfSupplyType | 1 | |
| PurReqnSSPAuthor | PurReqnSSPAuthor | 1 | |
| PurReqnSSPCatalog | PurReqnSSPCatalog | 1 | |
| PurReqnSSPCatalogItem | PurReqnSSPCatalogItem | 1 | |
| PurReqnSSPCrossCatalogItem | PurReqnSSPCrossCatalogItem | 1 | |
| PurReqnSSPRequestor | PurReqnSSPRequestor | 1 | |
| ReleaseCode | ReleaseCode | 1 | |
| ReleaseIsNotCompleted | ReleaseIsNotCompleted | 1 | |
| ReleaseStrategy | ReleaseStrategy | 1 | |
| RequestedQuantity | RequestedQuantity | 1 | |
| RequirementTracking | RequirementTracking | 1 | |
| RequisitionerName | RequisitionerName | 1 | |
| Reservation | Reservation | 1 | |
| ServicePerformer | ServicePerformer | 1 | |
| SourceOfSupplyIsAssigned | SourceOfSupplyIsAssigned | 1 | |
| StorageLocation | StorageLocation | 1 | |
| Supplier | Supplier | 1 | |
| SupplierMaterialNumber | SupplierMaterialNumber | 1 | |
| SupplyingPlant | SupplyingPlant | 1 | |
| TaxCode | TaxCode | 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.
-- Purchase Requisition Item
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_PURREQNSSPITEM (
PURCHASEREQNITEMUNIQUEID,
PURCHASEREQUISITION,
PURCHASEREQUISITIONITEM,
_ACCASSGNMTCATEGORY,
_ADDRESS,
_CALCFIELDS,
_CURRENCY,
_CURRENTDFLTEMAILADDRESS,
_CURRENTDFLTFAXNUMBER,
_MATERIAL,
_MATERIALGROUP,
_PHONENUMBER,
_PLANT,
_PURCHASEORDER,
_PURCHASEREQUISITION,
_PURCHASINGDOCUMENTTYPE,
_PURCHASINGGROUP,
_PURCHASINGINFORECORD,
_PURCHASINGORGANIZATION,
_PURREQNACCTASSGMT,
_STORAGELOCATION,
_SUPPLIER,
_SUPPLYINGPLANT,
_UNITOFMEASURE,
ACCOUNTASSIGNMENTCATEGORY,
BASEUNIT,
BATCH,
BUDGETPERIOD,
BUSINESSUSER,
CNTRLREQNISRPLDBFRAPPRVL,
COMPANYCODE,
CONSUMPTIONPOSTING,
COSTCENTER,
CREATEDBYUSER,
CREATIONDATE,
DELIVDATECATEGORY,
DELIVERYADDRESSID,
DELIVERYDATE,
EARMARKEDFUNDSDOCUMENT,
EARMARKEDFUNDSDOCUMENTITEM,
EXPECTEDOVERALLLIMITAMOUNT,
EXTCOMPANYCODEFORPURG,
EXTCONTRACTFOROVERALLLIMIT,
EXTCONTRACTFORPURG,
EXTCONTRACTITEMFOROVERALLLIMIT,
EXTCONTRACTITEMFORPURG,
EXTDESIREDSUPPLIERFORPURG,
EXTERNALAPPROVALSTATUS,
EXTFIXEDSUPPLIERFORPURG,
EXTINFORECORDFORPURG,
EXTMATERIALFORPURG,
EXTPLANTFORPURG,
EXTPURCHASEREQUISITIONTYPE,
EXTPURGORGFORPURG,
EXTSOURCESYSTEM,
FIXEDSUPPLIER,
FUNCTIONALAREA,
FUND,
FUNDEDPROGRAM,
FUNDSCENTER,
GLACCOUNT,
GOODSRECEIPTISEXPECTED,
GOODSRECEIPTISNONVALUATED,
GRANTID,
INVOICEISEXPECTED,
ISCLOSED,
ISDELETED,
ISPURREQNBLOCKED,
ISPURREQNCMPLT,
ITEMDELIVERYADDRESSID,
ITEMNETAMOUNT,
LANGUAGE,
MANUALDELIVERYADDRESSID,
MANUFACTURER,
MANUFACTURERMATERIAL,
MANUFACTURERPARTNMBR,
MATERIAL,
MATERIALGOODSRECEIPTDURATION,
MATERIALGROUP,
MATERIALPLANNEDDELIVERYDURN,
MATERIALREVISIONLEVEL,
MINREMAININGSHELFLIFE,
MRPCONTROLLER,
MULTIPLEACCTASSGMTDISTRIBUTION,
OPNCTLGITEMPRPSLID,
ORDEREDQUANTITY,
OVERALLLIMITAMOUNT,
PERFORMANCEPERIODENDDATE,
PERFORMANCEPERIODSTARTDATE,
PLANT,
PLANTADDRESSID,
PROCESSINGSTATUS,
PROCMTHUBREFDELIVERYADDRESSID,
PROCMTHUBSTORAGELOCATION,
PROCUREMENTHUBSOURCESYSTEM,
PRODUCTTYPE,
PURCHASECONTRACT,
PURCHASECONTRACTITEM,
PURCHASEORDERPRICETYPE,
PURCHASEREQUISITIONISFIXED,
PURCHASEREQUISITIONITEMTEXT,
PURCHASEREQUISITIONPRICE,
PURCHASEREQUISITIONRELEASEDATE,
PURCHASEREQUISITIONSTATUS,
PURCHASEREQUISITIONTYPE,
PURCHASINGDOCUMENT,
PURCHASINGDOCUMENTCATEGORY,
PURCHASINGDOCUMENTITEM,
PURCHASINGDOCUMENTITEMCATEGORY,
PURCHASINGGROUP,
PURCHASINGINFORECORD,
PURCHASINGORGANIZATION,
PURREQCREATIONDATE,
PURREQNCMPLTNSCAT,
PURREQNISVALDINCNTRLREQNPROCG,
PURREQNITEMCURRENCY,
PURREQNORIGIN,
PURREQNPRICEQUANTITY,
PURREQNRELEASESTATUS,
PURREQNSOURCEOFSUPPLYTYPE,
PURREQNSSPAUTHOR,
PURREQNSSPCATALOG,
PURREQNSSPCATALOGITEM,
PURREQNSSPCROSSCATALOGITEM,
PURREQNSSPREQUESTOR,
RELEASECODE,
RELEASEISNOTCOMPLETED,
RELEASESTRATEGY,
REQUESTEDQUANTITY,
REQUIREMENTTRACKING,
REQUISITIONERNAME,
RESERVATION,
SERVICEPERFORMER,
SOURCEOFSUPPLYISASSIGNED,
STORAGELOCATION,
SUPPLIER,
SUPPLIERMATERIALNUMBER,
SUPPLYINGPLANT,
TAXCODE,
PRIMARY KEY (PURCHASEREQNITEMUNIQUEID, PURCHASEREQUISITION, PURCHASEREQUISITIONITEM)
);Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- 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