N_PurReqnAcctAssgmt

Auxiliary view for PR Account Assignment | view: NPRACCTASSGMT | TRAN | Extraction: Not supported | Component: Purchase Requisitions
Tables used: AFKO, PRTE, EBKN, TGSBT, TKA01, CSKS, CSKT, AUFK, CEPC, CEPCT, PROJ, PROJ, CNLDST_SHORTTX, T000, PRPS
Column Name Description
PurchaseRequisition Purchase Requisition Number
PurchaseRequisitionItem FK Item number of purchase requisition
PurchaseReqnAcctAssgmtNumber Serial number for PReq account assignment segment
Column Name Description
PurReqnNetAmount Net Order Value in PO Currency
Column Name Description
Quantity Purchase requisition quantity
Column Name Description
CostCenterValidToDate Valid To Date
PrftCtrValidToDate Valid To Date
CreationDate Date on which the record was created
SettlementReferenceDate Reference date for settlement
ValidityDate null
Column Name Description
Column Name Description Domain name
CostCenterName Cost Center Name TEXT20
MultipleAcctAssgmtDistrPercent Distribution percentage in the case of multiple acct assgt VPROZ
IsDeleted Deletion Indicator in Purchasing Document ELOEK
BusinessAreaName Business Area Description TEXT30
SDDocument Sales and Distribution Document Number VBELN
SalesOrder Sales and Distribution Document Number VBELN
SalesDocumentItem Sales Document Item POSNR
SalesOrderItem Sales Document Item POSNR
UnloadingPointName Unloading Point TEXT25
ControllingAreaName Controlling Area Name TEXT25
CostObject Cost Object KSTRG
ProfitabilitySegment Profitability Segment Number (CO-PA) RKEOBJNR
ProfitCenter Profit Center PRCTR
ProfitCenterName Description of Profit Center TEXT20
ProjectNetworkInternalID Routing number of operations in the order AUFPL
ProjectNetworkDescription Description TEXT40
FundsCenter Funds Center FISTL
Fund Fund BP_GEBER
FunctionalArea Functional Area FKBER
GoodsRecipientName Goods Recipient WEMPF
RealEstateObject Internal Key for Real Estate Object IMKEY
NetworkActivityInternalID Internal counter CIM_COUNT
JointVentureRecoveryCode Recovery Indicator JV_RECIND
OrderInternalID Routing number of operations in the order AUFPL
OrderIntBillOfOperationsItem General counter for order CO_APLZL
EarmarkedFundsDocument Document Number for Earmarked Funds KBLNR
EarmarkedFundsDocumentItem Earmarked Funds: Document Item KBLPOS
GrantID Grant GM_GRANT_NBR
BudgetPeriod Budget Period FM_BUDGET_PERIOD
EarmarkedFundsItem Earmarked Funds: Document Item KBLPOS
ProjectDescription Project Definition Name TEXT40
Master Data Relations Join Conditions
Business Area
  • Business Area
  • Client
  • N_PURREQNACCTASSGMT.BUSINESSAREA == TGSB.GSBER
  • N_PURREQNACCTASSGMT.MANDT == TGSB.MANDT
Business Process
  • ?
  • Controlling Area
  • Client
  • Business Process
  • N_PURREQNACCTASSGMT.[column in domain "DATBI"] == CBPR.DATBI
  • N_PURREQNACCTASSGMT.CONTROLLINGAREA == CBPR.KOKRS
  • N_PURREQNACCTASSGMT.MANDT == CBPR.MANDT
  • N_PURREQNACCTASSGMT.BUSINESSPROCESS == CBPR.PRZNR
Chart of Accounts
  • Chart of Accounts
  • Client
  • N_PURREQNACCTASSGMT.CHARTOFACCOUNTS == T004.KTOPL
  • N_PURREQNACCTASSGMT.MANDT == T004.MANDT
Commitment Item
  • Commitment Item
  • Date on which the record was created
  • ?
  • Client
  • N_PURREQNACCTASSGMT.COMMITMENTITEM == FMFPO.FIPOS
  • N_PURREQNACCTASSGMT.CREATIONDATE == FMFPO.DATBIS
  • N_PURREQNACCTASSGMT.[column in domain "FIKRS"] == FMFPO.FIKRS
  • N_PURREQNACCTASSGMT.MANDT == FMFPO.MANDT
Controlling Area
  • Controlling Area
  • Client
  • N_PURREQNACCTASSGMT.CONTROLLINGAREA == TKA01.KOKRS
  • N_PURREQNACCTASSGMT.MANDT == TKA01.MANDT
Cost Center
  • Controlling Area
  • Date on which the record was created
  • Cost Center
  • Client
  • N_PURREQNACCTASSGMT.CONTROLLINGAREA == CSKS.KOKRS
  • N_PURREQNACCTASSGMT.CREATIONDATE == CSKS.DATBI
  • N_PURREQNACCTASSGMT.COSTCENTER == CSKS.KOSTL
  • N_PURREQNACCTASSGMT.MANDT == CSKS.MANDT
Activity Type
  • Activity Type
  • ?
  • Controlling Area
  • Client
  • N_PURREQNACCTASSGMT.COSTCTRACTIVITYTYPE == CSLA.LSTAR
  • N_PURREQNACCTASSGMT.[column in domain "DATBI"] == CSLA.DATBI
  • N_PURREQNACCTASSGMT.CONTROLLINGAREA == CSLA.KOKRS
  • N_PURREQNACCTASSGMT.MANDT == CSLA.MANDT
G/L Account Number
  • Chart of Accounts
  • G/L Account Number
  • G/L Account Number
  • Client
  • N_PURREQNACCTASSGMT.CHARTOFACCOUNTS == SKA1.KTOPL
  • N_PURREQNACCTASSGMT.COSTELEMENT == SKA1.SAKNR
  • N_PURREQNACCTASSGMT.GLACCOUNT == SKA1.SAKNR
  • N_PURREQNACCTASSGMT.MANDT == SKA1.MANDT
Asset Subnumber
  • Main Asset Number
  • Asset Subnumber
  • ?
  • Client
  • N_PURREQNACCTASSGMT.MASTERFIXEDASSET == ANLA.ANLN1
  • N_PURREQNACCTASSGMT.FIXEDASSET == ANLA.ANLN2
  • N_PURREQNACCTASSGMT.[column in domain "BUKRS"] == ANLA.BUKRS
  • N_PURREQNACCTASSGMT.MANDT == ANLA.MANDT
G/L Account Number
  • Chart of Accounts
  • G/L Account Number
  • G/L Account Number
  • Client
  • N_PURREQNACCTASSGMT.CHARTOFACCOUNTS == SKA1.KTOPL
  • N_PURREQNACCTASSGMT.COSTELEMENT == SKA1.SAKNR
  • N_PURREQNACCTASSGMT.GLACCOUNT == SKA1.SAKNR
  • N_PURREQNACCTASSGMT.MANDT == SKA1.MANDT
Order Number
  • Order Number
  • Order Number
  • Client
  • N_PURREQNACCTASSGMT.PROCESSORDER == AUFK.AUFNR
  • N_PURREQNACCTASSGMT.ORDERID == AUFK.AUFNR
  • N_PURREQNACCTASSGMT.MANDT == AUFK.MANDT
Partner account number
  • Partner account number
  • Client
  • N_PURREQNACCTASSGMT.PARTNERACCOUNTNUMBER == KNA1.KUNNR
  • N_PURREQNACCTASSGMT.MANDT == KNA1.MANDT
Order Number
  • Order Number
  • Order Number
  • Client
  • N_PURREQNACCTASSGMT.PROCESSORDER == AUFK.AUFNR
  • N_PURREQNACCTASSGMT.ORDERID == AUFK.AUFNR
  • N_PURREQNACCTASSGMT.MANDT == AUFK.MANDT
Network Number for Account Assignment
  • Client
  • Network Number for Account Assignment
  • N_PURREQNACCTASSGMT.MANDT == AUFK.MANDT
  • N_PURREQNACCTASSGMT.PROJECTNETWORK == AUFK.AUFNR