HRV1222A

14 Fields 8 CDS Views

Generated Table for View

HRV1222A is an SAP database table in S/4HANA. Generated Table for View. It contains 14 fields. 8 CDS views read from this table.

CDS Views using this table (8)

ViewTypeJoinVDMDescription
I_CRMOrganizationDistrChnl view from BASIC Distribution Channels Downloaded from SD
I_CRMOrganizationDivision view from BASIC Divisions Downloaded from SD
I_CRMSalesOrganization view from BASIC Sales Organizations Downloaded from SD
I_SalesOrgUnitIDSalesOrgAssgmt view from BASIC Sales Org Assigned to Service and SD
I_ServiceOrganization view inner BASIC Service Organization
I_ServiceTeam view inner BASIC Service Team
I_SlsGrpOrgUnitIDSlsGrpAssgmt view from BASIC Sales Group Assigned to Service and SD
I_SlsOffcOrgUnitSlsOffcAssgmt view from BASIC Sales Office Assigned to Service and SD

Fields (14)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY plvar PLVAR Plan version
KEY otype OTYPE Object type
KEY objid HROBJID Object ID
KEY begda BEGDATUM Start date
KEY endda ENDDATUM End Date
KEY subty SUBTYP Subtype
KEY istat ISTAT_D Planning status
KEY attrib OM_ATTRIB Attribute
KEY low OM_ATTRVAL Value
KEY high OM_ATTRVTO Value to
KEY excluded OM_ATTREXC Excluded
KEY defaultval OM_ATTRDEF Default value
KEY inherited OM_ATTRREF Value inherited

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.

-- Generated Table for View
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE HRV1222A (
    MANDT,       -- Client [MANDT]
    PLVAR,       -- Plan version [PLVAR]
    OTYPE,       -- Object type [OTYPE]
    OBJID,       -- Object ID [HROBJID]
    BEGDA,       -- Start date [BEGDATUM]
    ENDDA,       -- End Date [ENDDATUM]
    SUBTY,       -- Subtype [SUBTYP]
    ISTAT,       -- Planning status [ISTAT_D]
    ATTRIB,      -- Attribute [OM_ATTRIB]
    LOW,         -- Value [OM_ATTRVAL]
    HIGH,        -- Value to [OM_ATTRVTO]
    EXCLUDED,    -- Excluded [OM_ATTREXC]
    DEFAULTVAL,  -- Default value [OM_ATTRDEF]
    INHERITED,   -- Value inherited [OM_ATTRREF]
    PRIMARY KEY (MANDT, PLVAR, OTYPE, OBJID, BEGDA, ENDDA, SUBTY, ISTAT, ATTRIB, LOW, HIGH, EXCLUDED, DEFAULTVAL, INHERITED)
);

Learn More