C_Schedagrmtacct

Account Assignment Consumption view | view: CSCHAGRMTACCTWD | Extraction: Not supported | Component: Contract
Tables used: AFKO, AFVC, AFVU, AFVV, EKKO, EKPO, EKKN, JEST, PRTE, EKKO, EKPO, T001, TKA02, TKA01, AUFK, T430, T001W, PROJ, PROJ, CNLDST_SHORTTX, T161T, T024, T024E, T000, LFA1, USR21, PRPS, PRPS, CRHD
Column Name Description
SchedulingAgreement FK Purchasing Document Number
SchedulingAgreementItem FK Item Number of Purchasing Document
AccountAssignmentNumber Sequential Number of Account Assignment
Column Name Description
💲 Currency Key (DocumentCurrency):
PurgDocNetAmount Net Order Value in PO Currency
NonDeductibleInputTaxAmount Non-deductible input tax
Column Name Description
📏 Purchase Order Unit of Measure (OrderQuantityUnit):
Quantity Quantity
Column Name Description
SettlementReferenceDate Reference date for settlement
ValidityDate null
Column Name Description
IsDeleted Deletion Indicator: Purchasing Document Account Assignment Show values
IsFinallyInvoiced Final Invoice Indicator Show values
Column Name Description Domain name
NetworkActivity Activity Number VORNR
NetworkActivityDescription Operation short text TEXT40
MultipleAcctAssgmtDistrPercent Distribution percentage in the case of multiple acct assgt VPROZ
SalesOrder Sales and Distribution Document Number VBELN
SalesOrderItem Sales Document Item
OrderOperation Operation/Activity Number PS_S4_VORNR
UnloadingPointName Unloading Point TEXT25
CostObject Cost Object KSTRG
ProfitabilitySegment Profitability Segment Number (CO-PA) RKEOBJNR
ProfitCenter Profit Center PRCTR
WBSElementExternalID Work Breakdown Structure Element (WBS Element) Edited PS_POSID_EDIT
WBSDescription WBS Element Name TEXT40
ProjectNetworkInternalID Routing number of operations in the order
FundsCenter Funds Center FISTL
FunctionalArea Functional Area FKBER
GoodsRecipientName Goods Recipient WEMPF
RealEstateObject Internal Key for Real Estate Object IMKEY
NetworkActivityInternalID Internal counter
JointVentureRecoveryCode Recovery Indicator JV_RECIND
OrderInternalID Routing number of operations in the order
OrderIntBillOfOperationsItem General counter for order
TaxCode Tax on sales/purchases code MWSKZ
TaxJurisdiction Tax Jurisdiction TXJCD
GrantID Grant GM_GRANT_NBR
BudgetPeriod Budget Period FM_BUDGET_PERIOD
EarmarkedFundsDocument Document Number for Earmarked Funds KBLNR
Master Data Relations Join Conditions
Business Area
  • Client
  • Business Area
  • C_SCHEDAGRMTACCT.MANDT == TGSB.MANDT
  • C_SCHEDAGRMTACCT.BUSINESSAREA == TGSB.GSBER
Business Process
  • ?
  • Controlling Area
  • Client
  • Business Process
  • C_SCHEDAGRMTACCT.[column in domain "DATBI"] == CBPR.DATBI
  • C_SCHEDAGRMTACCT.CONTROLLINGAREA == CBPR.KOKRS
  • C_SCHEDAGRMTACCT.MANDT == CBPR.MANDT
  • C_SCHEDAGRMTACCT.BUSINESSPROCESS == CBPR.PRZNR
Commitment Item
  • Commitment Item
  • ?
  • Client
  • ?
  • C_SCHEDAGRMTACCT.COMMITMENTITEM == FMFPO.FIPOS
  • C_SCHEDAGRMTACCT.[column in domain "FIKRS"] == FMFPO.FIKRS
  • C_SCHEDAGRMTACCT.MANDT == FMFPO.MANDT
  • C_SCHEDAGRMTACCT.[column in domain "FM_DATBIS"] == FMFPO.DATBIS
Company Code
  • Client
  • Company Code
  • C_SCHEDAGRMTACCT.MANDT == T001.MANDT
  • C_SCHEDAGRMTACCT.COMPANYCODE == T001.BUKRS
Controlling Area
  • Controlling Area
  • Client
  • C_SCHEDAGRMTACCT.CONTROLLINGAREA == TKA01.KOKRS
  • C_SCHEDAGRMTACCT.MANDT == TKA01.MANDT
Cost Center
  • Controlling Area
  • Client
  • ?
  • Cost Center
  • C_SCHEDAGRMTACCT.CONTROLLINGAREA == CSKS.KOKRS
  • C_SCHEDAGRMTACCT.MANDT == CSKS.MANDT
  • C_SCHEDAGRMTACCT.[column in domain "DATBI"] == CSKS.DATBI
  • C_SCHEDAGRMTACCT.COSTCENTER == CSKS.KOSTL
Activity Type
  • ?
  • Controlling Area
  • Client
  • Activity Type
  • C_SCHEDAGRMTACCT.[column in domain "DATBI"] == CSLA.DATBI
  • C_SCHEDAGRMTACCT.CONTROLLINGAREA == CSLA.KOKRS
  • C_SCHEDAGRMTACCT.MANDT == CSLA.MANDT
  • C_SCHEDAGRMTACCT.COSTCTRACTIVITYTYPE == CSLA.LSTAR
Currency Key
  • Client
  • Currency Key
  • C_SCHEDAGRMTACCT.MANDT == TCURC.MANDT
  • C_SCHEDAGRMTACCT.DOCUMENTCURRENCY == TCURC.WAERS
Asset Subnumber
  • Asset Subnumber
  • Client
  • Main Asset Number
  • Company Code
  • C_SCHEDAGRMTACCT.FIXEDASSET == ANLA.ANLN2
  • C_SCHEDAGRMTACCT.MANDT == ANLA.MANDT
  • C_SCHEDAGRMTACCT.MASTERFIXEDASSET == ANLA.ANLN1
  • C_SCHEDAGRMTACCT.COMPANYCODE == ANLA.BUKRS
G/L Account Number
  • Client
  • G/L Account Number
  • ?
  • C_SCHEDAGRMTACCT.MANDT == SKA1.MANDT
  • C_SCHEDAGRMTACCT.GLACCOUNT == SKA1.SAKNR
  • C_SCHEDAGRMTACCT.[column in domain "KTOPL"] == SKA1.KTOPL
Order Number
  • Order Number
  • Client
  • C_SCHEDAGRMTACCT.ORDERID == AUFK.AUFNR
  • C_SCHEDAGRMTACCT.MANDT == AUFK.MANDT
Purchase Order Unit of Measure
  • Client
  • Purchase Order Unit of Measure
  • C_SCHEDAGRMTACCT.MANDT == T006.MANDT
  • C_SCHEDAGRMTACCT.ORDERQUANTITYUNIT == T006.MSEHI
Partner account number
  • Client
  • Partner account number
  • C_SCHEDAGRMTACCT.MANDT == KNA1.MANDT
  • C_SCHEDAGRMTACCT.PARTNERACCOUNTNUMBER == KNA1.KUNNR
Network Number for Account Assignment
  • Client
  • Network Number for Account Assignment
  • C_SCHEDAGRMTACCT.MANDT == AUFK.MANDT
  • C_SCHEDAGRMTACCT.PROJECTNETWORK == AUFK.AUFNR