PLANT

13 Fields

PLANT is an SAP database table in S/4HANA. It contains 13 fields.

Fields (13)

KeyField CDS FieldsUsed in Views
KEY ext_locno LocationExternalID,Plant 4
KEY Plant Plant 2
KEY SrvcMgmtFSMRplctnRuleSqncNmbr SrvcMgmtFSMRplctnRuleSqncNmbr 1
KEY werks po_werks 2
AssignedOrganisation EngagementProjectPlant 1
ChgDocPrevValBasicSearch ProdAllocPlantBasicSearch 1
DistributionChannel DistributionChannel 1
name1 PlantName 1
PlantCategory PlantCategory 1
PlantName PlantName 2
PrepaymentAgrmtPlant PrepaymentAgrmtPlant 1
SalesOrganization SalesOrganization 1
ValuationArea ValuationArea 1

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 (
    EXT_LOCNO,
    PLANT,
    SRVCMGMTFSMRPLCTNRULESQNCNMBR,
    WERKS,
    ASSIGNEDORGANISATION,
    CHGDOCPREVVALBASICSEARCH,
    DISTRIBUTIONCHANNEL,
    NAME1,
    PLANTCATEGORY,
    PLANTNAME,
    PREPAYMENTAGRMTPLANT,
    SALESORGANIZATION,
    VALUATIONAREA,
    PRIMARY KEY (EXT_LOCNO, PLANT, SRVCMGMTFSMRPLCTNRULESQNCNMBR, WERKS)
);

Learn More