SAP ABAP View U_37175C (Course participation - billing specification)
Hierarchy
☛
EA-HRGXX (Software Component) Sub component EA-HRGXX of EA-HR
⤷ PE-LSO-TM (Application Component) Training Management
⤷ LSO_DATAMODEL (Package) SAP Learning Solution - Data Model
⤷ PE-LSO-TM (Application Component) Training Management
⤷ LSO_DATAMODEL (Package) SAP Learning Solution - Data Model
Basic Data
View Type | D | Database View |
Database View | U_37175C | |
Short Description | Course participation - billing specification | |
Root table | PLOGI | Table Index HRP* |
Entity Type | DM02L |
Short text | Course participation - billing specification |
Table
# | Table Name | Foreign Table | Foreign Field | Foreign DIR |
---|---|---|---|---|
1 | PLOGI | PLOGI | ||
2 | HRP1001 | |||
3 | HRIADATANR | |||
4 | T77REFDOC | |||
5 | HRPAD614 |
Join Conditions
# | Table Name | Field Name | Negation | Operator | Constants | Cont. line | AND/OR | Offset | F Length | Mco Field |
---|---|---|---|---|---|---|---|---|---|---|
1 | PLOGI | MANDT | JL | EQ | 0 | 0 | ||||
2 | HRP1001 | MANDT | JR | EQ | AND | 0 | 0 | |||
3 | PLOGI | PLVAR | JL | EQ | 0 | 0 | ||||
4 | HRP1001 | PLVAR | JR | EQ | AND | 0 | 0 | |||
5 | PLOGI | OTYPE | JL | EQ | 0 | 0 | ||||
6 | HRP1001 | OTYPE | JR | EQ | AND | 0 | 0 | |||
7 | PLOGI | OBJID | JL | EQ | 0 | 0 | ||||
8 | HRP1001 | OBJID | JR | EQ | AND | 0 | 0 | |||
9 | PLOGI | MANDT | JL | EQ | 0 | 0 | ||||
10 | HRIADATANR | MANDT | JR | EQ | AND | 0 | 0 | |||
11 | PLOGI | MANDT | JL | EQ | 0 | 0 | ||||
12 | T77REFDOC | MANDT | JR | EQ | AND | 0 | 0 | |||
13 | HRIADATANR | MANDT | JL | EQ | 0 | 0 | ||||
14 | HRP1001 | MANDT | JR | EQ | AND | 0 | 0 | |||
15 | HRIADATANR | ADATANR | JL | EQ | 0 | 0 | ||||
16 | HRP1001 | ADATANR | JR | EQ | AND | 0 | 0 | |||
17 | PLOGI | MANDT | JL | EQ | 0 | 0 | ||||
18 | HRPAD614 | MANDT | JR | EQ | AND | 0 | 0 | |||
19 | HRIADATANR | MANDT | JL | EQ | 0 | 0 | ||||
20 | HRPAD614 | MANDT | JR | EQ | AND | 0 | 0 | |||
21 | HRIADATANR | ADATANR | JL | EQ | 0 | 0 | ||||
22 | HRPAD614 | ADATANR | JR | EQ | AND | 0 | 0 | |||
23 | HRPAD614 | REFDOCNO | JL | EQ | 0 | 0 | ||||
24 | T77REFDOC | REFDOCNO | JR | EQ | AND | 0 | 0 | |||
25 | HRPAD614 | REFDOCITEM | JL | EQ | 0 | 0 | ||||
26 | T77REFDOC | REFDOCITEM | JR | EQ | AND | 0 | 0 | |||
27 | PLOGI | OTYPE | EQ | 'E' | OR | 0 | 0 | |||
28 | PLOGI | OTYPE | EQ | 'ET' | OR | 0 | 0 | |||
29 | PLOGI | OTYPE | EQ | 'EC' | AND | 0 | 0 | |||
30 | HRP1001 | SUBTY | EQ | 'A614' | OR | 0 | 0 | |||
31 | HRP1001 | SUBTY | EQ | 'A025' | OR | 0 | 0 | |||
32 | HRP1001 | SUBTY | EQ | 'A040' | AND | 0 | 0 | |||
33 | T77REFDOC | EVENT | EQ | 'F' | OR | 0 | 0 | |||
34 | T77REFDOC | EVENT | EQ | 'G' | 0 | 0 | ||||
View Fields
# | View field | Table | Field | Maintenance Flag | Key | Data element | Mod | Short Description |
---|---|---|---|---|---|---|---|---|
1 | MANDT | PLOGI | MANDT | MANDT | Client | |||
2 | PLVAR | PLOGI | PLVAR | PLVAR | Plan Version | |||
3 | OTYPE | PLOGI | OTYPE | OTYPE | Object Type | |||
4 | OBJID | PLOGI | OBJID | HROBJID | Object ID | |||
5 | RSIGN | HRP1001 | RSIGN | RSIGN | Relationship Specification | |||
6 | RELAT | HRP1001 | RELAT | RELAT | Relationship Between Objects | |||
7 | ISTAT | HRP1001 | ISTAT | ISTAT_D | Planning Status | |||
8 | PRIOX | HRP1001 | PRIOX | PRIOX | Priority | |||
9 | BEGDA | HRP1001 | BEGDA | BEGDATUM | Start Date | |||
10 | ENDDA | HRP1001 | ENDDA | ENDDATUM | End Date | |||
11 | VARYF | HRP1001 | VARYF | VARYF | Variation Field for File PLOG | |||
12 | SEQNR | HRP1001 | SEQNR | SEQNR | Number of Infotype Record With Same Key | |||
13 | SCLAS | HRP1001 | SCLAS | SCLAS | Type of Related Object | |||
14 | SOBID | HRP1001 | SOBID | SOBID | ID of Related Object | |||
15 | ADATANR | HRP1001 | ADATANR | HRADATANR | ADATA Number | |||
16 | REFDOCNO | T77REFDOC | REFDOCNO | HRV_REFDOC | Reference Document | |||
17 | REFDOCITEM | T77REFDOC | REFDOCITEM | HRV_REFDOCITEM | Reference Document Item | |||
18 | REFDOCSEQNR | T77REFDOC | REFDOCSEQNR | SQNUR | Sequence Number | |||
19 | DOCDATE | T77REFDOC | DOCDATE | CO_BLDAT | Document Date | |||
20 | POSTINGDATE | T77REFDOC | POSTINGDATE | CO_BUDAT | Posting Date | |||
21 | DOCUNAME | T77REFDOC | DOCUNAME | UNAME | User Name | |||
22 | EVENT | T77REFDOC | EVENT | HRV_EVENT | Document Operation | |||
23 | STATUS | T77REFDOC | STATUS | HRV_STATUS | Status of Document Operation | |||
24 | DOCUMENT | T77REFDOC | DOCUMENT | PBELNR | Document number | |||
25 | PRICE | T77REFDOC | PRICE | HRVPRICE | Amount | |||
26 | CURRENCY | T77REFDOC | CURRENCY | WAERS | Currency Key | |||
27 | QUANTITY | T77REFDOC | QUANTITY | MBGXXX | Total quantity entered | |||
28 | UNIT | T77REFDOC | UNIT | MEINB | Posted Unit of Measure | |||
29 | NETPRICE | T77REFDOC | NETPRICE | NETKOST | Net value of attendance fees | |||
30 | TAXPRICE | T77REFDOC | TAXPRICE | TAXKOST | Tax amount for attendance fees | |||
31 | BUNIT | T77REFDOC | BUNIT | BUNIT | Reference unit | |||
32 | BZGME | T77REFDOC | BZGME | BZGME | Time Unit | |||
33 | CONTROLLINGAREA | T77REFDOC | CONTROLLINGAREA | KOKRS | Controlling Area | |||
34 | SCOSTCENTER | T77REFDOC | SCOSTCENTER | SKOST | Sender cost center | |||
35 | SOLD_TO | T77REFDOC | SOLD_TO | KUNAG | Sold-to party | |||
36 | BILL_TO | T77REFDOC | BILL_TO | KUNRE | Bill-to party | |||
37 | PAYER | T77REFDOC | PAYER | KUNRG | Payer | |||
38 | SHIP_TO | T77REFDOC | SHIP_TO | KUNWE | Ship-to party | |||
39 | PURCHORDER | T77REFDOC | PURCHORDER | BSTKD | Customer purchase order number | |||
40 | DATESTAMP | T77REFDOC | DATESTAMP | HRV_DATESTAMP | Date activity was last executed | |||
41 | TIMESTAMP | T77REFDOC | TIMESTAMP | HRV_TIMESTAMP | Time activity was last executed | |||
42 | PREVREFDOC | T77REFDOC | PREVREFDOC | HRV_PREVREFDOC | Preceding document | |||
43 | PERCENTAGE | T77REFDOC | PERCENTAGE | HRV_PERCENTAGE | Percentage rate for cost distribution | |||
44 | NETTAX_CURRENCY | T77REFDOC | NETTAX_CURRENCY | WAERS | Currency Key | |||
45 | PAY_STATUS | T77REFDOC | PAY_STATUS | HRV_PAY_STATUS | Payment Status Billing | |||
46 | CC_TYPE | T77REFDOC | CC_TYPE | CCINS | Payment cards: Card type | |||
47 | CC_NUMBER | T77REFDOC | CC_NUMBER | CCNUM | Payment cards: Card number | |||
48 | CC_VALID_TO | T77REFDOC | CC_VALID_TO | DATBI_CC | Payment Cards: Valid To | |||
49 | CC_NAME | T77REFDOC | CC_NAME | CCNAME | Payment Cards: Name of Cardholder | |||
50 | CC_NUMBER_CHECK | T77REFDOC | CC_NUMBER_CHECK | HRV_CC_NUMBER_CHECK | Payment Cards: Credit Card Check (Number) | |||
51 | CC_AUTH_DATE | T77REFDOC | CC_AUTH_DATE | AUDAT_CC | Payment cards: Authorization date | |||
52 | CC_AUTH_TIME | T77REFDOC | CC_AUTH_TIME | AUTIM | Payment cards: Authorization time | |||
53 | CC_AUTH_STATUS | T77REFDOC | CC_AUTH_STATUS | HRV_CC_AUTH_STATUS | Payment Cards: Authorization Status | |||
54 | CC_AUTH_NO | T77REFDOC | CC_AUTH_NO | AUNUM | Payment cards: Authorization number | |||
55 | CC_AUTH_VALIDITY | T77REFDOC | CC_AUTH_VALIDITY | TGVAL | Payment cards: Authorization validity period | |||
56 | CC_AUTH_REFNO | T77REFDOC | CC_AUTH_REFNO | AUTRA | Payment cards: Authoriz. reference code of clearing house | |||
57 | CC_AUTH_REFSTAT | T77REFDOC | CC_AUTH_REFSTAT | CCALL | Payment cards: Status when external system is called? | |||
58 | INTEX | HRPAD614 | INTEX | INTEX | Indicator for internal/external bus.event costs transferred | |||
59 | KKOST | HRPAD614 | KKOST | KKOST | Attendance or cancellation fee | |||
60 | KWAER | HRPAD614 | KWAER | EXWAER | Currency key for fees | |||
Maintenance Status
read only |
read and change |
Time-dependent views: like U, validity data like ' ' |
read, change, delete and insert |
Delivery Class | ||
Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in | 100 |