fiscal_period
Archivo SQL de origen: Google Cloud Cortex Data Foundation
Google Cloud Cortex Foudantion - Cortex Reporting - (s4) - fiscal_period
Descripción general
Esta vista de informes proporciona una clasificación de registros basada en la presencia de valores en los campos Xkale y Xjabh de la tabla t009.
Fuentes de datos
| Tabla/vista de origen | Descripción |
|---|---|
| t009 | Tabla que contiene datos del sistema SAP, incluidos los campos Mandt (cliente), Periv (periodo), Xkale y Xjabh. |
Casos de uso clave
- Identificar registros que cumplen criterios específicos para su posterior análisis o elaboración de informes.
Lógica de consulta
La vista utiliza una instrucción IF anidada para clasificar los registros en tres casos:
- CASE1: Registros con un campo Xkale no nulo.
- CASE2: Registros con un campo Xjabh no nulo y un campo Xkale nulo.
- CASE3: Registros con los campos Xkale y Xjabh nulos.
Posible relación con SAP Transactions
| Codigo de transacción | Descripción de la transacción |
|---|---|
Linaje de datos
Em desarollo
Campos de tabla/vista
| Campo | Descripción del campo | Descripción del Diccionario SAP (Em breve) |
|---|---|---|
| Client_MANDT | Client | |
| ValuationArea_BWKEY | Valuation Area | |
| CompanyCode_BUKRS | Company Code | |
| ValuationGroupingCode_BWMOD | Valuation Grouping Code | |
| NegativeStocksInValuationAreaAllowed_XBKNG | Negative Stocks In Valuation Area Allowed | |
| MaterialLedgerActivatedInValuationArea_MLBWA | Material Ledger Activated In Valuation Area | |
| MaterialLedgerActivatedInValuationArea__compulsory___MLBWV | Material Ledger Activated In Valuation Area (compulsory) | |
| SalesPriceValuationActive_XVKBW | Sales Price Valuation Active | |
| ExplanationFacilityForMaterialLedgerActiveinactive_ERKLAERKOM | Explanation Facility For Material Ledger Active/inactive | |
| RetailRevalutionProfile_UPROF | Retail Revalution Profile | |
| ProfileForValueBasedInventoryManagement_WBPRO | Profile For Value Based Inventory Management | |
| MaterialPriceDetermination_Control_MLAST | Material Price Determination Control | |
| PriceDeterminationIsBindingInValuationArea_MLASV | Price Determination Is Binding In Valuation Area | |
| StockCorrectionTolerance_BDIFP | Stock Correction Tolerance | |
| PriceDifferencePostingInGrForSubcontractOder_XLBPD | Price Difference Posting In Gr For Subcontract Oder | |
| PostPurchaseAccountWithReceiptValue_XEWRX | Post Purchase Account With Receipt Value | |
| TwoFiDocumentsWithPurchaseAccount_X2FDO | Two Fi Documents With Purchase Account | |
| PriceRelease_PRSFR | Price Release | |
| ActiveActualCostComponentSplit_MLCCS | Active Actual Cost Component Split | |
| DelCostsToPriceDiffAcctWhenPurchAcctActive_XEFRE | Del Costs To Price Diff Acct When Purch Acct Active | |
| StartOfValidityPeriodFDelCostsInPriceDiffAcct_EFREJ | Start Of Validity Period F Del Costs In Price Diff Acct | |
| PriceReleaseFlexibleMaterialPrices_FMP_PRSFR | Price Release Flexible Material Prices | |
| PriceReleaseGroup_FMP_PRFRGR | Price Release Group |