SAP ABAP Table SEPM_SDDL_SO_J_A (Generated Table for View)
Basic Data
Table Category VIEW    General view structure 
General view structure SEPM_SDDL_SO_J_A   Table Relationship Diagram
Short Description Generated Table for View    
Delivery and Maintenance
Pool/cluster      
Delivery Class      
Data Browser/Table View Maintenance     Display/Maintenance Allowed with Restrictions 
Components
     
Field Key Data Element Domain Data
Type
Length Decimal
Places
Short Description Check
table
1 MANDT MANDT MANDT CLNT 3   0   Client T000
2 SALES_ORDER_ID SNWD_SO_ID D_EPM_ID CHAR 10   0   EPM: Sales Order Number  
3 TOTAL_GROSS_AMOUNT SNWD_TTL_GROSS_AMOUNT   CURR 15   2   EPM: Total Gross Amount  
4 TOTAL_NET_AMOUNT SNWD_TTL_NET_AMOUNT   CURR 15   2   EPM: Total Net Amount  
5 TOTAL_TAX_AMOUNT SNWD_TTL_TAX_AMOUNT   CURR 15   2   EPM: Total Tax Amount  
6 CREATED_BY SNWD_ID D_EPM_ID CHAR 10   0   EPM: Employee ID  
7 CHANGED_BY SNWD_ID D_EPM_ID CHAR 10   0   EPM: Employee ID  
8 CREATED_AT TIMESTAMPL TZNTSTMPL DEC 21   7   UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)  
9 CHANGED_AT TIMESTAMPL TZNTSTMPL DEC 21   7   UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)  
10 CURRENCY_CODE SNWD_CURR_CODE   CUKY 5   0   EPM: Currency Code  
11 DELIVERY_STATUS SNWD_SO_OR_STATUS_CODE D_SO_OR CHAR 1   0   EPM: Sales Order Ordering Status  
12 LIFECYCLE_STATUS SNWD_SO_LC_STATUS_CODE D_SO_LC CHAR 1   0   EPM: Sales Order Lifecycle Status  
13 BILLING_STATUS SNWD_SO_CF_STATUS_CODE D_SO_CF CHAR 1   0   EPM: Sales Order Confirmation Status  
14 CREATED_BY_LASTNAME SNWD_LAST_NAME D_CHAR_40 CHAR 40   0   EPM: Last Name  
15 CREATED_BY_FIRSTNAME SNWD_FIRST_NAME D_CHAR_40 CHAR 40   0   EPM: First Name  
16 BUYER_ID SNWD_PARTNER_ID D_EPM_ID CHAR 10   0   EPM: Business Partner ID  
17 BUYER_NAME SNWD_COMPANY_NAME TEXT80 CHAR 80   0   EPM: Company Name  
18 ORIGINAL_NOTE_LANGUAGE SPRAS SPRAS LANG 1   0   Language Key  
19 NOTE_LANGUAGE SPRAS SPRAS LANG 1   0   Language Key  
20 HEADER_NOTE_TEXT SNWD_DESC D_EPM_DESC CHAR 255   0   EPM: Text field for names and descriptions  
21 ITEM_POSITITION SNWD_SO_ITEM_POS D_EPM_ID CHAR 10   0   EPM: Sales Order Item Position  
22 ITEM_GROSS_AMMOUNT SNWD_TTL_GROSS_AMOUNT   CURR 15   2   EPM: Total Gross Amount  
23 ITEM_NET_AMMOUNT SNWD_TTL_NET_AMOUNT   CURR 15   2   EPM: Total Net Amount  
24 ITEM_TAX_AMMOUNT SNWD_TTL_TAX_AMOUNT   CURR 15   2   EPM: Total Tax Amount  
25 ITEM_PRODUCT_ID SNWD_PRODUCT_ID   CHAR 10   0   EPM: Product ID  
26 ITEM_QUANTITY SNWD_QUANTITY MENG13 QUAN 13   3   EPM: Quantity  
27 ITEM_QUANTITY_UNIT SNWD_QUANTITY_UNIT MEINS UNIT 3   0   EPM: Quantity Unit T006
28 ITEM_DELIVERY_DATE TIMESTAMPL TZNTSTMPL DEC 21   7   UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 SEPM_SDDL_SO_J_A ITEM_QUANTITY_UNIT T006 MSEHI 1 CN
2 SEPM_SDDL_SO_J_A MANDT T000 MANDT 1 CN
History
Last changed by/on DDIC  20141121 
SAP Release Created in