_PERMITNUMBER

7 Fields

_PERMITNUMBER is an SAP database table in S/4HANA. It contains 7 fields.

Fields (7)

KeyField CDS FieldsUsed in Views
KEY CmplRqVersUUID CmplRqVersUUID 1
_ValAreaNode _ValAreaNode 1
CmplRqDomain CmplRqDomain 1
CmplRqVersValidToDate CmplRqVersValidToDate 2
EffectiveDate EffectiveDate 2
EHSCmplRqPermitLifecycle EHSCmplRqPermitLifecycle 1
EHSLocationUUID EHSLocationUUID 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 _PERMITNUMBER (
    CMPLRQVERSUUID,
    _VALAREANODE,
    CMPLRQDOMAIN,
    CMPLRQVERSVALIDTODATE,
    EFFECTIVEDATE,
    EHSCMPLRQPERMITLIFECYCLE,
    EHSLOCATIONUUID,
    PRIMARY KEY (CMPLRQVERSUUID)
);

Learn More