I_PLANT
Plant
I_PLANT is a CDS View in S/4HANA. Plant. It contains 16 fields. 115 CDS views read from this table.
CDS Views using this table (115)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| /VSCEW/A_Plant | view_entity | from | Plant | |
| /VSCEW/CC_Plant_VH | view_entity | from | Plant VH | |
| /VSCEW/I_MRPAreaStorageLoc | view_entity | inner | MRP Area Storage Location | |
| /VSCEW/I_MRPAreaSubcontractor | view_entity | inner | MRP Area Subcontractor | |
| A_BufferProfileDetails | view_entity | from | CONSUMPTION | Buffer Profile Details |
| A_DigitalVehiclePlant | view_entity | from | CONSUMPTION | Digital Vehicle Plant |
| A_ExciseTaxPlant | view | from | BASIC | Plant (for Excise Tax) |
| A_Plant | view | from | BASIC | API Plant |
| A_Plant_2 | view_entity | from | CONSUMPTION | Plant |
| A_ProfileAssgmtToPlant | view_entity | from | CONSUMPTION | Buffer Profile Assigned to Plant |
| C_ChgMgmtPlantVH | view | from | CONSUMPTION | Change Management Plant Value Help |
| C_CmmdtyHdgPlnExposurePlantVH | view | from | CONSUMPTION | Commodity Hedge Plan Exposure Plant |
| C_Distributioncentervh | view | from | CONSUMPTION | Consumption-Dist Center Value Help |
| C_FixedAssetOvwPlntPurgOrgVH | view | from | CONSUMPTION | Plant Purchasing Organization Value Help |
| C_MasterRecipePlantVH | view_entity | from | CONSUMPTION | Master Recipe Plant |
| C_MaterialPlantMalfuncManageVH | view | from | CONSUMPTION | Material Plant |
| C_MM_PlantBasicValueHelp | view | from | CONSUMPTION | Basic Value Help for Plants |
| C_MM_PlantValueHelp | view | from | CONSUMPTION | Plant Value Help |
| C_ModProdSpecItemPlantVH | view_entity | from | CONSUMPTION | Model Product Specification Item Plants |
| C_PhysInvtryProposal | view_entity | inner | CONSUMPTION | Proposals for new PI counts |
| C_Plantvaluehelp | view_entity | from | CONSUMPTION | Plant Value Help for QM |
| C_PlantVH | view | from | CONSUMPTION | Consumption-Plant Value Help |
| C_ProcmtMassUpdtPlantVH | view | from | CONSUMPTION | Procurement Plant Value Help |
| C_ProjSrvcOrgPlantVH | view_entity | from | CONSUMPTION | Select Plant |
| C_PurOrdMaintainPlantValHelp | view | from | CONSUMPTION | PO Maintenance: Value Help for Plant |
| C_PurOrdMaintainUoMValHelp | view | left_outer | CONSUMPTION | Value Help Unit of measure |
| C_RecipeFinderPlantValueHelp | view | from | CONSUMPTION | Recipe Finder Plant Value Help |
| C_ResvnDocPlantByCoCodeVH | view | from | CONSUMPTION | Plant by Company Code Value Help |
| C_SASAction | view | inner | CONSUMPTION | Shop Floor Item At Operation Activity |
| C_StkSubscrpnPlntByCoCodeVH | view_entity | from | CONSUMPTION | List of plants by company code |
| C_Storevh | view | from | CONSUMPTION | Consumption-Store Value Help |
| C_SupDmndOpenDelivQuery | view | left_outer | CONSUMPTION | Query View for Total Demand |
| C_SupDmndOvwDmndItmQuery | view | left_outer | CONSUMPTION | Query View for Total Demand |
| C_SupDmndOvwSupAssgmtQuery | view | left_outer | CONSUMPTION | Consumption view for Assignments |
| C_SupDmndOvwTotDmndQuery | view | left_outer | CONSUMPTION | Query View for Total Demand |
| C_SupDmndOvwTotSupQuery | view | left_outer | CONSUMPTION | Query View for Total Supply |
| C_SupDmndTotSlsOrdQuery | view | left_outer | CONSUMPTION | Query View for Total Demand |
| C_SupDmndTotSTOQuery | view | left_outer | CONSUMPTION | Query View for Total Demand |
| C_SustPlantAddressDEX | view | from | CONSUMPTION | Plant Address data extractor |
| C_WrkCtrMntrNonWorkingDays | view_entity | from | CONSUMPTION | Non Working Days On Factory Calendar |
| C_WrntyPlantValueHelp | view_entity | from | CONSUMPTION | Value Help for Warranty Claim Plant |
| CIC_PlantAddress | view_entity | inner | Proj. view on Plant address | |
| FAC_AUDIT_Z3_Plant | view | from | Plant | |
| FAC_PLANTVH | view | from | Value help for plant | |
| finoc_rt_mat_fill | view | inner | Orgl Change: Fill Runtime for Material | |
| FPCV_AI_VAL_VAR_PLANT | view_entity | left_outer | Valuation Variant per Plant | |
| I_CnsldtnMasterData | view | union_all | COMPOSITE | Consolidation - Combined Master Data |
| I_CustomerCompanyByPlant | view_entity | from | COMPOSITE | Customer Company by Plant |
| I_DistributionChainCountry | view | inner | COMPOSITE | Distribution Chain Country/Region |
| I_FixedAssetOvwPlantVH | view | from | BASIC | Plant by Company Code Value Help |
| I_FldLogsPlntPerCustSlsArea | view_entity | inner | BASIC | Plant wise Customer Sales Area |
| I_IN_PlantBusinessPlaceDetail | view_entity | from | COMPOSITE | GST India Business Place for Plant |
| I_InternalOrderPlantVH | view | from | COMPOSITE | Internal Order Plant |
| I_JITPlant | view_entity | from | BASIC | JIT Plant |
| I_KanbanContainerVH | view | inner | COMPOSITE | Kanban Container Value Help |
| I_LoglProdAssgmtSuplrToStore | view | left_outer | COMPOSITE | Logistical Product Supplier Store Assgmt |
| I_LoglProdAssgmtSupplierToDC | view | left_outer | COMPOSITE | Logistical Product Supplier DC Assgmt |
| I_ManufacturingFeatureStatus | view | from | BASIC | Manufacturing Feature Status |
| I_PhysInvtryMatValnTypeVH | view_entity | inner | COMPOSITE | Material Valuation Type |
| I_PlantAddressVH | view_entity | from | BASIC | Plant by Address |
| I_PlantCompanyCodeCurrency | view | from | COMPOSITE | Plant company code currency |
| I_PlantVH | view_entity | from | COMPOSITE | Plants |
| I_ProdEWMPartyToDispose | view | inner | BASIC | Basic View - Entitled to Dispose |
| I_ProdPlantPurchaseTax | view | inner | COMPOSITE | Composite View - Prod Plant Purchase Tax |
| I_PT_SelfBillgCustAddrVers | view | inner | COMPOSITE | PT Self-Billing CustAddr Version |
| I_QltyMgmtPlantCostCenterVH | view | inner | COMPOSITE | Cost Center By Plant |
| I_Site | view | from | BASIC | Retail Site |
| I_SupDmndOvwAssgmtCube | view | left_outer | COMPOSITE | Supply Demand Overview Cube View(MDR) |
| I_SupDmndOvwCube | view | left_outer | COMPOSITE | Supply Demand Overview Cube View |
| I_SupplierCompanyByPlant | view_entity | from | COMPOSITE | Supplier Company by Plant |
| I_SVTPlant | view_entity | from | COMPOSITE | Substance Volume Tracking Plant |
| P_AssgblDCForSuplr | view | cross | CONSUMPTION | Assignable DC for Supplier Value Help |
| P_AssgblStoreForProcmtProdExt | view | cross | CONSUMPTION | Assignable Store for Prod (Ext) Val Help |
| P_AssgblStoreForProcmtProdInt | view | cross | CONSUMPTION | Assignable Store for Prod (Int) Val Help |
| P_AssgblSuplrForProcmtProd | view | left_outer | CONSUMPTION | Assgbl Suplr for Procmt Prod Value Help |
| P_BOOPlantControllingArea | view_entity | from | COMPOSITE | Bill of Operations Plant Controlling Area |
| P_CnsldtnPlant | view | from | COMPOSITE | Consolidation Combined Plant |
| P_CnsldtnPlantT | view | from | COMPOSITE | Consolidation Combined Plant - Text |
| P_DMVCCompanyCodeByPlant | view | from | COMPOSITE | DMVC: Company Code by Plant |
| P_DMVCMaterialActivity | view | inner | COMPOSITE | DMVC: Material Activity |
| P_JP_GRBASEDGRLIST | view | inner | COMPOSITE | Goods Receipt Document List(GR Based ) |
| P_JP_POBASEDGRLIST | view | inner | COMPOSITE | Goods Receipt Document List(PO Based ) |
| P_MaterialValuationCategory | view_entity | inner | COMPOSITE | Valuation Category of a Material and Plant |
| P_MaterialValuationTypesVH | view_entity | inner | COMPOSITE | Valuation category by material plant |
| P_MatlDocPlntAuthzn | view | from | COMPOSITE | Read Plants for F4 Help |
| P_MfgProcgExecBatchPlant | view | cross | COMPOSITE | Batches in Plants for Component Assembly |
| P_MfgProcgExecNonAssySrlNmbr | view | cross | COMPOSITE | Manufacturing Processing Execution Serial Number |
| P_MMIM_PLANT_M_BEST_WRK_01 | view | from | COMPOSITE | Plants with authority M_BEST_WRK activity 01 |
| P_MMIM_PLANT_M_MSEG_WWA_01 | view | from | COMPOSITE | Plants with authority M_MSEG_WWA activity 01 |
| P_NightSplitForShift | view | from | COMPOSITE | Work Center Night Split |
| P_NightSplitForShift | view | union | COMPOSITE | Work Center Night Split |
| P_NonVrsEngBOMAcrsAllProdnPlnt | view | cross | COMPOSITE | Non Version Controlled Eng BOM Across All Production Plants |
| P_OrderFulfillmentRespyFC | view | from | COMPOSITE | Order Fulfillment Responsibility Field Catalog |
| P_PhysInvtryKeyFiguresBase | view_entity | inner | COMPOSITE | Basis for the calc. of PI Key Figures for a Stock Sep. Comb. |
| P_PhysInvtryKeyFiguresBaseSitn | view_entity | inner | COMPOSITE | Basis for calc. of PI Key Figur. for Stck Sep. Comb. Situat. |
| P_PhysInvtryProposal | view_entity | inner | CONSUMPTION | Proposals for new PI documents |
| P_Plant_Fs | view | left_outer | BASIC | Priavte Factsheet - Plant |
| P_PlantValuationArea | view | from | COMPOSITE | Temporary view for valuation area and company code of plant |
| P_ProdCmplncPlant | view_entity | from | COMPOSITE | Substance Volume Tracking Plants |
| P_ProdCmplncStorLoc | view_entity | union | COMPOSITE | Product Complliance Storage Location with Fallback |
| P_ProdnSupvrPlantList | view_entity | union | COMPOSITE | Prodn Supvr Plant List |
| P_ProfileAssgmtToPlant | view_entity | from | CONSUMPTION | Profile Assignment To Plant |
| P_PurOrdMaintainItemActAddr | view | left_outer | CONSUMPTION | PO Maintenance: Purchase Order Item Address (Active) |
| P_PurOrdMaintainItemActCalcPrc | view | left_outer | CONSUMPTION | PO Maintenance: PO Item Calculation Procedures (Active) |
| P_Qm_Headerwithoperations | view | left_outer | BASIC | Private CDS - QALS with V_QAPO |
| P_QMQLTYINROCIDGEN | view_entity | from | COMPOSITE | Quality In Proc Generation |
| P_RSHRelationshipSplit | view | from | BASIC | Relationship Split |
| P_RSHRelationshipSplit | view | union | BASIC | Relationship Split |
| P_RSHWCNightSplit | view | from | CONSUMPTION | Two lines to split the night shifts |
| P_RSHWCNightSplit | view | union | CONSUMPTION | Two lines to split the night shifts |
| P_SLLMINMAXRELEVANTPOITEMS | view | inner | COMPOSITE | PO history for min and max order price determination |
| P_Supplier_Fs | view | left_outer | BASIC | Private Factsheet - Supplier |
| P_TaxConfigurationPlant | view_entity | inner | COMPOSITE | Plant related field values |
| P_VersEngBOMAcrossAllProdnPlnt | view | cross | COMPOSITE | Version Controlled Eng BOM Across All Production Plants |
| P_WrkCtrPersnRespAORList | view_entity | union | COMPOSITE | Work Center Person Responsible AOR List |
Fields (16)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | AddressID | AddressID | 3 |
| KEY | DistributionChannel | DistributionChannel | 2 |
| KEY | Division | Division | 2 |
| KEY | Plant | DistributionCenter,Plant,Store | 38 |
| KEY | PlantCustomer | PlantCustomer | 3 |
| KEY | SalesOrganization | SalesOrganization | 3 |
| _Customer | _Customer | 2 | |
| _Supplier | _Supplier | 1 | |
| _ValuationArea | _ValuationArea | 1 | |
| BusinessPlace | BusinessPlace | 1 | |
| DefaultPurchasingOrganization | DefaultPurchasingOrganization | 1 | |
| Language | Language,PlantLanguage | 2 | |
| PlantCategory | PlantCategory | 5 | |
| PlantName | name1,PlantName,StoreName | 32 | |
| PlantSupplier | PlantSupplier | 2 | |
| ValuationArea | ValuationArea | 4 |
Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.
-- Plant
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_PLANT (
ADDRESSID,
DISTRIBUTIONCHANNEL,
DIVISION,
PLANT,
PLANTCUSTOMER,
SALESORGANIZATION,
_CUSTOMER,
_SUPPLIER,
_VALUATIONAREA,
BUSINESSPLACE,
DEFAULTPURCHASINGORGANIZATION,
LANGUAGE,
PLANTCATEGORY,
PLANTNAME,
PLANTSUPPLIER,
VALUATIONAREA,
PRIMARY KEY (ADDRESSID, DISTRIBUTIONCHANNEL, DIVISION, PLANT, PLANTCUSTOMER, SALESORGANIZATION)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA