PricingConditions
Archivo SQL de origen: Google Cloud Cortex Data Foundation
Google Cloud Cortex Foudantion - Cortex Reporting - (ecc) - PricingConditions
Descripción general
Esta vista de informes proporciona información detallada sobre los registros de condiciones en los sistemas SAP. Combina datos de la tabla KONV con dimensiones adicionales de la tabla calendar_date_dim y tablas de conversión de moneda (opcional). La vista está diseñada para soportar varios escenarios de informes y análisis relacionados con la gestión de precios y condiciones.
Fuentes de datos
| Tabla/vista de origen | Descripción |
|---|---|
| KONV | Tabla SAP que contiene registros de condiciones |
| currency_decimal | Tabla con información de decimales para monedas |
| currency_conversion | Tabla con tipos de conversión de moneda (opcional) |
| calendar_date_dim | Tabla de dimensión con atributos relacionados con el calendario |
Casos de uso clave
- Analizar registros de condiciones y su impacto en la fijación de precios
- Identificar y gestionar discrepancias de precios
- Informar sobre datos relacionados con las condiciones para fines financieros y operativos
- Respaldar la toma de decisiones basada en datos en las estrategias de precios y ventas
Lógica de consulta
La consulta recupera registros de condiciones de la tabla KONV y los une con datos adicionales de la tabla calendar_date_dim. También incluye uniones opcionales con tablas de conversión de moneda para permitir la conversión de moneda. La consulta filtra y agrega los datos según los criterios especificados para proporcionar una vista completa de los registros de condiciones.
Posible relación con SAP Transactions
| Codigo de transacción | Descripción de la transacción |
|---|---|
| VK11 | Crear registros de condiciones |
| VK12 | Cambiar registros de condiciones |
| VK13 | Mostrar registros de condiciones |
| VK14 | Eliminar registros de condiciones |
Linaje de datos
Em desarollo
Campos de tabla/vista
| Campo | Descripción del campo | Descripción del Diccionario SAP (Em breve) |
|---|---|---|
| Client_MANDT | Client | |
| NumberOfTheDocumentCondition_KNUMV | Number of the document condition | |
| ConditionItemNumber_KPOSN | Condition item number | |
| StepNumber_STUNR | Step number | |
| ConditionCounter_ZAEHK | Condition counter | |
| Application_KAPPL | Application | |
| ConditionType_KSCHL | Condition type | |
| CalculationTypeForCondition_KRECH | Calculation type for condition | |
| Checkbox_KAWRT | Checkbox | |
| ConditionAmountOrPercentage_KBETR | Condition amount or percentage | |
| ConditionExchangeRateForConversionToLocalCurrency_KKURS | Condition exchange rate for conversion to local currency | |
| ConditionPricingUnit_KPEIN | Condition pricing unit | |
| ConditionUnitInTheDocument_KMEIN | Condition unit in the document | |
| NumeratorForConvertingConditionUnitsToBaseUnits_KUMZA | Numerator for converting condition units to base units | |
| DenominatorForConvertingConditionUnitsToBaseUnits_KUMNE | Denominator for converting condition units to base units | |
| ConditionCategory_KNTYP | Condition category | |
| ConditionIsUsedForStatistics_KSTAT | Condition is used for statistics | |
| ScaleType_KNPRS | Scale type | |
| ConditionIsRelevantForAccrual_KRUEK | Condition is relevant for accrual | |
| ConditionForInvoiceList_KRELI | Condition for invoice list | |
| OriginOfTheCondition_KHERK | Origin of the condition | |
| GroupCondition_KGRPE | Group condition | |
| ConditionUpdate_KOUPD | Condition update | |
| AccessSequenceAccessNumber_KOLNR | Access sequence access number | |
| NumberOfConditionRecordFromBatchDetermination_KNUMH | Number of condition record from batch determination | |
| SequentialNumberOfTheCondition_KOPOS | Sequential number of the condition | |
| AccountKey_KVSL1 | Account key | |
| GLAccountNumber_SAKN1 | GL account number | |
| TaxOnSalesPurchasesCode_MWSK1 | Tax on sales/purchases code | |
| AccountKeyAccrualsProvisions_KVSL2 | Account key accruals/provisions | |
| GLAccountNumber_SAKN2 | GL account number | |
| WithholdingTaxCode_MWSK2 | Withholding tax code | |
| AccountNumberOfVendorORCreditor_LIFNR | Account number of vendor or creditor | |
| CustomerNumber_KUNNR | Customer number | |
| RoundingOffDifferenceOfTheCondition_KDIFF | Rounding off difference of the condition | |
| ConditionControl_KSTEU | Condition control | |
| ConditionIsInactive_KINAK | Condition is inactive | |
| ConditionClass_KOAID | Condition class | |
| ConditionCounter_ZAEKO | Condition counter | |
| IndicatorForMaximumConditionBaseValue_KMXAW | Indicator for maximum condition base value | |
| IndicatorForMaximumConditionAmount_KMXWR | Indicator for maximum condition amount | |
| FactorForConditionBaseValue_KFAKTOR | Factor for condition base value | |
| StructureCondition_KDUPL | Structure condition | |
| FactorForConditionBasis_KFAKTOR1 | Factor for condition basis | |
| ScaleBasisIndicator_KZBZG | Scale basis indicator | |
| ScaleBaseValueOfTheCondition_KSTBS | Scale base value of the condition | |
| ConditionScaleUnitOfMeasure_KONMS | Condition scale unit of measure | |
| ScaleCurrency_KONWS | Scale currency | |
| UpdatedInformationInRelatedUserDataField_KAWRT_K | Updated information in related user data field | |
| ConditionCurrency_KWAEH | Condition currency | |
| ConditionValue_KWERT_K | Condition value | |
| ConditionForInterCompanyBilling_KFKIV | Condition for intercompany billing | |
| VariantCond_KVARC | Variant condition | |
| ConditionChangedManually_KMPRS | Condition changed manually | |
| PriceSource_PRSQU | Price source | |
| VariantCondition_VARCOND | Variant condition | |
| RelevanceForAccountAssignment_KTREL | Relevance for account assignment | |
| IndicatorMatrixMaintenance_MDFLG | Indicator matrix maintenance | |
| TaxJurisdictionCodeLevel_TXJLV | Tax jurisdiction code level | |
| BitEncryptedFlagsInPricing_KBFLAG | Bit encrypted flags in pricing | |
| IdentifierOfCPFFormulaInDocument_CPF_GUID | Identifier of CPF formula in document | |
| AdjustedQuantity_KAQTY | Adjusted quantity | |
| YearOfChangeDate_KDATU | Year of change date | |
| MonthOfChangeDate_KDATU | Month of change date | |
| WeekOfChangeDate_KDATU | Week of change date | |
| QuarterOfChangeDate_KDATU | Quarter of change date | |
| Checkbox_KDATU | Checkbox | |
| Level_STUFE | Level | |
| Path_WEGXX | Path | |
| AccessSequenceAccessNumber_KOLNR3 | Access sequence access number | |
| ExchangeRate_UKURS | Exchange rate | |
| Conversion_date | Conversion date | |
| TargetCurrency_TCURR | Target currency | |
| ConditionValueInTargetCurrency_KWERT | Condition value in target currency | |
| ProcessConditionsWithValueEqualToZero_VAL_ZERO | Process conditions with value equal to zero | |
| StatisticalAndRelevantForAccountDetermination_IS_ACCT_DETN_RELEVANT | Statistical and relevant for account determination | |
| TaxReportingCountry_TAX_COUNTRY | Tax reporting country | |
| SDDocumentCurrency_WAERK | SD document currency | |
| DataFilterValueForDataAging_DATAAGING | Data filter value for data aging | |
| CurrencyKey_WAERS | Currency key | |
| ConditionValue_KWERT | Condition value |