C_Sspprmaint_Itm

Column Name Description
PurchaseRequisition Purchase requisition number
PurchaseRequisitionItem Item number of purchase requisition
Column Name Description
💲 Currency Key (Currency):
PurchaseRequisitionPrice Price in Purchase Requisition
TotalNetAmount null
ExpectedOverallLimitAmount Expected Value of Overall Limit
OverallLimitAmount Overall Limit
Column Name Description
📏 Purchase requisition unit of measure (BaseUnit):
RequestedQuantity Purchase requisition quantity
Column Name Description
DeliveryDate Item delivery date
PerformancePeriodStartDate Start Date for Period of Performance
PerformancePeriodEndDate End Date for Period of Performance
Column Name Description
SSPPurReqnItmIsInComposing SSP PR Item in Composing State Show values
PurReqnReleaseStatus Requisition Processing State Show values
PurReqnRejectionIsCancelled Cancellation Indicator for Rejected PR Show values
AddressType Purchase Requisition Address Type Show values
MultipleAcctAssgmtDistribution Distribution Indicator for Multiple Account Assignment Show values
ProcessingStatus Processing status of purchase requisition Show values
ExternalApprovalStatus External Processing Status Show values
FundMgmtIsActive Truth Value: True/False Show values
PurReqnIsApplicableForRework PR Rework Indicator Show values
Column Name Description Domain name
NetPriceQuantity Price unit
PurchaseRequisitionItemText Short Text TEXT40
PurReqnSSPCatalog Technical Key of a Web Service (for Example - a Catalog) BBP_WS_SERVICE_ID
PurReqnSSPCatalogItem Catalog Item
PurReqnSSPCrossCatalogItem Catalog Item Key
IsDeleted Deletion Indicator in Purchasing Document ELOEK
PurReqnItemLifeCycleStatus null
OpnCtlgMainImageURL Catalog Main Image URL
OpnCtlgHasPriceScale If price scale exist CHAR1
FullName Full name of a party (Bus. Partner, Org. Unit, Doc. address) TEXT80
CareOfName c/o name TEXT40
AddressStreetName Street TEXT60
AddressHouseNumber House Number TEXT10
AddressPostalCode City postal code CHAR10
AddressCityName City TEXT40
PhoneNumber1 Telephone no.: dialling code+number CHAR30
FaxNumber First Fax No.: Area Code + Number CHAR30
EmailAddress E-Mail Address AD_SMTPADR
PurReqnSSPAuthor Author of Requisition UNAME
PurReqnSSPRequestor Requestor
ProductType Product Type Group CHAR2
ServicePerformer Service Performer BU_PARTNER
ExtMaterialForPurg Material of External System MATNR
ExtFixedSupplierForPurg Fixed Supplier of External System LIFNR
ExtDesiredSupplierForPurg Desired Supplier of External System LIFNR
ExtContractForPurg Contract of External System EBELN
ExtContractItemForPurg Contract Item of External System EBELP
ExtInfoRecordForPurg Info Record of External System INFNR
ExtPlantForPurg Plant of External System WERKS
ExtCompanyCodeForPurg Company Code of External System BUKRS
ExtPurgOrgForPurg Purchasing Organization EKORG
ExtSourceSystem Logical System LOGSYS
ExtPurchaseRequisitionType PR Document Type of Connected System
ProcurementHubSourceSystem Connected System ID
SupplierMaterialNumber Material Number Used by Supplier
CommitmentItem Commitment Item FIPOS
FundsCenter Funds Center FISTL
Fund Fund BP_GEBER
GrantID Grant GM_GRANT_NBR
FunctionalArea Functional Area FKBER
EarmarkedFundsDocument Document Number for Earmarked Funds KBLNR
EarmarkedFundsDocumentItem Earmarked Funds: Document Item
BudgetPeriod Budget Period FM_BUDGET_PERIOD
FundedProgram null
CostCenter Cost Center KOSTL
WBSElement Work Breakdown Structure Element (WBS Element) PS_POSNR
GLAccount G/L Account Number SAKNR
PurReqnLifeCycleStatusName Short Text for Fixed Values DDTEXT
SourcePurchaseRequisition Source Purchase Requisition BANFN
SourcePurchaseRequisitionItem Source Purchase Requisition Item BNFPO
ProcmtHubPlantName Plant Name TEXT30
ProcmtHubCompanyCodeName Name of Company Code or Company TEXT25
ProcmtHubPurgOrgName Connected Purchasing Organisation Name
SupplierName Name of Supplier TEXT80
PurReqnApproverCommentText Note Text
PurReqnReworkCommentText Note Text
Master Data Relations Join Conditions
Account Assignment Category
  • Account Assignment Category
  • Client
  • C_SSPPRMAINT_ITM.ACCOUNTASSIGNMENTCATEGORY == T163K.KNTTP
  • C_SSPPRMAINT_ITM.MANDT == T163K.MANDT
Country key
  • Client
  • Country/Region Key
  • C_SSPPRMAINT_ITM.MANDT == T005.MANDT
  • C_SSPPRMAINT_ITM.ADDRESSCOUNTRY == T005.LAND1
Region code
  • Client
  • Region (State, Province, County)
  • Country/Region Key
  • C_SSPPRMAINT_ITM.MANDT == T005S.MANDT
  • C_SSPPRMAINT_ITM.ADDRESSREGION == T005S.BLAND
  • C_SSPPRMAINT_ITM.ADDRESSCOUNTRY == T005S.LAND1
Purchase requisition unit of measure
  • Purchase requisition unit of measure
  • Client
  • C_SSPPRMAINT_ITM.BASEUNIT == T006.MSEHI
  • C_SSPPRMAINT_ITM.MANDT == T006.MANDT
Address key assignment to users
  • User ID
  • Client
  • C_SSPPRMAINT_ITM.BUSINESSUSER == USR02.BNAME
  • C_SSPPRMAINT_ITM.MANDT == USR02.MANDT
Company code
  • Company Code
  • Client
  • C_SSPPRMAINT_ITM.COMPANYCODE == T001.BUKRS
  • C_SSPPRMAINT_ITM.MANDT == T001.MANDT
Currency Key
  • Client
  • Currency Key
  • C_SSPPRMAINT_ITM.MANDT == TCURC.MANDT
  • C_SSPPRMAINT_ITM.CURRENCY == TCURC.WAERS
Fixed Vendor
  • Client
  • Fixed Vendor
  • C_SSPPRMAINT_ITM.MANDT == LFA1.MANDT
  • C_SSPPRMAINT_ITM.FIXEDSUPPLIER == LFA1.LIFNR
Form-of-Address Key
  • Client
  • Form-of-Address Key
  • C_SSPPRMAINT_ITM.MANDT == TSAD3.CLIENT
  • C_SSPPRMAINT_ITM.FORMOFADDRESS == TSAD3.TITLE
Language Key C_SSPPRMAINT_ITM.LANGUAGE == T002.SPRAS
Link to Central Address Management
  • ?
  • ?
  • Manual address number in purchasing document item
  • Client
  • C_SSPPRMAINT_ITM.[column in domain "AD_NATION"] == ADRC.NATION
  • C_SSPPRMAINT_ITM.[column in domain "AD_DATE_FR"] == ADRC.DATE_FROM
  • C_SSPPRMAINT_ITM.MANUALDELIVERYADDRESSID == ADRC.ADDRNUMBER
  • C_SSPPRMAINT_ITM.MANDT == ADRC.CLIENT
Material Number
  • Material Number
  • Client
  • C_SSPPRMAINT_ITM.MATERIAL == MARA.MATNR
  • C_SSPPRMAINT_ITM.MANDT == MARA.MANDT
Material Group
  • Material Group
  • Client
  • C_SSPPRMAINT_ITM.MATERIALGROUP == T023.MATKL
  • C_SSPPRMAINT_ITM.MANDT == T023.MANDT
Plant
  • Client
  • Plant
  • C_SSPPRMAINT_ITM.MANDT == T001W.MANDT
  • C_SSPPRMAINT_ITM.PLANT == T001W.WERKS
Purchase Requisition Document Type
  • ?
  • Purchase Requisition Document Type
  • Client
  • C_SSPPRMAINT_ITM.[column in domain "BSTYP"] == T161.BSTYP
  • C_SSPPRMAINT_ITM.PURCHASEREQUISITIONTYPE == T161.BSART
  • C_SSPPRMAINT_ITM.MANDT == T161.MANDT
Item category in purchasing document
  • Item category in purchasing document
  • Client
  • C_SSPPRMAINT_ITM.PURCHASINGDOCUMENTITEMCATEGORY == T163.PSTYP
  • C_SSPPRMAINT_ITM.MANDT == T163.MANDT
Purchasing Group
  • Purchasing Group
  • Client
  • C_SSPPRMAINT_ITM.PURCHASINGGROUP == T024.EKGRP
  • C_SSPPRMAINT_ITM.MANDT == T024.MANDT
Number of purchasing info record
  • Number of purchasing info record
  • Client
  • C_SSPPRMAINT_ITM.PURCHASINGINFORECORD == EINA.INFNR
  • C_SSPPRMAINT_ITM.MANDT == EINA.MANDT
Purchasing organization
  • Purchasing organization
  • Client
  • C_SSPPRMAINT_ITM.PURCHASINGORGANIZATION == T024E.EKORG
  • C_SSPPRMAINT_ITM.MANDT == T024E.MANDT
Desired Vendor
  • Client
  • Desired Vendor
  • C_SSPPRMAINT_ITM.MANDT == LFA1.MANDT
  • C_SSPPRMAINT_ITM.SUPPLIER == LFA1.LIFNR