FAC_AUDIT_Z3_Plant

Plant | view: FAC_DZWERKS | Extraction: Not supported | Component: DART (Data Retention Tool)
Tables used: T001KT001WADCPADRCT001TKA02T001W
Column Name Description
CompanyCode Company Code
Plant Plant
Column Name Description
Column Name Description
Column Name Description
Column Name Description
PlantCategory Plant category Show values
Column Name Description Domain name
SystemClient Client
name1 Plant Name TEXT30
name2 Name 2 TEXT40
StreetName Street TEXT60
HouseNumber House Number TEXT10
HouseNumberSupplementText House number supplement TEXT10
POBox PO Box CHAR10
CityName City TEXT40
District District TEXT40
PostalCode City postal code CHAR10
AddressID Address ADRNR
TaxJurisdiction Tax Jurisdiction AD_TXJCD
Master Data Relations Join Conditions
Country key
  • Client
  • Country/Region Key
  • FAC_AUDIT_Z3_PLANT.MANDT == T005.MANDT
  • FAC_AUDIT_Z3_PLANT.COUNTRY == T005.LAND1
Purchasing organization
  • Purchasing organization
  • Client
  • FAC_AUDIT_Z3_PLANT.DEFAULTPURCHASINGORGANIZATION == T024E.EKORG
  • FAC_AUDIT_Z3_PLANT.MANDT == T024E.MANDT
Region code
  • Client
  • Region (State, Province, County)
  • Country/Region Key
  • FAC_AUDIT_Z3_PLANT.MANDT == T005S.MANDT
  • FAC_AUDIT_Z3_PLANT.REGION == T005S.BLAND
  • FAC_AUDIT_Z3_PLANT.COUNTRY == T005S.LAND1
Sales Organization for Intercompany Billing
  • Sales Organization for Intercompany Billing
  • Client
  • FAC_AUDIT_Z3_PLANT.SALESORGANIZATION == TVKO.VKORG
  • FAC_AUDIT_Z3_PLANT.MANDT == TVKO.MANDT
Shipping Point / Receiving Point
  • Client
  • Shipping Point / Receiving Point
  • FAC_AUDIT_Z3_PLANT.MANDT == TVST.MANDT
  • FAC_AUDIT_Z3_PLANT.SHIPPINGPOINT == TVST.VSTEL
Tax Indicator: Plant (Purchasing)
  • Tax Indicator: Plant (Purchasing)
  • ?
  • Client
  • FAC_AUDIT_Z3_PLANT.TAXINDICATOR == TMKW1.TAXIW
  • FAC_AUDIT_Z3_PLANT.[column in domain "BELAND"] == TMKW1.LAND1
  • FAC_AUDIT_Z3_PLANT.MANDT == TMKW1.MANDT