PricingConditions
Archivo SQL de origen: Google Cloud Cortex Data Foundation
Google Cloud Cortex Foudantion - Cortex Reporting - (s4) - PricingConditions
Descripción general
Esta vista es una vista de informes para sistemas SAP. Proporciona acceso a datos de la tabla prcd_elements, que contiene información sobre condiciones de precios para documentos de ventas y compras.
Fuentes de datos
| Tabla/vista de origen | Descripción |
|---|---|
| prcd_elements | Condiciones de precios para documentos de ventas y compras |
| currency_decimal | Decimal de cantidades para monedas no decimales |
| currency_conversion | Tipos de conversión de moneda |
| calendar_date_dim | Dimensión de fecha de calendario |
Casos de uso clave
- Se puede utilizar para analizar las condiciones de precios para documentos de ventas y compras.
- Se puede utilizar para crear informes sobre las condiciones de precios.
- Se puede utilizar para identificar tendencias de precios.
Lógica de consulta
La vista utiliza un LEFT JOIN para combinar datos de la tabla prcd_elements con datos de las tablas currency_decimal, currency_conversion y calendar_date_dim. La vista filtra los datos para incluir solo las condiciones de precios para documentos de ventas y compras que tengan una fecha de cambio dentro del intervalo de fechas especificado.
Posible relación con SAP Transactions
| Codigo de transacción | Descripción de la transacción |
|---|---|
| VK11 | Crear orden de venta |
| VK12 | Cambiar orden de venta |
| VK13 | Mostrar orden de venta |
| ME21N | Crear orden de compra |
| ME22N | Cambiar orden de compra |
| ME23N | Mostrar orden de compra |
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 |