_PLANT

18 Fields

_PLANT is an SAP database table in S/4HANA. It contains 18 fields.

Fields (18)

KeyField CDS FieldsUsed in Views
KEY Plant Plant,PlntFilterAnlytlMod 37
KEY PlantCustomer Receiver 1
KEY ValuationArea ValuationArea 12
_Address _Address 4
ABCIndicator ConsumptionValueCategory 1
AddressID AddressID,PlantAddressID 12
Country Country 4
DefaultPurchasingOrganization DefaultPurchasingOrganization 1
DistributionChannel DistributionChannel 3
Division Division 4
FactoryCalendar FactoryCalendar 5
MRPType MRPType 1
PlantCategory PlantCategory 2
PlantName CustomerName,FrcElmntOrgProvisionsPlantName,MaintenancePlanningPlantName,MaintenancePlantName,MRPPlantName,plant_name,PlantName,ProductionPlant,ProductionPlantName,PURORDERITEMPLANT,SupplyingPlantName,SupplyingPlantText 547
PlantTimeZone PlantTimeZone 1
ProcmtHubPlantName ProcmtHubPlantName 1
PurchasingGroup PurchasingGroup 1
SalesOrganization SalesOrganization 5

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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE _PLANT (
    PLANT,
    PLANTCUSTOMER,
    VALUATIONAREA,
    _ADDRESS,
    ABCINDICATOR,
    ADDRESSID,
    COUNTRY,
    DEFAULTPURCHASINGORGANIZATION,
    DISTRIBUTIONCHANNEL,
    DIVISION,
    FACTORYCALENDAR,
    MRPTYPE,
    PLANTCATEGORY,
    PLANTNAME,
    PLANTTIMEZONE,
    PROCMTHUBPLANTNAME,
    PURCHASINGGROUP,
    SALESORGANIZATION,
    PRIMARY KEY (PLANT, PLANTCUSTOMER, VALUATIONAREA)
);

Learn More