In this post, I will try and describe everything you need to know about the SAP crmd_ubb_pooldis table. What it is, including what type of data it stores.
A list of fields which make up the table structure and on an S/4Hana System for CRMD_UBB_POOLDIS what does this table look like.
And what relationships it has with other SAP tables.
Also see here for example ABAP code to select data from CRMD_UBB_POOLDIS....Right lets get started!
Object Name: CRMD_UBB_POOLDIS
Dictionary Type: Transparent table
Description: Temporary Storage of Pool Billing for Async. Redist.
Field | Data Element | Data Type | length (Dec) | Check table | Description | Conversion Routine | Domain Name | MemoryID | AppClass | SHLP | SHLP Field | ConvExit |
CLIENT | MANDT | CLNT | 3(0) | * | Client | MANDT | TEST | CRM | ||||
POOL_BRI_GUID | CRMT_OBJECT_GUID | RAW | 16(0) | GUID of a CRM Order Object | SYSUUID | CRM | ||||||
KNUMV | PRCT_PRIDOC_GUID | RAW | 16(0) | Pricing Document GUID | SYSUUID | CRM | ||||||
KPOSN | PRCT_ITEM_NO | RAW | 16(0) | Item Number | SYSUUID | CRM | ||||||
STUNR | PRCT_PP_STEP | NUMC | 3(0) | * | Level Number | PRC_STEP | VF | CRM | ||||
KSCHL | PRCT_COND_TYPE | CHAR | 4(0) | * | Pricing - Condition Type | /SAPCND/COND_TYPE | VKS | VF | CRM | |||
KSTAT | PRCT_FLAG_COND_STATISTICAL | CHAR | 1(0) | Condition is Statistical | XFELD | VF | CRM | |||||
KVSL1 | PRCT_ACCOUNT_KEY_1 | CHAR | 3(0) | * | Account Key | KVSCHL | VF | CRM | ||||
KVSL2 | PRCT_ACCOUNT_KEY_2 | CHAR | 3(0) | * | Account Key - Accruals | KVSCHL | VF | CRM | ||||
KVEWE | /SAPCND/USAGE | CHAR | 2(0) | /SAPCND/T681V | Usage for Condition Technique | /SAPCND/USAGE | /SAPCND/KVW | VF | CRM | |||
KRECH | PRCT_CALCULATION_TYPE | CHAR | 3(0) | PRCC_CTYPE_DEF | Calculation Type for Condition | PRC_CALCULATION_TYPE | VF | CRM | ||||
KZBZG | PRCT_SCALE_BASE_TYPE | CHAR | 3(0) | * | Indicator: Scale Base Type | PRC_SCALE_BASE_TYPE | VF | CRM | ||||
STFKZ | PRCT_COND_SCALE_TYPE | CHAR | 1(0) | Scale Type of a Condition | PRC_COND_SCALE_TYPE | CRM | ||||||
KNTYP | PRCT_COND_CATEGORY | CHAR | 1(0) | Condition Cat.: Frt, Tax, Basic Price=Revenue, Price, Cost | PRC_CONDITION_CATEGORY | VF | CRM | |||||
KGRPE | PRCT_FLAG_GROUP_COND | CHAR | 1(0) | Condition is Group Condition | PRC_GROUP_CONDITION_FLAG | VF | CRM | |||||
KDUPL | PRCT_COND_STRUCT | CHAR | 1(0) | Structure Condition | PRC_COND_STRUCT | VF | CRM | |||||
KRUEK | PRCT_FLAG_ACCRUAL | CHAR | 1(0) | Accruals are Set up for the Condition (e.g. Freight) | XFELD | VF | CRM | |||||
KOAID | PRCT_COND_CLASS | CHAR | 1(0) | Condition Class | PRC_COND_CLASS | VF | CRM | |||||
KFKIV | PRCT_COND_INTER_COMPANY | CHAR | 1(0) | Condition for Inter-Company Billing | XFELD | CRM | ||||||
KVARC | PRCT_COND_VARIANTS | CHAR | 1(0) | Condition for Configuration | XFELD | CRM | ||||||
KTREL | PRCT_FLAG_ACCOUNT_RELEVANT | CHAR | 1(0) | Relevance for Account Assignment | PRC_FLAG_ACCOUNT_RELEVANT | CRM | ||||||
KBFLAG | PRCT_GENERAL_FLAGS | RAW | 2(0) | Bit Encrypted Flags in Pricing | PRC_GENERAL_FLAGS | CRM | ||||||
DTASRC | PRCT_DATA_SOURCE1 | CHAR | 2(0) | Primary Data Record Source for a Condition Record | PRC_COND_SOURCE | CRM | ||||||
KRELI | PRCT_FLAG_INVOICE_LIST | CHAR | 1(0) | Invoice List Condition Flag | XFELD | CRM | ||||||
KOUPD | PRCT_FLAG_COND_UPDATE | CHAR | 1(0) | Condition Update Flag | XFELD | CRM | ||||||
KAPPL | PRCT_APPLICATION | CHAR | 3(0) | * | Application | /SAPCND/APPLICATION | /SAPCND/KAP | VF | CRM | |||
KAWRT | PRCT_COND_BASIS | DEC | 18(5) | Price Determination: Condition Basis | PRC_COND_BASIS | CRM | ||||||
KHERK | PRCT_COND_ORIGIN | CHAR | 1(0) | Condition Origin | PRC_CONDITION_ORIGIN | VF | CRM | |||||
KDIFF | PRCT_COND_ROUND_DIFF | CURR | 5(2) | Rounding-Off Difference of the Condition | WERTV3 | VF | CRM | |||||
KWERT | PRCT_COND_VALUE | CURR | 15(2) | Price Determination: Condition Value | WERTV8 | CRM | ||||||
KSTEU | PRCT_COND_STATUS | CHAR | 1(0) | Condition Control | PRC_COND_STATUS | VF | CRM | |||||
KINAK | PRCT_FLAG_COND_INACTIVE | CHAR | 1(0) | Condition is Inactive | PRC_CONDITION_INACTIVE_FLAG | VF | CRM | |||||
KFAKTOR1 | PRCT_COND_BASIS_FACTOR | FLTP | 16(16) | Correction Factor for Condition Basis (Interval Scale) | FLTP | CT | CRM | |||||
KMPRS | PRCT_FLAG_COND_MAN_CHANGED | CHAR | 1(0) | Indicator: Condition Manually Changed | XFELD | CRM | ||||||
KWAEH | PRCT_CURRENCY2 | CUKY | 5(0) | * | Second Currency | WAERS | CRM | |||||
KWERT_K | PRCT_COND_VALUE2 | CURR | 15(2) | Second Condition Value | WERTV8 | CRM | ||||||
KAWRT_K | PRCT_COND_BASIS2 | DEC | 18(5) | Second Condition Basis | PRC_COND_BASIS | CRM | ||||||
KSTBS | PRCT_SCALE_BASIS | DEC | 18(5) | Pricing: Scale Basis | PRC_SCALE_BASIS | CRM | ||||||
KDATU | PRCT_PRICING_DATE | DATS | 8(0) | Condition Pricing Date | DATUM | VF | CRM | |||||
WAERS | PRCT_COND_CURR | CUKY | 5(0) | * | Condition Currency | WAERS | FWS | FB | CRM | |||
KKURS | PRCT_EXCH_RATE_COND_CURR | DEC | 9(5) | Condition Exchange Rate for Conversion to Local Currency | PRC_EXCH_RATE_COND_CURRENCY | VF | CRM | |||||
KFAKTOR | PRCT_COND_FACTOR_CONFIG | FLTP | 16(16) | Correction Factor for Conditions From Configuration | FLTP | CT | CRM | |||||
PRSQU | PRCT_COND_PRICE_SOURCE | CHAR | 1(0) | Price Source | PRC_COND_PRICE_SOURCE | CRM | ||||||
VARCOND | PRCT_VARIANT_KEY | CHAR | 26(0) | * | Variant Key of a Variant Condition | PRC_VARIANT_KEY | CRM | |||||
TXJLV | PRCT_TXJCD_LEVEL | CHAR | 1(0) | Tax Jurisdiction Code Level | CHAR1 | CRM | ||||||
DTASRC2 | PRCT_DATA_SOURCE2 | CHAR | 2(0) | Secondary Data Record Source for a Condition Record | PRC_COND_SOURCE | CRM | ||||||
KNUMH | PRCT_COND_REC_GUID | RAW | 16(0) | ID of a Condition Record | SYSUUID | CRM | ||||||
KBETR | PRCT_COND_RATE | CURR | 15(2) | Condition Rate | WERTV8 | CRM | ||||||
KPEIN | PRCT_COND_PRICING_UNIT | DEC | 5(0) | Condition Pricing Unit | PRC_CONDITION_PRICING_UNIT | VF | CRM | |||||
KMEIN | PRCT_COND_UOM | UNIT | 3(0) | * | Condition Unit | MEINS | CRM | |||||
KUMZA | PRCT_NUMERATOR | INT4 | 10(0) | Counter for Conversion to Base Unit of Measure | INT4 | CRM | ||||||
KUMNE | PRCT_DENOMINATOR | INT4 | 10(0) | Denominator for Conversion to Base Unit of Measure | INT4 | CRM | ||||||
EXPNT | PRCT_CONV_COND_EXP | INT2 | 5(0) | Base 10 Exponent for Conversion to the Base Unit of Measure | EXP10 | CRM | ||||||
MWSK1 | PRCT_SALES_TAX_CODE | CHAR | 2(0) | Sales Tax Code | PRC_SALES_TAX_CODE | FB | CRM | |||||
MWSK2 | PRCT_WITHHOLDING_TAX | CHAR | 2(0) | Withholding Tax Code | PRC_WITHHOLDING_TAX | CRM | ||||||
KONMS | PRCT_COND_SCALE_UOM | UNIT | 3(0) | * | Condition Scale Unit of Measure | MEINS | VF | CRM | ||||
KONWS | PRCT_COND_SCALE_CURR | CUKY | 5(0) | * | Currency Key: Condition Scale | WAERS | FWS | VF | CRM | |||
DUMMY | DUMMY | CHAR | 1(0) | Dummy function in length 1 | DUMMY | SAP | CRM |