reporting_settings_ecc.yaml [185:390]:
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
  - sql_file: MaterialTypesMD.sql
    description: "Material Types and texts"
    type: table
    table_setting:
      load_frequency: "@yearly"

  - sql_file: BillOfMaterialsMD.sql
    description: "Bill of Materials Master Data"
    type: table
    table_setting:
      load_frequency: "@daily"

  - sql_file: CurrenciesMD.sql
    description: "Currencies Master Data"
    type: table
    table_setting:
      load_frequency: "@yearly"

  - sql_file: CurrencyConvUtil.sql
    description: "Utility View for Currency Conversion (materialized recommended)"
    type: table
    table_setting:
      load_frequency: "@yearly"

  - sql_file: ProfitCentersMD.sql
    description: "Profit Centers Master Data"
    type: table
    table_setting:
      load_frequency: "@yearly"

  - sql_file: ProductionOrders.sql
    description: "Production Order Headers and Items"
    type: table
    table_setting:
      load_frequency: "@daily"

  - sql_file: CountriesMD.sql
    description: "Countries Master Data"
    type: table
    table_setting:
      load_frequency: "@yearly"
    ## CORTEX-CUSTOMER: If using currency conversion, add TCURR field to clustering settings.

  - sql_file: UoMMD.sql
    description: "Unit Of Measure master data"
    type: table
    table_setting:
      load_frequency: "@yearly"

  - sql_file: PurchaseDocuments_Flow.sql
    description: "Purchase Documents Header, Items, & Account Assignment. Primary key of this table is [Client_MANDT, DocumentNumber_EBELN, Item_EBELP, & AccountAssignment_ZEKKN]"
    type: view

  - sql_file: DivisionsMD.sql
    description: "Divisions Master Data"
    type: table
    table_setting:
      load_frequency: "@yearly"
    ## CORTEX-CUSTOMER: If using currency conversion, add TCURR field to clustering settings.

  - sql_file: PurchaseDocumentTypesMD.sql
    description: "Purchase Document Types Text"
    type: table
    table_setting:
      load_frequency: "@yearly"

  - sql_file: MaterialMovementTypesMD.sql
    description: "Material Movement Types"
    type: table
    table_setting:
      load_frequency: "@yearly"

  - sql_file: ReasonForMovementTypesMD.sql
    description: "ReasonForMovementTypesMD"
    type: table
    table_setting:
      load_frequency: "@yearly"

  - sql_file: SpecialStocksMD.sql
    description: "Special Stocks Master Data"
    type: table
    table_setting:
      load_frequency: "@yearly"

  - sql_file: PurchasingOrganizationsMD.sql
    description: "Purchasing Organizations Text"
    type: table
    table_setting:
      load_frequency: "@yearly"

  - sql_file: BatchesMD.sql
    description: "BatchesMD"
    type: table
    table_setting:
      load_frequency: "@daily"

  - sql_file: MaterialPlantsMD.sql
    description: "MaterialPlantsMD"
    type: table
    table_setting:
      load_frequency: "@yearly"

  - sql_file: PurchasingGroupsMD.sql
    description: "Purchasing Groups Text"
    type: table
    table_setting:
      load_frequency: "@yearly"

  - sql_file: PricingConditions.sql
    description: "Pricing Conditions"
    type: table
    table_setting:
      load_frequency: "@daily"

  - sql_file: SalesOrderStatus.sql
    description: "Sales Order Status"
    type: table
    table_setting:
      load_frequency: "*/10 * * * *"

  - sql_file: POScheduleLine.sql
    description: "Purchase Order Schedule Line"
    type: view

  - sql_file: MaterialsBatchMD.sql
    description: "Materials Batch Master Data"
    type: table
    table_setting:
      load_frequency: "@daily"

  - sql_file: StockInHand.sql
    description: "Stock In Hand"
    type: table
    table_setting:
      load_frequency: "@daily"

  - sql_file: OneTouchOrder.sql
    description: "One Touch Order Reporting"
    type: view
    ## CORTEX-CUSTOMER: If using currency conversion, add TCURR field to clustering settings.

  - sql_file: FSVTextsMD.sql
    description: "Text for FSV Hierarchy Node"
    type: view

  - sql_file: UniversalLedgersMD.sql
    description: "Text for Universal Ledgers"
    type: view
    ## CORTEX-CUSTOMER: If using currency conversion, add TCURR field to clustering settings.

  - sql_file: CostCenterHierarchiesMD.sql
    description: "Text for Cost Center Hierarchy"
    type: view

  - sql_file: ProfitCenterHierarchiesMD.sql
    description: "Text for Profit Center Hierarchy"
    type: view

  - sql_file: SlowMovingThreshold.sql
    description: "Slow Moving Threshold for Inventory"
    type: table
    table_setting:
      load_frequency: "@once"

  - sql_file: StockCharacteristicsConfig.sql
    description: "Configurations for stock characteristics (blocked, restricted etc) and their associated movement types"
    type: table
    table_setting:
      load_frequency: "@daily"

bq_dependent_objects:
  - sql_file: BusinessPartnersMD.sql
    description: "Business Partners and Addresses Master Data"
    type: table
    table_setting:
      load_frequency: "@daily"

  - sql_file: PurchaseDocuments.sql
    description: "Purchase Documents Header and Items"
    type: table
    table_setting:
      load_frequency: "@daily"

  - sql_file: PurchaseDocumentsHistory.sql
    description: "Purchase Documents - Order History"
    type: table
    table_setting:
      load_frequency: "@daily"

  - sql_file: InvoiceDocuments_Flow.sql
    description: "Incoming Invoice (Invoice Receipt) Header, Item, & Account Assignment."
    type: table
    table_setting:
      load_frequency: "@daily"

  - sql_file: MaterialsValuation.sql
    description: "Materials Valuation"
    type: table
    table_setting:
      load_frequency: "@daily"

  - sql_file: MaterialsMovement.sql
    description: "Material Movements"
    type: table
    table_setting:
      load_frequency: "@daily"
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -



reporting_settings_s4.yaml [183:389]:
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
  - sql_file: MaterialTypesMD.sql
    description: "Material Types and texts"
    type: table
    table_setting:
      load_frequency: "@yearly"

  - sql_file: BillOfMaterialsMD.sql
    description: "Bill of Materials Master Data"
    type: table
    table_setting:
      load_frequency: "@daily"

  - sql_file: CurrenciesMD.sql
    description: "Currencies Master Data"
    type: table
    table_setting:
      load_frequency: "@yearly"

  - sql_file: CurrencyConvUtil.sql
    description: "Utility View for Currency Conversion (materialized recommended)"
    type: table
    table_setting:
      load_frequency: "@yearly"

  - sql_file: ProfitCentersMD.sql
    description: "Profit Centers Master Data"
    type: table
    table_setting:
      load_frequency: "@yearly"

  - sql_file: ProductionOrders.sql
    description: "Production Order Headers and Items"
    type: table
    table_setting:
      load_frequency: "@daily"

  - sql_file: CountriesMD.sql
    description: "Countries Master Data"
    type: table
    table_setting:
      load_frequency: "@yearly"
    ## CORTEX-CUSTOMER: If using currency conversion, add TCURR field to clustering settings.

  - sql_file: UoMMD.sql
    description: "Unit Of Measure master data"
    type: table
    table_setting:
      load_frequency: "@yearly"

  - sql_file: PurchaseDocuments_Flow.sql
    description: "Purchase Documents Header, Items, & Account Assignment. Primary key of this table is [Client_MANDT, DocumentNumber_EBELN, Item_EBELP, & AccountAssignment_ZEKKN]"
    type: view

  - sql_file: DivisionsMD.sql
    description: "Divisions Master Data"
    type: table
    table_setting:
      load_frequency: "@yearly"
    ## CORTEX-CUSTOMER: If using currency conversion, add TCURR field to clustering settings.

  - sql_file: PurchaseDocumentTypesMD.sql
    description: "Purchase Document Types Text"
    type: table
    table_setting:
      load_frequency: "@yearly"

  - sql_file: MaterialMovementTypesMD.sql
    description: "Material Movement Types"
    type: table
    table_setting:
      load_frequency: "@yearly"

  - sql_file: ReasonForMovementTypesMD.sql
    description: "ReasonForMovementTypesMD"
    type: table
    table_setting:
      load_frequency: "@yearly"

  - sql_file: SpecialStocksMD.sql
    description: "Special Stocks Master Data"
    type: table
    table_setting:
      load_frequency: "@yearly"

  - sql_file: PurchasingOrganizationsMD.sql
    description: "Purchasing Organizations Text"
    type: table
    table_setting:
      load_frequency: "@yearly"

  - sql_file: BatchesMD.sql
    description: "BatchesMD"
    type: table
    table_setting:
      load_frequency: "@daily"

  - sql_file: MaterialPlantsMD.sql
    description: "MaterialPlantsMD"
    type: table
    table_setting:
      load_frequency: "@yearly"

  - sql_file: PurchasingGroupsMD.sql
    description: "Purchasing Groups Text"
    type: table
    table_setting:
      load_frequency: "@yearly"

  - sql_file: PricingConditions.sql
    description: "Pricing Conditions"
    type: table
    table_setting:
      load_frequency: "@daily"

  - sql_file: SalesOrderStatus.sql
    description: "Sales Order Status"
    type: table
    table_setting:
      load_frequency: "*/10 * * * *"

  - sql_file: POScheduleLine.sql
    description: "Purchase Order Schedule Line"
    type: view

  - sql_file: MaterialsBatchMD.sql
    description: "Materials Batch Master Data"
    type: table
    table_setting:
      load_frequency: "@daily"

  - sql_file: StockInHand.sql
    description: "Stock In Hand"
    type: table
    table_setting:
      load_frequency: "@daily"

  - sql_file: OneTouchOrder.sql
    description: "One Touch Order Reporting"
    type: view
    ## CORTEX-CUSTOMER: If using currency conversion, add TCURR field to clustering settings.

  - sql_file: FSVTextsMD.sql
    description: "Text for FSV Hierarchy Node"
    type: view

  - sql_file: UniversalLedgersMD.sql
    description: "Text for Universal Ledgers"
    type: view
    ## CORTEX-CUSTOMER: If using currency conversion, add TCURR field to clustering settings.

  - sql_file: CostCenterHierarchiesMD.sql
    description: "Text for Cost Center Hierarchy"
    type: view

  - sql_file: ProfitCenterHierarchiesMD.sql
    description: "Text for Profit Center Hierarchy"
    type: view

  - sql_file: SlowMovingThreshold.sql
    description: "Slow Moving Threshold for Inventory"
    type: table
    table_setting:
      load_frequency: "@once"

  - sql_file: StockCharacteristicsConfig.sql
    description: "Configurations for stock characteristics (blocked, restricted etc) and their associated movement types"
    type: table
    table_setting:
      load_frequency: "@daily"

bq_dependent_objects:

  - sql_file: BusinessPartnersMD.sql
    description: "Business Partners and Addresses Master Data"
    type: table
    table_setting:
      load_frequency: "@daily"

  - sql_file: PurchaseDocuments.sql
    description: "Purchase Documents Header and Items"
    type: table
    table_setting:
      load_frequency: "@daily"

  - sql_file: PurchaseDocumentsHistory.sql
    description: "Purchase Documents - Order History"
    type: table
    table_setting:
      load_frequency: "@daily"

  - sql_file: InvoiceDocuments_Flow.sql
    description: "Incoming Invoice (Invoice Receipt) Header, Item, & Account Assignment."
    type: table
    table_setting:
      load_frequency: "@daily"

  - sql_file: MaterialsValuation.sql
    description: "Materials Valuation"
    type: table
    table_setting:
      load_frequency: "@daily"

  - sql_file: MaterialsMovement.sql
    description: "Material Movements"
    type: table
    table_setting:
      load_frequency: "@daily"
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -



