Click here to Skip to main content
15,845,742 members

Comments by S Shuaib Ahmed (Top 3 by date)

S Shuaib Ahmed 5-Jun-23 7:03am View    
SAP is a schema
S Shuaib Ahmed 5-Jun-23 6:58am View    
I have tried with a ; also no response.
S Shuaib Ahmed 5-Jun-23 6:53am View    
Hi!
select * from SAP.SAP_REQUISITION_HEADERS
this is the table I am executing
below is the table structure
CREATE TABLE [SAP].[SAP_REQUISITION_HEADERS](
[REQUISITION_ID] [numeric](18, 0) IDENTITY(1000,1) NOT NULL,
[REQUISITION_NUMBER] [nvarchar](60) NOT NULL,
[TITLE] [nvarchar](240) NOT NULL,
[REQ_STATUS] [nvarchar](50) NOT NULL,
[PREPARER_ID] [numeric](18, 0) NOT NULL,
[REQ_BU_ID] [numeric](18, 0) NOT NULL,
[DESCRIPTION] [nvarchar](240) NULL,
[NOTE_TO_APPROVER] [nvarchar](1000) NULL,
[EMERGENCY_REQ_FLAG] [nvarchar](1) NULL,
[CAT_ITEM_ID] [numeric](18, 0) NULL,
[IFACE_SOURCE_CODE] [nvarchar](25) NULL,
[IFACE_SOURCE_LINE_ID] [numeric](18, 0) NULL,
[SUBMISSION_DATE] [datetime] NULL,
[APPROVED_DATE] [datetime] NULL,
[APPROVED_BY] [numeric](18, 0) NULL,
[HAS_WITHDRAWN_LINES] [nvarchar](1) NOT NULL,
[HAS_CANCELED_LINES] [nvarchar](1) NOT NULL,
[HAS_RETURNED_LINES] [nvarchar](1) NOT NULL,
[HAS_REJECTED_LINES] [nvarchar](1) NOT NULL,
[HAS_INCOMPLETE_LINES] [nvarchar](1) NOT NULL,
[HAS_PENDING_APPR_LINES] [nvarchar](1) NOT NULL,
[FUNDS_STATUS] [nvarchar](30) NULL,
[REVISION_NO] [numeric](18, 0) NOT NULL,
[FUNDS_CHK_FAIL_WARN_FLAG] [nvarchar](1) NOT NULL,
[BUDGET_CONTROL_ENABLED_FLAG] [nvarchar](1) NOT NULL,
[INSUFFICIENT_FUNDS_FLAG] [nvarchar](1) NOT NULL,
[INTERNAL_TRANSFER_REQ_FLAG] [nvarchar](1) NOT NULL,
[CREATED_BY] [numeric](18, 0) NOT NULL,
[CREATION_DATE] [datetime] NOT NULL,
[LAST_UPDATED_BY] [numeric](18, 0) NOT NULL,
[LAST_UPDATE_DATE] [datetime] NOT NULL,
[LAST_UPDATE_LOGIN] [numeric](18, 0) NOT NULL,
[ENABLE_FLAG] [nvarchar](1) NULL,
[APPROVAL_STATUS] [nvarchar](50) NULL,
[APPROVAL_KEY] [nvarchar](50) NULL,
[APPROVAL_TYPE] [nvarchar](50) NULL,
[CATALOG_TYPE] [nvarchar](100) NULL,
[REQUESTER_ID] [numeric](18, 0) NULL,
[SHIP_TO_LOCATION_ID] [numeric](18, 0) NULL,
[DEFAULT_TAXATION_COUNTRY] [nvarchar](10) NULL,
[SHIP_TO_LOCATION_CODE] [nvarchar](60) NULL
) ON [PRIMARY]
GO

ALTER TABLE [SAP].[SAP_REQUISITION_HEADERS] ADD DEFAULT ('N') FOR [HAS_WITHDRAWN_LINES]
GO

ALTER TABLE [SAP].[SAP_REQUISITION_HEADERS] ADD DEFAULT ('N') FOR [HAS_CANCELED_LINES]
GO

ALTER TABLE [SAP].[SAP_REQUISITION_HEADERS] ADD DEFAULT ('N') FOR [HAS_RETURNED_LINES]
GO

ALTER TABLE [SAP].[SAP_REQUISITION_HEADERS] ADD DEFAULT ('N') FOR [HAS_REJECTED_LINES]
GO

ALTER TABLE [SAP].[SAP_REQUISITION_HEADERS] ADD DEFAULT ('N') FOR [HAS_INCOMPLETE_LINES]
GO

ALTER TABLE [SAP].[SAP_REQUISITION_HEADERS] ADD DEFAULT ('N') FOR [HAS_PENDING_APPR_LINES]
GO

ALTER TABLE [SAP].[SAP_REQUISITION_HEADERS] ADD DEFAULT ((0)) FOR [REVISION_NO]
GO

ALTER TABLE [SAP].[SAP_REQUISITION_HEADERS] ADD DEFAULT ('N') FOR [FUNDS_CHK_FAIL_WARN_FLAG]
GO

ALTER TABLE [SAP].[SAP_REQUISITION_HEADERS] ADD DEFAULT ('N') FOR [BUDGET_CONTROL_ENABLED_FLAG]
GO

ALTER TABLE [SAP].[SAP_REQUISITION_HEADERS] ADD DEFAULT ('N') FOR [INSUFFICIENT_FUNDS_FLAG]
GO

ALTER TABLE [SAP].[SAP_REQUISITION_HEADERS] ADD DEFAULT ('N') FOR [INTERNAL_TRANSFER_REQ_FLAG]
GO

ALTER TABLE [SAP].[SAP_REQUISITION_HEADERS] ADD DEFAULT ('Y') FOR [ENABLE_FLAG]