fiscal_period
Archivo SQL de origen: Google Cloud Cortex Data Foundation
Google Cloud Cortex Foudantion - Cortex Reporting - (ecc) - fiscal_period
Descripción general
Esta vista de informes proporciona una clasificación de datos SAP ECC en función de la presencia de valores en los campos Xkale y Xjabh de la tabla t009.
Fuentes de datos
| Tabla/vista de origen | Descripción |
|---|---|
| {{ project_id_src }}.{{ dataset_cdc_processed_ecc }}.t009 | Tabla ECC que contiene datos financieros. |
Casos de uso clave
- Identificar datos que requieren un procesamiento adicional en función de la presencia de valores en campos específicos.
Lógica de consulta
La vista utiliza una sentencia IF anidada para clasificar los datos en tres casos:
- CASE1: Xkale no es nulo
- CASE2: Xjabh no es nulo
- CASE3: Xkale y Xjabh son 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 |