I_CustProjSlsOrdItmBillgPlnItm

Billing Plan Item of Sales Order Item for Customer Project | view: ICUSTPROJSOBPIT | TRAN | Extraction: Not supported | Component: Billing Plan
Tables used: VBAPVBKDVEDAVBAKFPLAFPLTVBAKVBAPVBKDVEDA/CPD/D_MP_HDR/CPD/D_MP_ITEM
Column Name Description
CustomerProject Commercial Project ID
SalesOrderItem Sales Order Item
BillingPlan FK Billing plan number / invoicing plan number
BillingPlanItem Item for billing plan/invoice plan/payment cards
Column Name Description
💲 Currency Key (TransactionCurrency):
BillingPlanAmount Value to be billed/calc. on date in billing/invoice plan
Column Name Description
Column Name Description
BillingPlanBillingDate Billing Date
BillingPlanServiceStartDate Settlement date for deadline
BillingPlanServiceEndDate Settlement date for deadline
Column Name Description
BillingPlanUsageCategory Billing Plan Usage Category Show values
BillingPlanRelatedBillgStatus Billing status for the billing plan/invoice plan date Show values
BillgPlnDteCorrectionRfndType Indicator for correction date in billing plan Show values
BillingPlanRule Rule in billing plan/invoice plan Show values
BillingPlanItemUsage Billing Plan Item Usage Show values
Column Name Description Domain name
PostponementReason Reason for Postponement SDBP_DESCRIPTION
BillingPlanItemDescription Billing Plan Item Description SDBP_DESCRIPTION
Master Data Relations Join Conditions
Distribution channel in order header
  • Distribution Channel
  • Client
  • Sales Organization
  • I_CUSTPROJSLSORDITMBILLGPLNITM.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
  • I_CUSTPROJSLSORDITMBILLGPLNITM.MANDT == TVKOV.MANDT
  • I_CUSTPROJSLSORDITMBILLGPLNITM.SALESORGANIZATION == TVKOV.VKORG
Division in order header
  • Distribution Channel
  • Client
  • Division
  • Sales Organization
  • I_CUSTPROJSLSORDITMBILLGPLNITM.DISTRIBUTIONCHANNEL == TVTA.VTWEG
  • I_CUSTPROJSLSORDITMBILLGPLNITM.MANDT == TVTA.MANDT
  • I_CUSTPROJSLSORDITMBILLGPLNITM.ORGANIZATIONDIVISION == TVTA.SPART
  • I_CUSTPROJSLSORDITMBILLGPLNITM.SALESORGANIZATION == TVTA.VKORG
Order type in order header
  • Sales Order Type
  • Client
  • I_CUSTPROJSLSORDITMBILLGPLNITM.SALESORDERTYPE == TVAK.AUART
  • I_CUSTPROJSLSORDITMBILLGPLNITM.MANDT == TVAK.MANDT
Sales organization in order header
  • Client
  • Sales Organization
  • I_CUSTPROJSLSORDITMBILLGPLNITM.MANDT == TVKO.MANDT
  • I_CUSTPROJSLSORDITMBILLGPLNITM.SALESORGANIZATION == TVKO.VKORG
Currency Key
  • Client
  • Currency Key
  • I_CUSTPROJSLSORDITMBILLGPLNITM.MANDT == TCURC.MANDT
  • I_CUSTPROJSLSORDITMBILLGPLNITM.TRANSACTIONCURRENCY == TCURC.WAERS