SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

Schema:
 Module:  Table: 
Column: 
Searchbeta 

icon of database logic symbol SAP  TABLESv1Made in Britain

Home | ERP 6.0  | LFSSTN
JDETables.com - the webs number one JD Edwards Table Definition reference

ERP 6.0: Top 10 requests

TableColumnsDescription
1TJKWE15IS-M/SD: WBZ, Order Data for Inbound Processing
2RSADMINC96Customizing Table General BW
3BBP_PD_XML8Table for Persistent Class CL_XML_PPF_BBP
4/OTX/RM_TELIB24Enterprise Library Server Settings
5UMV_TR1259Obsolete:Val.Driver Tree:Assign.Web Reports to Value Drivers
6FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
7/ISDFPS/CHVW_E34External Batch Where-Used List
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9FMARCPAR4Parallelization of FMARC_BATCH
10CEKRS5Movement type parameters for automatic ERS

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5INV1265A/R Invoice - Rows
6OJDT100Journal Entry
7OPCH386A/P Invoice
8OVTG52Tax Definition
9OPOR386Purchase Order
10JDT1124Journal Entry - Rows

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2ORCT154Incoming Payment
3OINV268A/R Invoice
4OVPM154Outgoing Payments
5OIVL77Whse Journal
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction
Financial Accounting :: Accounts Payable :: Basic Functions
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0LFSSTN751Sustainability details for VendorBasic Functions
SQL:  selectupdate insert create

Use the column checkboxes to build your query. Header columns sets/unsets all columns

SELECT MANDT, LIFNR, UUID, LIFNR_SUST_ID, CREATED_BY, CHANGED_BY, CREATED_ON, LAST_CHANGED_ON, VALIDITY_START, VALIDITY_END, AUDIT_AGENCY, AUDIT_CONDUCT_ON, SUPP_COC, SUPP_COC_DATE, SUST_REPORT, SUST_RPT_RATING, SUST_REPORT_DATE, DEL_FLAG, OVERALL_SCORE, TOT_RESP_SCORE, TOT_ENV_SCORE, TOT_ECO_SCORE, SOC_COMMENTS, SOC_PROC_SYS, HUMAN_RIGHTS, HEALTH_SAFETY, SOC_FINES, SOC_FINES_CURR, DISCRIMINATION, CHILD_LABOUR, FORCED_LABOUR, COL_BARGAINING, ANTI_CORRUPTION, WOMEN_OWNED, WOM_OWNED_EXP, MINORITY_OWNED, MIN_OWNED_EXP, ENV_COMMENTS, ENV_PROTECTION, ENV_INITIATIVES, ENV_TECHNOLOGY, ENV_PROC_SYS, ENV_FINES, ENV_FINES_CURR, TTL_ENR_CONS, TTL_ENR_CONS_UN, RENEWABLE_ENERGY, RENEW_ENERGY_UN, TTL_WATER_CONS, TTL_WATER_CON_UN, RECYCLED_WATER, RECYCL_WATER_UN, GHG_SCOPE1, GHG_SCOPE1_UN, GHG_SCOPE2, GHG_SCOPE2_UN, GHG_SCOPE3, GHG_SCOPE3_UN, WASTE_NON_HZD, WASTE_NON_HZD_UN, WASTE_HZD, WASTE_HZD_UNIT, WASTE_RECYCLED, WASTE_RECYCLD_UN, TOTAL_SPEND, TOTAL_SPEND_CURR, TOTAL_REVENUE, TOT_REVENUE_CURR, EMPLOYEE_COUNT, TOTAL_RISK, FINANCIAL_RISK, LOGISTICAL_RISK, QUALITY_RISK, POLITICAL_RISK, DUMMY_EEW_SSTN FROM LFSSTN
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2LIFNRAccount Number of Vendor or Creditornvarchar100CHAR(N' ')NoLFA1LIFNR Allow NULL? 
3UUIDSSTN UUIDnvarchar320CHAR(N' ')NoSSTN_UUID Allow NULL? 
4LIFNR_SUST_IDVendor Sustainability IDnvarchar120CHAR(N' ')Yes*LIFNR_SUST_ID Allow NULL? 
5CREATED_BYUser namenvarchar120CHAR(N' ')Yes*USNAM Allow NULL? 
6CHANGED_BYUser namenvarchar120CHAR(N' ')Yes*USNAM Allow NULL? 
7CREATED_ONDatenvarchar80DATS(N'00000000')YesDATUM Allow NULL? 
8LAST_CHANGED_ONDatenvarchar80DATS(N'00000000')YesDATUM Allow NULL? 
9VALIDITY_STARTValidity Start Datenvarchar80DATS(N'00000000')YesSSTN_VALIDITY_START_DATE Allow NULL? 
10VALIDITY_ENDValidity End Datenvarchar80DATS(N'00000000')YesSSTN_VALIDITY_END_DATE Allow NULL? 
11AUDIT_AGENCYAudit Agencynvarchar200CHAR(N' ')YesSSTN_AUDIT_AGENCY Allow NULL? 
12AUDIT_CONDUCT_ONAudit Datenvarchar80DATS(N'00000000')YesSSTN_AUDIT_CONDUCTED_ON Allow NULL? 
13SUPP_COCSupplier Code of Conduct Indicatorchar10CHAR(N' ')YesSSTN_SUPP_COC Allow NULL? 
14SUPP_COC_DATESupplier Code of Conduct Datenvarchar80DATS(N'00000000')YesSSTN_SUPP_COC_DATE Allow NULL? 
15SUST_REPORTSustainability Reporting Standardnvarchar500CHAR(N' ')YesSSTN_SUST_REPORT Allow NULL? 
16SUST_RPT_RATINGSustainability Reporting Standard Ratingtinyint30INT1((0))YesSSTN_REPORT_RATING
17SUST_REPORT_DATELast Publication Date of Sustainability Reportnvarchar80DATS(N'00000000')YesSSTN_SUST_REPORT_DATE Allow NULL? 
18DEL_FLAGCheckboxchar10CHAR(N' ')YesXFELD Allow NULL? 
19OVERALL_SCOREOverall Scoretinyint30INT1((0))YesSSTN_OVERALL_SCORE
20TOT_RESP_SCORESocial Responsibility Compliance Scoretinyint30INT1((0))YesSSTN_TOTAL_SOC_RESPONSIBILITY
21TOT_ENV_SCORETotal Environmental Compliance Scoretinyint30INT1((0))YesSSTN_TOTAL_ENVIRONMENTAL
22TOT_ECO_SCORETotal Economic Compliance Scoretinyint30INT1((0))YesSSTN_TOTAL_ECONOMIC
23SOC_COMMENTSCommentsnvarchar2550CHAR(N' ')YesSSTN_COMMENTS Allow NULL? 
24SOC_PROC_SYSSocial Compliance Regarding Processes and Systemschar10CHAR(N' ')YesSSTN_SOCIAL_PROCESSES_SYSTEMS Allow NULL? 
25HUMAN_RIGHTSHuman Rights Compliance Codechar10CHAR(N' ')YesSSTN_HUMAN_RIGHT Allow NULL? 
26HEALTH_SAFETYHealth and Safety Compliance Codechar10CHAR(N' ')YesSSTN_HEALTH_SAFETY Allow NULL? 
27SOC_FINESFines Paid for Non-Compliance with Social Standardsdecimal132CURR((0))YesSSTN_SOCIAL_FINE
28SOC_FINES_CURRCurrencynvarchar50CUKY(N' ')Yes*SSTN_SUPPLIER_CURRENCY Allow NULL? 
29DISCRIMINATIONNon-Discrimination Compliance Codechar10CHAR(N' ')YesSSTN_DISCRIMINATION Allow NULL? 
30CHILD_LABOURChild Labor Compliance Codechar10CHAR(N' ')YesSSTN_CHILD_LABOUR Allow NULL? 
31FORCED_LABOURForced Labor Compliance Codechar10CHAR(N' ')YesSSTN_FORCED_LABOUR Allow NULL? 
32COL_BARGAININGRight to Collective Bargaining Compliance Codechar10CHAR(N' ')YesSSTN_COLLECTIVE_BARGAINING Allow NULL? 
33ANTI_CORRUPTIONAnti-Corruption Compliance Codechar10CHAR(N' ')YesSSTN_ANTICORRUPTION Allow NULL? 
34WOMEN_OWNEDWomen-Owned Business (WBE-Certified)char10CHAR(N' ')YesSSTN_WOMEN_OWNED Allow NULL? 
35WOM_OWNED_EXPExpiration Date of a Certificate (WBE/MBE, for ex.)nvarchar80DATS(N'00000000')YesSSTN_CERTIFICATE_EXPIRE_DATE Allow NULL? 
36MINORITY_OWNEDMinority-Owned Business (MBE-Certified)char10CHAR(N' ')YesSSTN_MINORITY_OWNED Allow NULL? 
37MIN_OWNED_EXPExpiration Date of a Certificate (WBE/MBE, for ex.)nvarchar80DATS(N'00000000')YesSSTN_CERTIFICATE_EXPIRE_DATE Allow NULL? 
38ENV_COMMENTSCommentsnvarchar2550CHAR(N' ')YesSSTN_COMMENTS Allow NULL? 
39ENV_PROTECTIONEnvironmental Protection Compliance Codechar10CHAR(N' ')YesSSTN_ENVIRONMENT_PROTECTION Allow NULL? 
40ENV_INITIATIVESEnvironmental Initiatives Compliance Codechar10CHAR(N' ')YesSSTN_ENVIRONMENTAL_INITIATIVES Allow NULL? 
41ENV_TECHNOLOGYClean Technology Compliance Codechar10CHAR(N' ')YesSSTN_CLEAN_TECHNOLOGY Allow NULL? 
42ENV_PROC_SYSEnvironmental Compliance Regarding Processes and Systemschar10CHAR(N' ')YesSSTN_ENVIRON_PROCESSES_SYSTEMS Allow NULL? 
43ENV_FINESEnvironmental Finedecimal132CURR((0))YesSSTN_ENVIRONMENT_FINE
44ENV_FINES_CURRCurrencynvarchar50CUKY(N' ')Yes*SSTN_SUPPLIER_CURRENCY Allow NULL? 
45TTL_ENR_CONSTotal Energy Consumptiondecimal133QUAN((0))YesSSTN_TOTAL_ENERGY_CONSUMED
46TTL_ENR_CONS_UNTotal Energy Consumption Unitnvarchar30UNIT(N' ')YesT006SSTN_TOTAL_ENERGY_CONSUMED_UN Allow NULL? 
47RENEWABLE_ENERGYRenewable Energydecimal133QUAN((0))YesSSTN_RENEWABLE_ENERGY
48RENEW_ENERGY_UNRenewable Energy Unitnvarchar30UNIT(N' ')YesT006SSTN_RENEWABLE_ENERGY_UNIT Allow NULL? 
49TTL_WATER_CONSTotal Water Consumptiondecimal133QUAN((0))YesSSTN_WATER_CONSUMPTION
50TTL_WATER_CON_UNTotal Water Consumption Unitnvarchar30UNIT(N' ')YesT006SSTN_WATER_CONSUMPTION_UN Allow NULL? 
51RECYCLED_WATERAmount of Water Recycleddecimal133QUAN((0))YesSSTN_WATER_RECYCLED
52RECYCL_WATER_UNWater Recycled Unitnvarchar30UNIT(N' ')YesT006SSTN_WATER_RECYCLED_UN Allow NULL? 
53GHG_SCOPE1Direct Emissionsdecimal133QUAN((0))YesSSTN_GHG_SCOPE1
54GHG_SCOPE1_UNDirect Emissions Unitnvarchar30UNIT(N' ')YesT006SSTN_GHG_SCOPE1_UN Allow NULL? 
55GHG_SCOPE2Indirect Emissionsdecimal133QUAN((0))YesSSTN_GHG_SCOPE2
56GHG_SCOPE2_UNIndirect Emissions Unitnvarchar30UNIT(N' ')YesT006SSTN_GHG_SCOPE2_UN Allow NULL? 
57GHG_SCOPE3Third-Party Emissionsdecimal133QUAN((0))YesSSTN_GHG_SCOPE3
58GHG_SCOPE3_UNThird-Party Emissions Unitnvarchar30UNIT(N' ')YesT006SSTN_GHG_SCOPE3_UN Allow NULL? 
59WASTE_NON_HZDTotal Non-Hazardous Wastedecimal133QUAN((0))YesSSTN_WASTE_NON_HZD
60WASTE_NON_HZD_UNTotal Non-Hazardous Waste Unitnvarchar30UNIT(N' ')Yes*SSTN_WASTE_NON_HZD_UNIT Allow NULL? 
61WASTE_HZDTotal Hazardous Wastedecimal133QUAN((0))YesSSTN_WASTE_HZD
62WASTE_HZD_UNITTotal Hazardous Waste Unitnvarchar30UNIT(N' ')YesT006SSTN_WASTE_HZD_UNIT Allow NULL? 
63WASTE_RECYCLEDTotal Waste Recycleddecimal133QUAN((0))YesSSTN_WASTE_RECYCLED
64WASTE_RECYCLD_UNTotal Waste Recycled Unitnvarchar30UNIT(N' ')Yes*SSTN_WASTE_RECYCLED_UN Allow NULL? 
65TOTAL_SPENDTotal Spend with Supplierdecimal152CURR((0))YesSSTN_SUPPLIER_TOTAL_SPEND
66TOTAL_SPEND_CURRCurrencynvarchar50CUKY(N' ')Yes*SSTN_SUPPLIER_CURRENCY Allow NULL? 
67TOTAL_REVENUETotal Revenue of Supplierdecimal152CURR((0))YesSSTN_SUPPLIER_TOTAL_REVENUE
68TOT_REVENUE_CURRCurrencynvarchar50CUKY(N' ')Yes*SSTN_SUPPLIER_CURRENCY Allow NULL? 
69EMPLOYEE_COUNTNumber of Employeesnvarchar120NUMC(N'000000000000')YesSSTN_EMP_COUNT Allow NULL? 
70TOTAL_RISKTotal Supply Risk Codechar10CHAR(N' ')YesSSTN_TOTAL_SUPPLY_RISK Allow NULL? 
71FINANCIAL_RISKFinancial Supply Risk Codechar10CHAR(N' ')YesSSTN_FINANCIAL_SUPPLY_RISK Allow NULL? 
72LOGISTICAL_RISKLogistics Supply Risk Codechar10CHAR(N' ')YesSSTN_LOGISTICAL_SUPPLY_RISK Allow NULL? 
73QUALITY_RISKQuality Supply Risk Codechar10CHAR(N' ')YesSSTN_QUALITY_SUPPLY_RISK Allow NULL? 
74POLITICAL_RISKPolitical Supply Risk Codechar10CHAR(N' ')YesSSTN_POLITICAL_SUPPLY_RISK Allow NULL? 
75DUMMY_EEW_SSTNDummy function in length 1char10CHAR(N' ')YesDUMMY Allow NULL? 
NamePrimaryUniqueTypeColumns
LFSSTN~0YesYesCLUSTEREDUUID, LIFNR, MANDT

All references to SAP and SAP logo are trademarks of SAP AG in Germany, EU, USA and other territories.
No warranty is provided to data provided by this site. This website is not affiliated with, maintained, authorized, endorsed or sponsored by the SAP AG Company or any of its affiliates.
About :: Terms :: Privacy