본문 바로가기

Archive/ABAP

SAP ABAP FORCESEEK 힌트
Archive/ABAP 2023. 5. 3. SAP ABAP FORCESEEK 힌트 %_HINTS MSSQLNT 'TABLE &TABLE& INDEX([VBAK~0]), FORCESEEK' SAP ABAP & MS SQL 에서의 Index Seek 힌트인 FORCESEEK 적용 예시 How to integrate SQL Server specific hints in ABAP - Microsoft Community Hub How to integrate SQL Server specific hints in ABAP First published on MSDN on Aug 31, 2011 Working on a few Proof of Concepts this year where customers moved their SAP landscapes from Oracle or DB2 to SQL Serv..
Archive/ABAP 2020. 12. 19. SAP ERP MS SQL Database 의 sp_bindefault sp_bindefault SETUSER '스키마' SELECT T.name, A.name, B.name, B.type_desc, 'EXEC sp_bindefault '''+B.name+''', ''스키마.'+ T.name +'.'+A.name+'''' FROM sys.tables T INNER JOIN sys.columns A ON T.object_id = A.object_id INNER JOIN sys.objects B ON A.default_object_id = B.object_id WHERE T.name IN ( 테이블명 )
SAP 테이블 default 제약조건 추가
Archive/ABAP 2020. 12. 9. SAP 테이블 default 제약조건 추가 exec sp_bindefault 'num_default','DDNTF.BLOCKNR' docs.microsoft.com/ko-kr/sql/relational-databases/system-stored-procedures/sp-bindefault-transact-sql?view=sql-server-ver sp_bindefault (Transact-sql) - SQL Server sp_bindefault(Transact-SQL) docs.microsoft.com
SAP Web Dispatcher URL 필터
Archive/ABAP 2020. 4. 13. SAP Web Dispatcher URL 필터 환경 Kernel release : 773 설정파일 경로 /usr/sap//SYS/profile/__HostName 설정 정보 DIR_TABLE = \usr\sap\\SYS wdisp/permission_table = $(DIR_TABLE)\profile\__permission_table.txt Permission_Table P /sap/bc/srt/wsdl/bndg_E8D7FC49BF9E34F18A35002219A11DA8/* D /sap/bc/srt/wsdl/*
Web Service 권한 관리
Archive/ABAP 2020. 4. 13. Web Service 권한 관리 사용자에게 부여되는 Role를 만듭니다. 메뉴 버튼에서 Authorization Default를 선택하고 허용하고자 하는 Web Service를 선택합니다.
Archive/ABAP 2019. 10. 29. ODATA SERVICE FOR PURCHASE ORDER using RFC https://blogs.sap.com/2016/03/04/odata-service-for-purchase-order-using-rfc/ ODATA SERVICE FOR PURCHASE ORDER using RFC | SAP Blogs 4 Likes 10,765 Views 4 Comments blogs.sap.com
$filter Query Option in SAP OData Service
Archive/ABAP 2019. 8. 20. $filter Query Option in SAP OData Service Hello everyone, in this tutorial we will learn how to use filter query option in SAP OData service. Before proceeding further we assume that you know how to build OData service in sap gateway.Access all SAP Netweaver Gateway tutorials here.Lets get started What $filter query option does? Query option $filter adds filtering capabilities to the SAP gateway OData service. So that you can able to fi..
Simple Exercise on OData and SAP UI5 Application for the basic CRUD Operation
Archive/ABAP 2019. 7. 5. Simple Exercise on OData and SAP UI5 Application for the basic CRUD Operation 해당 내용의 원본 블로그 입니다. https://blogs.sap.com/2015/02/05/simple-exercise-on-odata-and-sap-ui5-application-for-the-basic-crud-operation/ Simple Exercise on OData and SAP UI5 Application for the basic CRUD Operation | SAP Blogs 68 Likes 143,423 Views 67 Comments blogs.sap.com Contents 1. Introduction 2. Creation of OData Service 2.1 Creation of OData Service 2.1.1 Pre-requisites 2.1.2 Creation of Data ..
SAP Gateway and OData
Archive/ABAP 2019. 7. 5. SAP Gateway and OData SAP Gateway and OData Use By exposing SAP Business Suite functionality as REST-based OData (Open Data Protocol) services, SAP Gateway enables SAP applications to share data with a wide range of devices, technologies, and platforms in a way that is easy to understand and consume. SAPGateway는 SAPBusinessSuite기능을 REST기반 OData(OpenDataProtocol)서비스로 노출함으로써 SAP애플리케이션이 이해하기 쉽고 이해하기 쉬운 방식으로 다양한 장치, 기술 및..

티스토리툴바