P_RTPCOrderFxdPricePrdDlvValue

RTPC Order Fixed-Price Products Delivered Value | view: PFIRTPCORFXPRDLV | TRAN | Extraction: Not supported | Component: Cost Object Controlling

Tables used: ACDOCA, AFPO, FINSC_LEDGER, FINSC_ACTVE_APPL

🔑 Keys (10)
💰 Amounts (11)
∑ Quantities (1)
📅 Dates
☰ Categorical (2)
Other (4)
🔗 Relations (11)

Column Name	Description
OrderID FK	Order Number
ControllingObject FK	Object number
OrderItem	Order item number
CompanyCode FK	Company Code
FiscalYear	Fiscal Year
Ledger FK	Ledger in General Ledger Accounting
GLAccount FK	Account Number
ControllingDebitCreditCode	Debit/Credit Indicator (Origin)	Show values
Material FK	Material Number
FiscalYearPeriod	Period/Year

Column Name	Description
hsl	Amount in Company Code Currency
ksl	Amount in Global Currency
osl	Amount in Freely Defined Currency 1
vsl	Amount in Freely Defined Currency 2
bsl	Amount in Freely Defined Currency 3
csl	Amount in Freely Defined Currency 4
dsl	Amount in Freely Defined Currency 5
esl	Amount in Freely Defined Currency 6
fsl	Amount in Freely Defined Currency 7
gsl	Amount in Freely Defined Currency 8
kfsl	Fixed Amount in Global Currency

Column Name	Description
📏 Unit of Measure for Valuation Quantity (ValuationUnit):
vmsl	Valuation quantity

Column Name	Description

Column Name	Description
ControllingDebitCreditCode	Debit/Credit Indicator (Origin)	Show values
IsSettled	Indicator: Line Item is Settled or Transferred	Show values

Column Name	Description	Domain name
RefDoc	Reference document number	AWREF
RefItem	Reference Document Line Item	NUMC6
RefOrg	Reference Organizational Units	AWORG
subta	Partial Document to be balanced to zero	NUMC6

Master Data Relations	Join Conditions
Business Transaction Category Client Business Transaction Category	`P_RTPCORDERFXDPRICEPRDDLVVALUE.MANDT == FINSC_BTTYPE.MANDT` `P_RTPCORDERFXDPRICEPRDDLVVALUE.BTTYPE == FINSC_BTTYPE.BTTYPE`
Company Code Client Company Code	`P_RTPCORDERFXDPRICEPRDDLVVALUE.MANDT == T001.MANDT` `P_RTPCORDERFXDPRICEPRDDLVVALUE.COMPANYCODE == T001.BUKRS`
Account Number Client Account Number Company Code	`P_RTPCORDERFXDPRICEPRDDLVVALUE.MANDT == SKB1.MANDT` `P_RTPCORDERFXDPRICEPRDDLVVALUE.GLACCOUNT == SKB1.SAKNR` `P_RTPCORDERFXDPRICEPRDDLVVALUE.COMPANYCODE == SKB1.BUKRS`
Ledger in General Ledger Accounting Client Ledger in General Ledger Accounting	`P_RTPCORDERFXDPRICEPRDDLVVALUE.MANDT == FINSC_LEDGER.MANDT` `P_RTPCORDERFXDPRICEPRDDLVVALUE.LEDGER == FINSC_LEDGER.RLDNR`
Material Number Client Material Number	`P_RTPCORDERFXDPRICEPRDDLVVALUE.MANDT == MARA.MANDT` `P_RTPCORDERFXDPRICEPRDDLVVALUE.MATERIAL == MARA.MATNR`
Order Number Order Number Client	`P_RTPCORDERFXDPRICEPRDDLVVALUE.ORDERID == AUFK.AUFNR` `P_RTPCORDERFXDPRICEPRDDLVVALUE.MANDT == AUFK.MANDT`
Logical system of source document	`P_RTPCORDERFXDPRICEPRDDLVVALUE.REFSYS == TBDLS.LOGSYS`
Reference procedure	`P_RTPCORDERFXDPRICEPRDDLVVALUE.REFTYPE == TTYP.AWTYP`
Base Unit of Measure Client Base Unit of Measure	`P_RTPCORDERFXDPRICEPRDDLVVALUE.MANDT == T006.MANDT` `P_RTPCORDERFXDPRICEPRDDLVVALUE.UNIT == T006.MSEHI`
Unit of Measure for Valuation Quantity Client Unit of Measure for Valuation Quantity	`P_RTPCORDERFXDPRICEPRDDLVVALUE.MANDT == T006.MANDT` `P_RTPCORDERFXDPRICEPRDDLVVALUE.VALUATIONUNIT == T006.MSEHI`