HRT1737
Table Section for Infotype 1737
HRT1737 is an SAP database table in S/4HANA. Table Section for Infotype 1737. It contains 19 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| PiqCds_ProgressionData | view | inner | Progression Data |
Fields (19)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | MANDT | Client | |||
| KEY | tabnr | HRTABNR | Reference no. | |||
| KEY | tabseqnr | HRTABSEQNR | Sequence number | |||
| progc_var | PIQPROGC_VAR | Program Type | ||||
| prog_type | PIQPROG_TYPE | Prog. Category | ||||
| valid_from | PIQPROG_GR_VALID_FROM | Valid From | ||||
| check_from | PIQPROG_GR_CHECK_FROM | Check-From Date | ||||
| check_to | PIQPROG_GR_CHECK_TO | Check-To Date | ||||
| processdocument | PIQPROC_DOCID | Acty Document ID | ||||
| acst | PIQPROG_GR_ACST | Academic Standing | ||||
| acstfa | PIQPROG_GR_ACSTFA | Acad. Standing FA | ||||
| prcl | PIQPROGCLASS | Progress Class. | ||||
| prclfa | PIQPROGCLASSFA | Progress Class. | ||||
| award | PIQPROG_GR_AWARD | Academic honors | ||||
| result_status | PIQPROG_GR_RESULT_STATUS | Result Status | ||||
| peryr | PIQPROG_GR_PERYR | Acad. Year | ||||
| perid | PIQPROG_GR_PERID | Acad. Session | ||||
| mc_valid_from | PIQPROG_GR_VALID_FROM | Valid From | ||||
| mc_valid_to | PIQPROG_GR_VALID_TO | Valid To |
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.
-- Table Section for Infotype 1737
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE HRT1737 (
MANDT, -- Client [MANDT]
TABNR, -- Reference no. [HRTABNR]
TABSEQNR, -- Sequence number [HRTABSEQNR]
PROGC_VAR, -- Program Type [PIQPROGC_VAR]
PROG_TYPE, -- Prog. Category [PIQPROG_TYPE]
VALID_FROM, -- Valid From [PIQPROG_GR_VALID_FROM]
CHECK_FROM, -- Check-From Date [PIQPROG_GR_CHECK_FROM]
CHECK_TO, -- Check-To Date [PIQPROG_GR_CHECK_TO]
PROCESSDOCUMENT, -- Acty Document ID [PIQPROC_DOCID]
ACST, -- Academic Standing [PIQPROG_GR_ACST]
ACSTFA, -- Acad. Standing FA [PIQPROG_GR_ACSTFA]
PRCL, -- Progress Class. [PIQPROGCLASS]
PRCLFA, -- Progress Class. [PIQPROGCLASSFA]
AWARD, -- Academic honors [PIQPROG_GR_AWARD]
RESULT_STATUS, -- Result Status [PIQPROG_GR_RESULT_STATUS]
PERYR, -- Acad. Year [PIQPROG_GR_PERYR]
PERID, -- Acad. Session [PIQPROG_GR_PERID]
MC_VALID_FROM, -- Valid From [PIQPROG_GR_VALID_FROM]
MC_VALID_TO, -- Valid To [PIQPROG_GR_VALID_TO]
PRIMARY KEY (MANDT, TABNR, TABSEQNR)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA