C_RRBSalesPricingDynamicItem

Resource Related Billing Dynamic Items | view: CRRBSLSPRDYNITEM | Extraction: Not supported | Component: Revenues and Earnings
Column Name Description
RRBSalesPricingDocument FK Sales pricing document number
RRBDynamicItem FK Number of the Dynamic Item
SalesDocument Sales Document
SalesDocumentItem Sales Document Item
BillingPlan Billing Plan
BillingPlanItem Billing Plan Item
BillingDocumentCategory Billing Document Category Show values
BillingPlanItemUsage Billing Plan Item Usage Show values
Column Name Description
💲 SD Document Currency (DocumentCurrency):
NetAmount Net value (price)
BaseUnitNetAmount Net Price
💲 Transaction Currency (TransactionCurrency):
TotalAmountInTransactionCrcy Total Value in Transaction Currency
AmountToBeBilledInTransacCrcy Total Value in Transaction Currency
AmtToBePostponedInTransacCrcy Total Value in Transaction Currency
AmtToBeRejectedInTransacCrcy Total Value in Transaction Currency
BaseUnitActualCost Total Value in Transaction Currency
Column Name Description
📏 Unit of Measure (UnitOfMeasure):
TotalQuantity Total Quantity
PostponedQuantity Total Quantity
RejectedQuantity Total Quantity
BilledQuantity Total Quantity
Column Name Description
PostingDate Service Date
BillingPlanBillingDate Billing Date
Column Name Description
BillingDocumentCategory Billing Document Category Show values
BillingPlanItemUsage Billing Plan Item Usage Show values
BillingControlCategory Billing Control Category Show values
BillingPlanRelatedBillgStatus Billing Plan Status Show values
Column Name Description Domain name
FiscalYear Fiscal Year GJAHR
AccountingDocument Journal Entry
LedgerGLLineItem Ledger Journal Entry Item
TimeSheetOvertimeCategory Overtime Category CATS_OVERTIME_CATEGORY
TimeSheetOvertimeCategoryText Overtime Category Description TEXT50
BillingControlCategoryText Billing Control Category Text
WorkItem Work Item ID /CPD/PFP_WORKITEM_ID
ControllingArea Controlling Area CACCD
DocumentItemText Data element for dynamic item long text DLILTEXT
Personnel Personnel Number PERNR
Material Material number for determining the sales price MATNR
BillingPlanItemUsageName Name of Billing Type RECAXLDESCRIPTION
LastChangeDateTime null
DocumentReferenceID Reference Document Number XBLNR1
CostCtrActivityTypeName General Name
CustomerProjectWorkPackage Work Package ID CHAR50
CustProjWorkPackageName Work Package Name CHAR60
EmployeeFullName Performed By TEXT80
DefaultEmailAddress E-Mail Address AD_SMTPADR
MobilePhoneNumber Telephone no.: dialling code+number CHAR30
PhoneNumber Telephone no.: dialling code+number CHAR30
CompanyCodeName Name of Company Code or Company TEXT25
MaterialGroup Material Group MATKL
MaterialGroupName Material Group Name TEXT20
MaterialName Material Description
WorkItemName Work Item Name /CPD/PFP_WORKITEM_NAME
SalesDocumentItemText Billing Item TEXT40
ReferenceDocument Reference document number AWREF
ReferenceDocumentItem Reference Document Item NUMC6
Master Data Relations Join Conditions
Company Code
  • Client
  • Company Code
  • C_RRBSALESPRICINGDYNAMICITEM.MANDT == T001.MANDT
  • C_RRBSALESPRICINGDYNAMICITEM.COMPANYCODE == T001.BUKRS
Activity Type
  • ?
  • ?
  • Activity Type
  • Client
  • C_RRBSALESPRICINGDYNAMICITEM.[column in domain "DATBI"] == CSLA.DATBI
  • C_RRBSALESPRICINGDYNAMICITEM.[column in domain "KOKRS"] == CSLA.KOKRS
  • C_RRBSALESPRICINGDYNAMICITEM.COSTCTRACTIVITYTYPE == CSLA.LSTAR
  • C_RRBSALESPRICINGDYNAMICITEM.MANDT == CSLA.MANDT
Distribution channel in order header
  • Distribution Channel
  • Sales Organization
  • Client
  • C_RRBSALESPRICINGDYNAMICITEM.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
  • C_RRBSALESPRICINGDYNAMICITEM.SALESORGANIZATION == TVKOV.VKORG
  • C_RRBSALESPRICINGDYNAMICITEM.MANDT == TVKOV.MANDT
Division in order header
  • Distribution Channel
  • Sales Organization
  • Client
  • Division
  • C_RRBSALESPRICINGDYNAMICITEM.DISTRIBUTIONCHANNEL == TVTA.VTWEG
  • C_RRBSALESPRICINGDYNAMICITEM.SALESORGANIZATION == TVTA.VKORG
  • C_RRBSALESPRICINGDYNAMICITEM.MANDT == TVTA.MANDT
  • C_RRBSALESPRICINGDYNAMICITEM.ORGANIZATIONDIVISION == TVTA.SPART
Order type in order header
  • Sales Document Type
  • Client
  • C_RRBSALESPRICINGDYNAMICITEM.SALESDOCUMENTTYPE == TVAK.AUART
  • C_RRBSALESPRICINGDYNAMICITEM.MANDT == TVAK.MANDT
Sales organization in order header
  • Sales Organization
  • Client
  • C_RRBSALESPRICINGDYNAMICITEM.SALESORGANIZATION == TVKO.VKORG
  • C_RRBSALESPRICINGDYNAMICITEM.MANDT == TVKO.MANDT
Source Ledger
  • Client
  • Source Ledger
  • C_RRBSALESPRICINGDYNAMICITEM.MANDT == FINSC_LEDGER.MANDT
  • C_RRBSALESPRICINGDYNAMICITEM.SOURCELEDGER == FINSC_LEDGER.RLDNR
Transaction Currency
  • Transaction Currency
  • Client
  • C_RRBSALESPRICINGDYNAMICITEM.TRANSACTIONCURRENCY == TCURC.WAERS
  • C_RRBSALESPRICINGDYNAMICITEM.MANDT == TCURC.MANDT
Unit of Measure
  • Client
  • Unit of Measure
  • C_RRBSALESPRICINGDYNAMICITEM.MANDT == T006.MANDT
  • C_RRBSALESPRICINGDYNAMICITEM.UNITOFMEASURE == T006.MSEHI