SAP ABAP View U_27707 (Business Event Attendance - Billing Specification)
Hierarchy
☛
SAP_HRGXX (Software Component) Sub component SAP_HRGXX of SAP_HR
⤷ PE (Application Component) Training and Event Management
⤷ PP09 (Package) Training and Event Management
⤷ PE (Application Component) Training and Event Management
⤷ PP09 (Package) Training and Event Management
Basic Data
View Type | D | Database View |
Database View | U_27707 | |
Short Description | Business Event Attendance - Billing Specification | |
Root table | PLOGI | Table Index HRP* |
Entity Type | DM02L |
Short text | Business event attendance - billing specification |
Table
# | Table Name | Foreign Table | Foreign Field | Foreign DIR |
---|---|---|---|---|
1 | PLOGI | PLOGI | ||
2 | HRP1001 | |||
3 | HRIADATANR | |||
4 | HRPAD25 | |||
5 | T77REFDOC |
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 | T77REFDOC | MANDT | JR | EQ | AND | 0 | 0 | |||
11 | HRIADATANR | MANDT | JL | EQ | 0 | 0 | ||||
12 | HRP1001 | MANDT | JR | EQ | AND | 0 | 0 | |||
13 | HRIADATANR | ADATANR | JL | EQ | 0 | 0 | ||||
14 | HRP1001 | ADATANR | JR | EQ | AND | 0 | 0 | |||
15 | HRPAD25 | REFDOCNO | JL | EQ | 0 | 0 | ||||
16 | T77REFDOC | REFDOCNO | JR | EQ | AND | 0 | 0 | |||
17 | HRPAD25 | REFDOCITEM | JL | EQ | 0 | 0 | ||||
18 | T77REFDOC | REFDOCITEM | JR | EQ | AND | 0 | 0 | |||
19 | HRIADATANR | ADATANR | JL | EQ | 0 | 0 | ||||
20 | HRPAD25 | ADATANR | JR | EQ | AND | 0 | 0 | |||
21 | HRIADATANR | MANDT | JL | EQ | 0 | 0 | ||||
22 | HRPAD25 | MANDT | JR | EQ | AND | 0 | 0 | |||
23 | PLOGI | OTYPE | EQ | 'E' | AND | 0 | 0 | |||
24 | HRP1001 | SUBTY | EQ | 'A025' | AND | 0 | 0 | |||
25 | T77REFDOC | EVENT | EQ | 'F' | OR | 0 | 0 | |||
26 | 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 | BEGDA | HRP1001 | BEGDA | BEGDATUM | Start Date | |||
8 | ENDDA | HRP1001 | ENDDA | ENDDATUM | End Date | |||
9 | VARYF | HRP1001 | VARYF | VARYF | Variation Field for File PLOG | |||
10 | SEQNR | HRP1001 | SEQNR | SEQNR | Number of Infotype Record With Same Key | |||
11 | SCLAS | HRP1001 | SCLAS | SCLAS | Type of Related Object | |||
12 | SOBID | HRP1001 | SOBID | SOBID | ID of Related Object | |||
13 | ADATANR | HRP1001 | ADATANR | HRADATANR | ADATA Number | |||
14 | INTEX | HRPAD25 | INTEX | INTEX | Indicator for internal/external bus.event costs transferred | |||
15 | KKOST | HRPAD25 | KKOST | KKOST | Attendance or cancellation fee | |||
16 | KWAER | HRPAD25 | KWAER | EXWAER | Currency key for fees | |||
17 | REFDOCNO | T77REFDOC | REFDOCNO | HRV_REFDOC | Reference Document | |||
18 | REFDOCITEM | T77REFDOC | REFDOCITEM | HRV_REFDOCITEM | Reference Document Item | |||
19 | REFDOCSEQNR | T77REFDOC | REFDOCSEQNR | SQNUR | Sequence Number | |||
20 | DOCDATE | T77REFDOC | DOCDATE | CO_BLDAT | Document Date | |||
21 | POSTINGDATE | T77REFDOC | POSTINGDATE | CO_BUDAT | Posting Date | |||
22 | DOCUNAME | T77REFDOC | DOCUNAME | UNAME | User Name | |||
23 | EVENT | T77REFDOC | EVENT | HRV_EVENT | Document Operation | |||
24 | STATUS | T77REFDOC | STATUS | HRV_STATUS | Status of Document Operation | |||
25 | DOCUMENT | T77REFDOC | DOCUMENT | PBELNR | Document number | |||
26 | PRICE | T77REFDOC | PRICE | HRVPRICE | Amount | |||
27 | CURRENCY | T77REFDOC | CURRENCY | WAERS | Currency Key | |||
28 | QUANTITY | T77REFDOC | QUANTITY | MBGXXX | Total quantity entered | |||
29 | UNIT | T77REFDOC | UNIT | MEINB | Posted Unit of Measure | |||
30 | NETPRICE | T77REFDOC | NETPRICE | NETKOST | Net value of attendance fees | |||
31 | TAXPRICE | T77REFDOC | TAXPRICE | TAXKOST | Tax amount for attendance fees | |||
32 | BUNIT | T77REFDOC | BUNIT | BUNIT | Reference unit | |||
33 | BZGME | T77REFDOC | BZGME | BZGME | Time Unit | |||
34 | CONTROLLINGAREA | T77REFDOC | CONTROLLINGAREA | KOKRS | Controlling Area | |||
35 | SCOSTCENTER | T77REFDOC | SCOSTCENTER | SKOST | Sender cost center | |||
36 | SOLD_TO | T77REFDOC | SOLD_TO | KUNAG | Sold-to party | |||
37 | BILL_TO | T77REFDOC | BILL_TO | KUNRE | Bill-to party | |||
38 | PAYER | T77REFDOC | PAYER | KUNRG | Payer | |||
39 | SHIP_TO | T77REFDOC | SHIP_TO | KUNWE | Ship-to party | |||
40 | PURCHORDER | T77REFDOC | PURCHORDER | BSTKD | Customer purchase order number | |||
41 | DATESTAMP | T77REFDOC | DATESTAMP | HRV_DATESTAMP | Date activity was last executed | |||
42 | TIMESTAMP | T77REFDOC | TIMESTAMP | HRV_TIMESTAMP | Time activity was last executed | |||
43 | PREVREFDOC | T77REFDOC | PREVREFDOC | HRV_PREVREFDOC | Preceding document | |||
44 | PERCENTAGE | T77REFDOC | PERCENTAGE | HRV_PERCENTAGE | Percentage rate for cost distribution | |||
45 | NETTAX_CURRENCY | T77REFDOC | NETTAX_CURRENCY | WAERS | Currency Key | |||
46 | PAY_STATUS | T77REFDOC | PAY_STATUS | HRV_PAY_STATUS | Payment Status Billing | |||
47 | CC_TYPE | T77REFDOC | CC_TYPE | CCINS | Payment cards: Card type | |||
48 | CC_NUMBER | T77REFDOC | CC_NUMBER | CCNUM | Payment cards: Card number | |||
49 | CC_VALID_TO | T77REFDOC | CC_VALID_TO | DATBI_CC | Payment Cards: Valid To | |||
50 | CC_NAME | T77REFDOC | CC_NAME | CCNAME | Payment Cards: Name of Cardholder | |||
51 | CC_NUMBER_CHECK | T77REFDOC | CC_NUMBER_CHECK | HRV_CC_NUMBER_CHECK | Payment Cards: Credit Card Check (Number) | |||
52 | CC_AUTH_DATE | T77REFDOC | CC_AUTH_DATE | AUDAT_CC | Payment cards: Authorization date | |||
53 | CC_AUTH_TIME | T77REFDOC | CC_AUTH_TIME | AUTIM | Payment cards: Authorization time | |||
54 | CC_AUTH_STATUS | T77REFDOC | CC_AUTH_STATUS | HRV_CC_AUTH_STATUS | Payment Cards: Authorization Status | |||
55 | CC_AUTH_NO | T77REFDOC | CC_AUTH_NO | AUNUM | Payment cards: Authorization number | |||
56 | CC_AUTH_VALIDITY | T77REFDOC | CC_AUTH_VALIDITY | TGVAL | Payment cards: Authorization validity period | |||
57 | CC_AUTH_REFNO | T77REFDOC | CC_AUTH_REFNO | AUTRA | Payment cards: Authoriz. reference code of clearing house | |||
58 | CC_AUTH_REFSTAT | T77REFDOC | CC_AUTH_REFSTAT | CCALL | Payment cards: Status when external system is called? | |||
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 |