C_GuidedProcmtReqnItemTP

Item CDS view for guided buying | view: CGBPRMAINTITM | Extraction: Not supported | Component: OneProcurement Shopping Experience
Tables used: MMPUR_CAT_ATMAIN, MMDOC_EXT_LINKS, EBAN_TECH, FMIOI, OCIITM_PROPS, MMPUR_CAT_LNGTXT, MMPUR_CAT_MGPTXT, MMPUR_CAT_PRCONV, EBAN, MMPUR_CAT_ATHTXT, MMPUR_CAT_ATTCHM, MMPUR_REQ_REWORK, ADCP, ADRC, ADR6, ADR2, MMPUR_CAT_ITM, USR21, T001, TKA02, FM01, T001W, T001K, LFA1, ADRP, BUT000, BUT0ID, TB039A, TB003, BUT100, MMPUR_C_BE_CCREG, MMPUR_C_BE_PLREG, MMPUR_C_BE_SYREG, MMPUR_CAT_CRCUST, MMPUR_C_BE_PORGR, BPU_ROLECAT_WHL, FINSC_FISC_DATE
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
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
AddressType Purchase Requisition Address Type Show values
SSPPurReqnItmIsInComposing SSP PR Item in Composing State 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
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 Communication System ID
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
DeliveryDurationInDays Delivery time in days DEC3
DeliveryTime Delivery time in days DEC3
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
Master Data Relations Join Conditions
Account Assignment Category
  • Client
  • Account Assignment Category
  • C_GUIDEDPROCMTREQNITEMTP.MANDT == T163K.MANDT
  • C_GUIDEDPROCMTREQNITEMTP.ACCOUNTASSIGNMENTCATEGORY == T163K.KNTTP
Country key
  • Client
  • Country/Region Key
  • C_GUIDEDPROCMTREQNITEMTP.MANDT == T005.MANDT
  • C_GUIDEDPROCMTREQNITEMTP.ADDRESSCOUNTRY == T005.LAND1
Region code
  • Client
  • Country/Region Key
  • Region (State, Province, County)
  • C_GUIDEDPROCMTREQNITEMTP.MANDT == T005S.MANDT
  • C_GUIDEDPROCMTREQNITEMTP.ADDRESSCOUNTRY == T005S.LAND1
  • C_GUIDEDPROCMTREQNITEMTP.ADDRESSREGION == T005S.BLAND
Purchase requisition unit of measure
  • Client
  • Purchase requisition unit of measure
  • C_GUIDEDPROCMTREQNITEMTP.MANDT == T006.MANDT
  • C_GUIDEDPROCMTREQNITEMTP.BASEUNIT == T006.MSEHI
Address key assignment to users
  • Client
  • User ID
  • C_GUIDEDPROCMTREQNITEMTP.MANDT == USR02.MANDT
  • C_GUIDEDPROCMTREQNITEMTP.BUSINESSUSER == USR02.BNAME
Company code
  • Client
  • Company Code
  • C_GUIDEDPROCMTREQNITEMTP.MANDT == T001.MANDT
  • C_GUIDEDPROCMTREQNITEMTP.COMPANYCODE == T001.BUKRS
Currency Key
  • Client
  • Currency Key
  • C_GUIDEDPROCMTREQNITEMTP.MANDT == TCURC.MANDT
  • C_GUIDEDPROCMTREQNITEMTP.CURRENCY == TCURC.WAERS
Fixed Vendor
  • Fixed Vendor
  • Client
  • C_GUIDEDPROCMTREQNITEMTP.FIXEDSUPPLIER == LFA1.LIFNR
  • C_GUIDEDPROCMTREQNITEMTP.MANDT == LFA1.MANDT
Form-of-Address Key
  • Client
  • Form-of-Address Key
  • C_GUIDEDPROCMTREQNITEMTP.MANDT == TSAD3.CLIENT
  • C_GUIDEDPROCMTREQNITEMTP.FORMOFADDRESS == TSAD3.TITLE
Language Key C_GUIDEDPROCMTREQNITEMTP.LANGUAGE == T002.SPRAS
Link to Central Address Management
  • Manual address number in purchasing document item
  • Client
  • ?
  • ?
  • C_GUIDEDPROCMTREQNITEMTP.MANUALDELIVERYADDRESSID == ADRC.ADDRNUMBER
  • C_GUIDEDPROCMTREQNITEMTP.MANDT == ADRC.CLIENT
  • C_GUIDEDPROCMTREQNITEMTP.[column in domain "AD_NATION"] == ADRC.NATION
  • C_GUIDEDPROCMTREQNITEMTP.[column in domain "AD_DATE_FR"] == ADRC.DATE_FROM
Material Number
  • Client
  • Material Number
  • C_GUIDEDPROCMTREQNITEMTP.MANDT == MARA.MANDT
  • C_GUIDEDPROCMTREQNITEMTP.MATERIAL == MARA.MATNR
Material Group
  • Client
  • Material Group
  • C_GUIDEDPROCMTREQNITEMTP.MANDT == T023.MANDT
  • C_GUIDEDPROCMTREQNITEMTP.MATERIALGROUP == T023.MATKL
Plant
  • Client
  • Plant
  • C_GUIDEDPROCMTREQNITEMTP.MANDT == T001W.MANDT
  • C_GUIDEDPROCMTREQNITEMTP.PLANT == T001W.WERKS
Purchase Requisition Document Type
  • Purchase Requisition Document Type
  • ?
  • Client
  • C_GUIDEDPROCMTREQNITEMTP.PURCHASEREQUISITIONTYPE == T161.BSART
  • C_GUIDEDPROCMTREQNITEMTP.[column in domain "BSTYP"] == T161.BSTYP
  • C_GUIDEDPROCMTREQNITEMTP.MANDT == T161.MANDT
Item category in purchasing document
  • Client
  • Item category in purchasing document
  • C_GUIDEDPROCMTREQNITEMTP.MANDT == T163.MANDT
  • C_GUIDEDPROCMTREQNITEMTP.PURCHASINGDOCUMENTITEMCATEGORY == T163.PSTYP
Purchasing Group
  • Client
  • Purchasing Group
  • C_GUIDEDPROCMTREQNITEMTP.MANDT == T024.MANDT
  • C_GUIDEDPROCMTREQNITEMTP.PURCHASINGGROUP == T024.EKGRP
Number of purchasing info record
  • Client
  • Number of purchasing info record
  • C_GUIDEDPROCMTREQNITEMTP.MANDT == EINA.MANDT
  • C_GUIDEDPROCMTREQNITEMTP.PURCHASINGINFORECORD == EINA.INFNR
Purchasing organization
  • Client
  • Purchasing organization
  • C_GUIDEDPROCMTREQNITEMTP.MANDT == T024E.MANDT
  • C_GUIDEDPROCMTREQNITEMTP.PURCHASINGORGANIZATION == T024E.EKORG
Desired Vendor
  • Client
  • Desired Vendor
  • C_GUIDEDPROCMTREQNITEMTP.MANDT == LFA1.MANDT
  • C_GUIDEDPROCMTREQNITEMTP.SUPPLIER == LFA1.LIFNR