T77S0

Transparent Table Control Table (SAP+Cust)
4 Fields 29 CDS Views

System Table

T77S0 is an SAP database table in S/4HANA. System Table. It contains 4 fields. 29 CDS views read from this table.

CDS Views using this table (29)

ViewTypeJoinVDMDescription
I_CRMOrganizationDistrChnl view inner BASIC Distribution Channels Downloaded from SD
I_CRMOrganizationDivision view inner BASIC Divisions Downloaded from SD
I_CRMSalesOrganization view inner BASIC Sales Organizations Downloaded from SD
I_HCMSystemSetting view_entity from BASIC HCM System Setting
I_MfgHumRsceQualifnBP view inner BASIC Basic View for HR Qualification and business partner
I_MfgHumRsceQualifnRqdSkillLvl view inner BASIC Required Skill Level
I_MfgQualificationGroup view inner BASIC Display HR Qualification Group and its Catalog
I_OrganizationalUnitText view inner BASIC Table for Organizational Units with Text
I_OrgManagementPositionText view inner BASIC Table for Position with Text
I_PersonWorkAgrmtJobText view inner BASIC Person Work Agreement Jobs with Text
I_PersWrkAgrmtToPartner view inner BASIC Internal for HCM : Donot Use
I_PMPositionText view inner BASIC Position Text
I_SalesOrganizationUnit view inner BASIC Sales Organizational Unit
I_SalesOrganizationUnitText view inner BASIC Sales Organizational Unit - Text
I_SalesOrgUnitIDSalesOrgAssgmt view inner BASIC Sales Org Assigned to Service and SD
I_SlsGrpOrgUnitIDSlsGrpAssgmt view inner BASIC Sales Group Assigned to Service and SD
I_SlsOffcOrgUnitSlsOffcAssgmt view inner BASIC Sales Office Assigned to Service and SD
I_SrvcMgmtOrganizationUnit view inner BASIC Service Management Organizational Unit
I_SrvcMgmtOrganizationUnitText view inner BASIC Srvc Mgmt Organizational Unit - Text
I_SrvcMgmtOrgUnitAddress view_entity inner BASIC Service Org Unit Address
I_TranspOrganizationalUnit view inner BASIC Core View for Transportation OrgUnit
P_MfgQualification view inner BASIC
P_MfgQualificationGroupList view inner BASIC
P_O_PersWrkAgrmtToPartner view inner BASIC
P_PDRELATION view inner BASIC
P_PDRELATION_001 view inner BASIC
P_PersWrkAgrmtToPartner view inner BASIC
P_PMDepartmentResponsibleBasic view_entity inner BASIC
P_PMPositionResponsibleBasic view_entity inner BASIC

Fields (4)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY grpid GRPID Group name
KEY semid SEMID Semantic abbr.
gsval GSVAL Value sem.abbr.

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.

-- System Table
-- Category TRANSPARENT · Delivery class E
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE T77S0 (
    MANDT,  -- Client [MANDT]
    GRPID,  -- Group name [GRPID]
    SEMID,  -- Semantic abbr. [SEMID]
    GSVAL,  -- Value sem.abbr. [GSVAL]
    PRIMARY KEY (MANDT, GRPID, SEMID)
);

Learn More