C_OutsrtdUtilsBillgMaLeApply

Machine Learning Apply Data for Outsorted Billing | view: CEOUTBILMLAPPLY | Extraction: Not supported | Component: Contract Billing

Tables used: ERCH, DBERCHU, ERCHO, TFK001G, T001, TKA02, FKKVK, FKKVKP, EVER, EANLH, ETTA

🔑 Keys (1)
💰 Amounts
∑ Quantities
📅 Dates
☰ Categorical (6)
Other (98)
🔗 Relations (9)

Column Name	Description
UtilitiesBillingDocument	Billing Document Number

Column Name	Description

Column Name	Description

Column Name	Description

Column Name	Description
UtilitiesBillingReason	Billing Reason	Show values
UtilsBillgDocHasPreviousDoc	Previous Document Exists for Billing Document	Show values
Utils1stBillgDocIsOutsorted	First Billing Document after Move-In is Outsorted	Show values
UtilsBillgDocLineItmCnvrsnRsn	Conversion reason	Show values
UtilsBillgDocHasCnvrsnRsn	Billing Document has Conversion Reason	Show values
UtilsBillgDocIsCorrectlyReld	Billing Document is Correctly Released	Show values

Column Name	Description	Domain name
UtilitiesAccountClass	Account Class	KTOKLASSE
UtilsOutsrtgCheckGrpForBillg	Outsorting Check Group	AUSGRUP
UtilitiesPeriodConsumptionVal	Period Consumption	PERVERBR
UtilsBillgPeriodDuration	Billing Period Duration in Days
UtilsBillgDocTotalNetAmt	Total Net Amount for Billing Document	E_DECIMAL_STSTC_ML
UtilsBillgDocAdjdTotalNetAmt	Adjusted Total Net Amount for Billing Document	E_DECIMAL_STSTC_ML
UtilsPrevBillgDocNetAmt	Total Net Amount of Previous Document	E_DECIMAL_STSTC_ML
UtilsPrevBillgDocAdjdNetAmt	Adjusted Total Net Amount of Previous Document	E_DECIMAL_STSTC_ML
UtilsPrevBillgDiffNetAmt	Previous Document Net Amount Difference	E_DECIMAL_STSTC_ML
UtilsPrevBillgDiffAdjdNetAmt	Adjusted Net Amount Difference for Previous Document	E_DECIMAL_STSTC_ML
UtilsPrevDocMinNetAmt	Min Net Amt over Current and Previous Document	E_DECIMAL_STSTC_ML
UtilsPrevDocMaxNetAmt	Max Net Amt over Current and Previous Document	E_DECIMAL_STSTC_ML
UtilsPrevDocAvgNetAmt	Avg Net Amt over Current and Previous Document	E_DECIMAL_STSTC_ML
UtilsPrevDocMdnNetAmt	Mdn Val of Net Amt over Current and Previous Document	E_DECIMAL_STSTC_ML
UtilsPrevDocSTDVNetAmt	Stdv Val of Net Amt over Current and Previous Document	E_DECIMAL_STSTC_ML
UtilsPrevDocVarcNetAmt	Varc Val of Net Amt over Current and Previous Document	E_DECIMAL_STSTC_ML
UtilsPrevDocMinAdjdNetAmt	Min Adjd Net Amt over Current and Previous Document	E_DECIMAL_STSTC_ML
UtilsPrevDocMaxAdjdNetAmt	Max Adjd Net Amt over Current and Previous Document	E_DECIMAL_STSTC_ML
UtilsPrevDocAvgAdjdNetAmt	Avg Adjd Net Amt over Current and Previous Document	E_DECIMAL_STSTC_ML
UtilsPrevDocMdnAdjdNetAmt	Mdn Val of Adjd Net Amt over Current and Previous Document	E_DECIMAL_STSTC_ML
UtilsPrevDocSTDVAdjdNetAmt	Stdv Val of Adjd Net Amt over Current and Previous Document	E_DECIMAL_STSTC_ML
UtilsPrevDocVarcAdjdNetAmt	Varc Val of Adjd Net Amt over Current and Previous Document	E_DECIMAL_STSTC_ML
UtilsPrevDocMinPrevNetAmt	Min Prev Net Amt over Current and Previous Document	E_DECIMAL_STSTC_ML
UtilsPrevDocMaxPrevNetAmt	Max Prev Net Amt over Current and Previous Document	E_DECIMAL_STSTC_ML
UtilsPrevDocAvgPrevNetAmt	Avg Prev Net Amt over Current and Previous Document	E_DECIMAL_STSTC_ML
UtilsPrevDocMdnPrevNetAmt	Mdn Val of Prev Net Amt over Current and Previous Document	E_DECIMAL_STSTC_ML
UtilsPrevDocSTDVPrevNetAmt	Stdv Val of Prev Net Amt over Current and Previous Document	E_DECIMAL_STSTC_ML
UtilsPrevDocVarcPrevNetAmt	Varc Val of Prev Net Amt over Current and Previous Document	E_DECIMAL_STSTC_ML
UtilsPrevDocMinPrevAdjdNetAmt	Min Prev Adjd Net Amt over Current and Previous Doc	E_DECIMAL_STSTC_ML
UtilsPrevDocMaxPrevAdjdNetAmt	Max Prev Adjd Net Amt over Current and Previous Doc	E_DECIMAL_STSTC_ML
UtilsPrevDocAvgPrevAdjdNetAmt	Avg Prev Adjd Net Amt over Current and Previous Doc	E_DECIMAL_STSTC_ML
UtilsPrevDocMdnPrevAdjdNetAmt	Mdn Val of Prev Adjd Net Amt over Current and Previous Doc	E_DECIMAL_STSTC_ML
UtilsPrevDocSTDVPrevAdjdNetAmt	Stdv Val of Prev Adjd Net Amt over Current and Previous Doc	E_DECIMAL_STSTC_ML
UtilsPrevDocVarcPrevAdjdNetAmt	Varc Val of Prev Adjd Net Amt over Current and Previous Doc	E_DECIMAL_STSTC_ML
UtilsPrevDocMinDiffNetAmt	Min Net Amount Diff over Current and Previous Doc	E_DECIMAL_STSTC_ML
UtilsPrevDocMaxDiffNetAmt	Max Net Amount Diff over Current and Previous Doc	E_DECIMAL_STSTC_ML
UtilsPrevDocAvgDiffNetAmt	Avg Net Amount Diff over Current and Previous Doc	E_DECIMAL_STSTC_ML
UtilsPrevDocMdnDiffNetAmt	Mdn Val of Net Amount Diff over Current and Previous Doc	E_DECIMAL_STSTC_ML
UtilsPrevDocSTDVDiffNetAmt	Stdv Val of Net Amount Diff over Current and Previous Doc	E_DECIMAL_STSTC_ML
UtilsPrevDocVarcDiffNetAmt	Varc Val of Net Amount Diff over Current and Previous Doc	E_DECIMAL_STSTC_ML
UtilsPrevDocMinDiffAdjdNetAmt	Min Adjd Net Amount Diff over Current and Previous Doc	E_DECIMAL_STSTC_ML
UtilsPrevDocMaxDiffAdjdNetAmt	Max Adjd Net Amount Diff over Current and Previous Doc	E_DECIMAL_STSTC_ML
UtilsPrevDocAvgDiffAdjdNetAmt	Avg Adjd Net Amount Diff over Current and Previous Doc	E_DECIMAL_STSTC_ML
UtilsPrevDocMdnDiffAdjdNetAmt	Mdn Val of Adjd Net Amt Diff over Current and Previous Doc	E_DECIMAL_STSTC_ML
UtilsPrevDocSTDVDiffAdjdNetAmt	Stdv Val of Adjd Net Amt Diff over Current and Previous Doc	E_DECIMAL_STSTC_ML
UtilsPrevDocVarcDiffAdjdNetAmt	Varc Val of Adjd Net Amt Diff over Current and Previous Doc	E_DECIMAL_STSTC_ML
UtilsCurYrMinNetAmt	Minimum Net Amount in Current Calendar Year	E_DECIMAL_STSTC_ML
UtilsCurYrMaxNetAmt	Maximal Net Amount in Current Calendar Year	E_DECIMAL_STSTC_ML
UtilsCurYrAvgNetAmt	Average Net Amount in Current Calendar Year	E_DECIMAL_STSTC_ML
UtilsCurYrMdnNetAmt	Median Value of Net Amount in Current Calendar Year	E_DECIMAL_STSTC_ML
UtilsCurYrSTDVNetAmt	Stdv Value of Net Amount in Current Calendar Year	E_DECIMAL_STSTC_ML
UtilsCurYrVarcNetAmt	Variance Value of Net Amount in Current Calendar Year	E_DECIMAL_STSTC_ML
UtilsCurYrMinAdjdTotNetAmt	Minimal Adjd Net Amount in Current Calendar Year	E_DECIMAL_STSTC_ML
UtilsCurYrMaxAdjdTotNetAmt	Maximal Adjd Net Amount in Current Calendar Year	E_DECIMAL_STSTC_ML
UtilsCurYrAvgAdjdTotNetAmt	Average Adjusted Net Amount in Current Calendar Year	E_DECIMAL_STSTC_ML
UtilsCurYrMdnAdjdTotNetAmt	Median Value of Adjd Net Amount in Current Calendar Year	E_DECIMAL_STSTC_ML
UtilsCurYrSTDVAdjdTotNetAmt	Stdv Value of Adjd Net Amount in Current Calendar Year	E_DECIMAL_STSTC_ML
UtilsCurYrVarcAdjdTotNetAmt	Variance Value of Adjd Net Amount in Current Calendar Year	E_DECIMAL_STSTC_ML
UtilsPrevYrBillgDocNetAmt	Total Net Amount of Previous Year Document	E_DECIMAL_STSTC_ML
UtilsPrevYrBillgDocAdjdNetAmt	Adjusted Total Net Amount of Previous Year Document	E_DECIMAL_STSTC_ML
UtilsPrevYrBillgDiffNetAmt	Difference of Current and Previous Year Document Net Amounts	E_DECIMAL_STSTC_ML
UtilsPrevYrBillgDiffAdjdNetAmt	Diff of Current and Previous Year Doc Adjusted Net Amounts	E_DECIMAL_STSTC_ML
UtilsThreeYrMinNetAmt	Min Net Amt over Current and Two Prev Year Docs	E_DECIMAL_STSTC_ML
UtilsThreeYrMaxNetAmt	Max Net Amt over Current and Two Prev Year Docs	E_DECIMAL_STSTC_ML
UtilsThreeYrAvgNetAmt	Avg Net Amt over Current and Two Prev Year Docs	E_DECIMAL_STSTC_ML
UtilsThreeYrMdnNetAmt	Mdn Val of Net Amt over Current and Two Prev Year Docs	E_DECIMAL_STSTC_ML
UtilsThreeYrSTDVNetAmt	Stdv Val of Net Amt over Current and Two Prev Year Docs	E_DECIMAL_STSTC_ML
UtilsThreeYrVarcNetAmt	Varc Val of Net Amt over Current and Two Prev Year Docs	E_DECIMAL_STSTC_ML
UtilsThreeYrMinAdjdNetAmt	Min Adjd Net Amt over Current and Two Prev Year Docs	E_DECIMAL_STSTC_ML
UtilsThreeYrMaxAdjdNetAmt	Max Adjd Net Amt over Current and Two Prev Year Docs	E_DECIMAL_STSTC_ML
UtilsThreeYrAvgAdjdNetAmt	Avg Adjd Net Amt over Current and Two Prev Year Docs	E_DECIMAL_STSTC_ML
UtilsThreeYrMdnAdjdNetAmt	Mdn Val of Adjd Net Amt over Current and Two Prev Year Docs	E_DECIMAL_STSTC_ML
UtilsThreeYrSTDVAdjdNetAmt	Stdv Val of Adjd Net Amt over Current and Two Prev Year Docs	E_DECIMAL_STSTC_ML
UtilsThreeYrVarcAdjdNetAmt	Varc Val of Adjd Net Amt over Current and Two Prev Year Docs	E_DECIMAL_STSTC_ML
UtilsThreeYrMinPrevYrNetAmt	Min Prev Net Amt over Current and Two Prev Year Docs	E_DECIMAL_STSTC_ML
UtilsThreeYrMaxPrevYrNetAmt	Max Prev Net Amt over Current and Two Prev Year Docs	E_DECIMAL_STSTC_ML
UtilsThreeYrAvgPrevYrNetAmt	Avg Prev Net Amt over Current and Two Prev Year Docs	E_DECIMAL_STSTC_ML
UtilsThreeYrMdnPrevYrNetAmt	Mdn Val of Prev Net Amt over Current and Two Prev Year Docs	E_DECIMAL_STSTC_ML
UtilsThreeYrSTDVPrevYrNetAmt	Stdv Val of Prev Net Amt over Current and Two Prev Year Docs	E_DECIMAL_STSTC_ML
UtilsThreeYrVarcPrevYrNetAmt	Varc Val of Prev Net Amt over Current and Two Prev Year Docs	E_DECIMAL_STSTC_ML
UtilsThreeYrMinPrevAdjdNetAmt	Min Prev Adjd Net Amt ovr Cur and Two Prev Year Docs	E_DECIMAL_STSTC_ML
UtilsThreeYrMaxPrevAdjdNetAmt	Max Prev Adjd Net Amt ovr Cur and Two Prev Year Docs	E_DECIMAL_STSTC_ML
UtilsThreeYrAvgPrevAdjdNetAmt	Avg Prev Adjd Net Amt ovr Cur and Two Prev Year Docs	E_DECIMAL_STSTC_ML
UtilsThreeYrMdnPrevAdjdNetAmt	Mdn Val of Prev Adjd Net Amt ovr Cur and Two Prev Year Docs	E_DECIMAL_STSTC_ML
UtilsThreeYrSTDVPrevAdjdNetAmt	Stdv Val of Prev Adjd Net Amt ovr Cur and Two Prev Year Docs	E_DECIMAL_STSTC_ML
UtilsThreeYrVarcPrevAdjdNetAmt	Varc Val of Prev Adjd Net Amt ovr Cur and Two Prev Year Docs	E_DECIMAL_STSTC_ML
UtilsThreeYrMinDiffNetAmt	Min Net Amount Diff ovr Cur and Two Prev Year Docs	E_DECIMAL_STSTC_ML
UtilsThreeYrMaxDiffNetAmt	Max Net Amount Diff ovr Cur and Two Prev Year Docs	E_DECIMAL_STSTC_ML
UtilsThreeYrAvgDiffNetAmt	Avg Net Amount Diff ovr Cur and Two Prev Year Docs	E_DECIMAL_STSTC_ML
UtilsThreeYrMdnDiffNetAmt	Mdn Val of Net Amount Diff ovr Cur and Two Prev Year Docs	E_DECIMAL_STSTC_ML
UtilsThreeYrSTDVDiffNetAmt	Stdv Val of Net Amount Diff ovr Cur and Two Prev Year Docs	E_DECIMAL_STSTC_ML
UtilsThreeYrVarcDiffNetAmt	Varc Val of Net Amount Diff ovr Cur and Two Prev Year Docs	E_DECIMAL_STSTC_ML
UtilsThreeYrMinDiffAdjdNetAmt	Min Adjd Net Amount Diff ovr Cur and Two Prev Year Docs	E_DECIMAL_STSTC_ML
UtilsThreeYrMaxDiffAdjdNetAmt	Max Adjd Net Amount Diff ovr Cur and Two Prev Year Docs	E_DECIMAL_STSTC_ML
UtilsThreeYrAvgDiffAdjdNetAmt	Avg Adjd Net Amount Diff ovr Cur and Two Prev Year Docs	E_DECIMAL_STSTC_ML
UtilsThreeYrMdnDiffAdjdNetAmt	Mdn Val of Adjd Net Amt Diff ovr Cur and Two Prev Year Docs	E_DECIMAL_STSTC_ML
UtilsThreeYrSTDVDiffAdjdNetAmt	Stdv Val of Adjd Net Amt Diff ovr Cur and Two Prev Year Docs	E_DECIMAL_STSTC_ML
UtilsThreeYrVarcDiffAdjdNetAmt	Varc Val of Adjd Net Amt Diff ovr Cur and Two Prev Year Docs	E_DECIMAL_STSTC_ML

Master Data Relations	Join Conditions
Check table Contract Account Category ? Client	`C_OUTSRTDUTILSBILLGMALEAPPLY.CONTRACTACCOUNTCATEGORY == TFK002A.VKTYP` `C_OUTSRTDUTILSBILLGMALEAPPLY.[column in domain "APPLK_KK"] == TFK002A.APPLK` `C_OUTSRTDUTILSBILLGMALEAPPLY.MANDT == TFK002A.MANDT`
Division Client Division	`C_OUTSRTDUTILSBILLGMALEAPPLY.MANDT == TSPA.MANDT` `C_OUTSRTDUTILSBILLGMALEAPPLY.DIVISION == TSPA.SPART`
Industry Industry ? Client	`C_OUTSRTDUTILSBILLGMALEAPPLY.INDUSTRYSECTOR == TB038A.IND_SECTOR` `C_OUTSRTDUTILSBILLGMALEAPPLY.[column in domain "BU_ISTYPE"] == TB038A.ISTYPE` `C_OUTSRTDUTILSBILLGMALEAPPLY.MANDT == TB038A.CLIENT`
Account determination ID for IS-U contracts ? Account determination ID for IS-U contracts Client Division	`C_OUTSRTDUTILSBILLGMALEAPPLY.[column in domain "BUKRS"] == TE097.BUKRS` `C_OUTSRTDUTILSBILLGMALEAPPLY.UTILITIESACCOUNTDETNCODE == TE097.KOFIZ` `C_OUTSRTDUTILSBILLGMALEAPPLY.MANDT == TE097.MANDT` `C_OUTSRTDUTILSBILLGMALEAPPLY.DIVISION == TE097.SPARTE`
Check Check Client	`C_OUTSRTDUTILSBILLGMALEAPPLY.UTILITIESBILLINGCHECK == TE007.VALIDATION` `C_OUTSRTDUTILSBILLGMALEAPPLY.MANDT == TE007.MANDT`
Billing Class Billing Class Client	`C_OUTSRTDUTILSBILLGMALEAPPLY.UTILITIESBILLINGCLASS == EAKLASSE.AKLASSE` `C_OUTSRTDUTILSBILLGMALEAPPLY.MANDT == EAKLASSE.MANDT`
Portion Client Portion	`C_OUTSRTDUTILSBILLGMALEAPPLY.MANDT == TE420.MANDT` `C_OUTSRTDUTILSBILLGMALEAPPLY.UTILITIESPORTION == TE420.TERMSCHL`
Rate Category Client Rate Category	`C_OUTSRTDUTILSBILLGMALEAPPLY.MANDT == ETTA.MANDT` `C_OUTSRTDUTILSBILLGMALEAPPLY.UTILITIESRATECATEGORY == ETTA.TARIFTYP`
Outsorting Reason Outsorting Reason Client	`C_OUTSRTDUTILSBILLGMALEAPPLY.UTILSBILLGOUTSORTINGREASON == TE127.MANOUTSORT` `C_OUTSRTDUTILSBILLGMALEAPPLY.MANDT == TE127.MANDT`