PlantsMD
Archivo SQL de origen: Google Cloud Cortex Data Foundation
Google Cloud Cortex Foudantion - Cortex Reporting - (s4) - PlantsMD
Descripción general
Esta vista proporciona una descripción general completa de los datos relacionados con la planta en los sistemas SAP. Combina datos de la tabla T001W para proporcionar información sobre los atributos de la planta, como el nombre, la ubicación, los números de cliente y proveedor, y varios indicadores y ajustes relacionados con las operaciones de la planta.
Fuentes de datos
| Tabla/vista de origen | Descripción |
|---|---|
| T001W | Tabla de datos de planta en sistemas SAP |
Casos de uso clave
- Analizar información específica de la planta para propósitos de informes y análisis.
- Identificar plantas basadas en criterios específicos, como ubicación, industria o relaciones con los clientes.
- Comprender la configuración y los ajustes relacionados con las operaciones de la planta, como la gestión del estado del lote, las condiciones y los requisitos de la lista de fuentes.
- Monitorear indicadores a nivel de planta, como jurisdicción fiscal, canales de distribución y divisiones, para propósitos de facturación entre empresas.
- Recuperar datos específicos de la planta para su integración con otros sistemas o aplicaciones.
Lógica de consulta
La vista es una proyección simple de la tabla T001W, sin ningún filtrado o agregación adicional aplicado.
Posible relación con SAP Transactions
| Codigo de transacción | Descripción de la transacción |
|---|---|
| MM01 | Crear planta |
| MM02 | Cambiar planta |
| MM03 | Mostrar planta |
Linaje de datos
Em desarollo
Campos de tabla/vista
| Campo | Descripción del campo | Descripción del Diccionario SAP (Em breve) |
|---|---|---|
| Client_MANDT | Client | |
| Plant_WERKS | Plant | |
| Name_NAME1 | Name | |
| ValuationArea_BWKEY | Valuation Area | |
| CustomerNumberOfPlant_KUNNR | Customer Number Of Plant | |
| VendorNumberOfPlant_LIFNR | Vendor Number Of Plant | |
| FactoryCalendarKey_FABKL | Factory Calendar Key | |
| Name2_NAME2 | Name2 | |
| StreetAndHouseNumber_STRAS | Street And House Number | |
| PoBox_PFACH | Po Box | |
| PostalCode_PSTLZ | Postal Code | |
| City_ORT01 | City | |
| PurchasingOrganization_EKORG | Purchasing Organization | |
| SalesOrganizationForIntercompanyBilling_VKORG | Sales Organization For Intercompany Billing | |
| Indicator_BatchStatusManagementActive_CHAZV | Indicator Batch Status Management Active | |
| Indicator_ConditionsAtPlantLevel_KKOWK | Indicator Conditions At Plant Level | |
| Indicator_SourceListRequirement_KORDB | Indicator Source List Requirement | |
| ActivatingRequirementsPlanning_BEDPL | Activating Requirements Planning | |
| CountryKey_LAND1 | Country Key | |
| Region_County__REGIO | Region County | |
| CountyCode_COUNC | County Code | |
| CityCode_CITYC | City Code | |
| Address_ADRNR | Address | |
| MaintenancePlanningPlant_IWERK | Maintenance Planning Plant | |
| TaxJurisdiction_TXJCD | Tax Jurisdiction | |
| DistributionChannelForIntercompanyBilling_VTWEG | Distribution Channel For Intercompany Billing | |
| DivisionForIntercompanyBilling_SPART | Division For Intercompany Billing | |
| Language_SPRAS | Language | |
| SopPlant_WKSOP | Sop Plant | |
| VarianceKey_AWSLS | Variance Key | |
| Indicator_BatchStatusManagementActive_CHAZV_OLD | Indicator Batch Status Management Active Old | |
| PlantCategory_VLFKZ | Plant Category | |
| SalesDistrict_BZIRK | Sales District | |
| SupplyRegion__regionSupplied___ZONE1 | Supply Region | |
| TaxIndicator_Plant__purchasing___TAXIW | Tax Indicator Plant Purchasing | |
| TakeRegularVendorIntoAccount_BZQHL | Take Regular Vendor Into Account | |
| NumberOfDaysForFirstReminderexpediter_LET01 | Number Of Days For First Reminderexpediter | |
| NumberOfDaysForSecondReminderexpediter_LET02 | Number Of Days For Second Reminderexpediter | |
| NumberOfDaysForThirdReminderexpediter_LET03 | Number Of Days For Third Reminderexpediter | |
| TextNameOf1stDunningOfVendorDeclarations_TXNAM_MA1 | Text Name Of 1st Dunning Of Vendor Declarations | |
| TextNameOfThe2ndDunningOfVendorDeclarations_TXNAM_MA2 | Text Name Of The 2nd Dunning Of Vendor Declarations | |
| TextNameOf3rdDunningOfVendorDeclarations_TXNAM_MA3 | Text Name Of 3rd Dunning Of Vendor Declarations | |
| NumberOfDaysForPoToleranceCompressInfoRecordsSu_BETOL | Number Of Days For Po Tolerance Compress Info Records Su | |
| BusinessPlace_J_1BBRANCH | Business Place | |
| RuleForDeterminingTheSalesAreaForStockTransfers_VTBFI | Rule For Determining The Sales Area For Stock Transfers | |
| DistributionProfileAtPlantLevel_FPRFW | Distribution Profile At Plant Level | |
| CentralArchivingMarkerForMasterRecord_ACHVM | Central Archiving Marker For Master Record | |
| BatchRecord_TypeOfDmsUsed_DVSART | Batch Record Type Of Dms Used | |
| NodeType_SupplyChainNetwork_NODETYPE | Node Type Supply Chain Network | |
| StructureForNameFormation_NSCHEMA | Structure For Name Formation | |
| CostObjectControllingLinkingActive_PKOSA | Cost Object Controlling Linking Active | |
| UpdatingIsActiveForMixedCosting_MISCH | Updating Is Active For Mixed Costing | |
| UpdatingIsActiveInActualCosting_MGVUPD | Updating Is Active In Actual Costing | |
| ShippingPointreceivingPoint_VSTEL | Shipping Pointreceiving Point | |
| UpdateOfActivityConsumptionInTheQuantityStructure_MGVLAUPD | Update Of Activity Consumption In The Quantity Structure | |
| ControlOfCreditOfCostCenters_MGVLAREVAL | Control Of Credit Of Cost Centers | |
| InvokeAddedFunctionSourceDeterminationViaAtp_SOURCING | Invoke Added Function Source Determination Via Atp | |
| StoreCategoryToDifferentiateStoreShop_STORETYPE | Store Category To Differentiate Store Shop | |
| SuperiorDepartmentStore_DEP_STORE | Superior Department Store |