|
|
DTW Inventory / Item Management / Batches / Business Partner Catalog Numbers
API OSCN / Alternate Cat Num
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | ItemCode KEY | Item No. | nVarChar | 20 | OITM Items | ITEM | No |
|---|---|---|---|---|---|---|---|---|
| CardCode | BP Code | nVarChar | 15 | OCRD Business Partner | ||||
| Substitute KEY | BP Catalog Number | nVarChar | 20 | SUBSTITUTE | No | |||
| Transfered | Postponed to Next Year | VarChar | Y) Yes N) No | 1 | N | |||
| DataSource | Data Source | VarChar | N) Unknown I) Interface U) Update M) Import O) DI API A) Doc. Generation Wizard D) Restore Wizard P) Partner Implementation T) Year Transfer | 1 | N | |||
| UserSign | User Signature | Int | 6 | OUSR Users | ||||
| UserSign2 | Updating User | Int | 6 | OUSR Users | ||||
| ShowSCN | Display BP Catalog Number | VarChar | Y) Yes N) No | 1 | N |
Table relationship map
SELECT statement
SELECT
OSCN.ItemCode AS 'Item No.',
OSCN.CardCode AS 'BP Code',
OSCN.Substitute AS 'BP Catalog Number',
OSCN.Transfered AS 'Postponed to Next Year',
OSCN.DataSource AS 'Data Source',
OSCN.UserSign AS 'User Signature',
OSCN.UserSign2 AS 'Updating User',
OSCN.ShowSCN AS 'Display BP Catalog Number'
FROM OSCN AS OSCN
Related information
Alternate Cat Num AlternateCatNum Object· Table: OSCN
AlternateCatNum is a business object that represents the alternative catalog numbers in the Business Partners module.
This object enables you to:
Add an alternative catalog number.
Retrieve an alternative catalog number by its key.
Update...
OSCN SQL Table
Business Partner OCRD SQL Table
Items OITM SQL Table
Users OUSR SQL Table
AlternateCatNum
Method
Property
CardCode
DTW DB
DisplayBPCatalogNumber
DTW DB
ItemCode
DTW DB
Substitute
DTW DB
Method
Object
ApprovalRequestLine WDD1
Property
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates