I_BillingPlanDueDateAnalytics

Billing Plan Due Date Analytics | view: ISDBLNPLNDDTEANA | Extraction: Not supported | Component: Sales Analytics
Tables used: VBAP, FPLT, VBAK, VBAP, VBKD, VEDA, KNA1, TVKO
Column Name Description
SalesDocument FK Sales Document
SalesDocumentItem Sales Document Item
BillingPlan Billing plan number / invoicing plan number
BillingPlanItem Item for billing plan/invoice plan/payment cards
Column Name Description
💲 Currency Key (TransactionCurrency):
OpnSlsOrdsForInvcPlansNetAmt Open Sls Orders for Inv Plans Net Amt in Trns Crcy
Column Name Description
📏 Base Unit of Measure (BaseUnit):
OpnSlsOrdrsForDelivQuantity Open Confirmed Sales Orders for Deliveries Quantity in BU
Column Name Description
BillingPlanBillingDate Billing Date
CreationDate Date on which the record was created
Column Name Description
SDDocumentCategory SD Document Category Show values
BillingPlanRelatedBillgStatus Billing status for the billing plan/invoice plan date Show values
OrderRelatedBillingStatus Order-Related Billing Status (Item) Show values
Column Name Description Domain name
SalesOrganization Sales Organization VKORG
DistributionChannel Distribution Channel VTWEG
OrganizationDivision Division SPART
InternationalArticleNumber International Article Number (EAN/UPC) EAN11
ProfitCenter Profit Center PRCTR
SalesOffice Sales office VKBUR
SalesGroup Sales group VKGRP
SoldToParty Sold-to Party KUNNR
SoldToPartyName Name of Sold-to Party TEXT80
AdditionalCustomerGroup1 Customer Group 1 KVGR1
AdditionalCustomerGroup2 Customer Group 2 KVGR2
AdditionalCustomerGroup3 Customer Group 3 KVGR3
AdditionalCustomerGroup4 Customer Group 4 KVGR4
AdditionalCustomerGroup5 Customer Group 5 KVGR5
SalesDocumentType Sales Document Type AUART
Master Data Relations Join Conditions
Material Group 1
  • Client
  • Material Group 1
  • I_BILLINGPLANDUEDATEANALYTICS.MANDT == TVM1.MANDT
  • I_BILLINGPLANDUEDATEANALYTICS.ADDITIONALMATERIALGROUP1 == TVM1.MVGR1
Material Group 2
  • Client
  • Material Group 2
  • I_BILLINGPLANDUEDATEANALYTICS.MANDT == TVM2.MANDT
  • I_BILLINGPLANDUEDATEANALYTICS.ADDITIONALMATERIALGROUP2 == TVM2.MVGR2
Material Group 3
  • Client
  • Material Group 3
  • I_BILLINGPLANDUEDATEANALYTICS.MANDT == TVM3.MANDT
  • I_BILLINGPLANDUEDATEANALYTICS.ADDITIONALMATERIALGROUP3 == TVM3.MVGR3
Material Group 4
  • Client
  • Material Group 4
  • I_BILLINGPLANDUEDATEANALYTICS.MANDT == TVM4.MANDT
  • I_BILLINGPLANDUEDATEANALYTICS.ADDITIONALMATERIALGROUP4 == TVM4.MVGR4
Material Group 5
  • Client
  • Material Group 5
  • I_BILLINGPLANDUEDATEANALYTICS.MANDT == TVM5.MANDT
  • I_BILLINGPLANDUEDATEANALYTICS.ADDITIONALMATERIALGROUP5 == TVM5.MVGR5
Base Unit of Measure
  • Client
  • Base Unit of Measure
  • I_BILLINGPLANDUEDATEANALYTICS.MANDT == T006.MANDT
  • I_BILLINGPLANDUEDATEANALYTICS.BASEUNIT == T006.MSEHI
Batch Number
  • Client
  • Batch Number
  • Material Number
  • Product Number
  • ?
  • I_BILLINGPLANDUEDATEANALYTICS.MANDT == MCHA.MANDT
  • I_BILLINGPLANDUEDATEANALYTICS.BATCH == MCHA.CHARG
  • I_BILLINGPLANDUEDATEANALYTICS.MATERIAL == MCHA.MATNR
  • I_BILLINGPLANDUEDATEANALYTICS.PRODUCT == MCHA.MATNR
  • I_BILLINGPLANDUEDATEANALYTICS.[column in domain "WERKS_D"] == MCHA.WERKS
Customer Group
  • Client
  • Customer Group
  • I_BILLINGPLANDUEDATEANALYTICS.MANDT == T151.MANDT
  • I_BILLINGPLANDUEDATEANALYTICS.CUSTOMERGROUP == T151.KDGRP
Division
  • Client
  • Division
  • I_BILLINGPLANDUEDATEANALYTICS.MANDT == TSPA.MANDT
  • I_BILLINGPLANDUEDATEANALYTICS.DIVISION == TSPA.SPART
Material: order item
  • Client
  • Material Number
  • Product Number
  • I_BILLINGPLANDUEDATEANALYTICS.MANDT == MARA.MANDT
  • I_BILLINGPLANDUEDATEANALYTICS.MATERIAL == MARA.MATNR
  • I_BILLINGPLANDUEDATEANALYTICS.PRODUCT == MARA.MATNR
Material Group
  • Material Group
  • Product Group
  • Client
  • I_BILLINGPLANDUEDATEANALYTICS.MATERIALGROUP == T023.MATKL
  • I_BILLINGPLANDUEDATEANALYTICS.PRODUCTGROUP == T023.MATKL
  • I_BILLINGPLANDUEDATEANALYTICS.MANDT == T023.MANDT
Material Entered
  • Client
  • Material Entered
  • I_BILLINGPLANDUEDATEANALYTICS.MANDT == MARA.MANDT
  • I_BILLINGPLANDUEDATEANALYTICS.ORIGINALLYREQUESTEDMATERIAL == MARA.MATNR
Material: order item
  • Client
  • Material Number
  • Product Number
  • I_BILLINGPLANDUEDATEANALYTICS.MANDT == MARA.MANDT
  • I_BILLINGPLANDUEDATEANALYTICS.MATERIAL == MARA.MATNR
  • I_BILLINGPLANDUEDATEANALYTICS.PRODUCT == MARA.MATNR
Product Group
  • Material Group
  • Product Group
  • Client
  • I_BILLINGPLANDUEDATEANALYTICS.MATERIALGROUP == T023.MATKL
  • I_BILLINGPLANDUEDATEANALYTICS.PRODUCTGROUP == T023.MATKL
  • I_BILLINGPLANDUEDATEANALYTICS.MANDT == T023.MANDT
Product hierarchy: order item
  • Product hierarchy
  • Client
  • I_BILLINGPLANDUEDATEANALYTICS.PRODUCTHIERARCHYNODE == T179.PRODH
  • I_BILLINGPLANDUEDATEANALYTICS.MANDT == T179.MANDT
Sales District
  • Client
  • Sales District
  • I_BILLINGPLANDUEDATEANALYTICS.MANDT == T171.MANDT
  • I_BILLINGPLANDUEDATEANALYTICS.SALESDISTRICT == T171.BZIRK
Customer Classification
  • Client
  • Customer Classification
  • I_BILLINGPLANDUEDATEANALYTICS.MANDT == TKUKL.MANDT
  • I_BILLINGPLANDUEDATEANALYTICS.SOLDTOPARTYCLASSIFICATION == TKUKL.KUKLA
Statistics currency
  • Client
  • Statistics currency
  • I_BILLINGPLANDUEDATEANALYTICS.MANDT == TCURC.MANDT
  • I_BILLINGPLANDUEDATEANALYTICS.STATISTICSCURRENCY == TCURC.WAERS