SAP ABAP Table SPCIPOSDS (Optional Suppliers and Distributors)
Hierarchy
☛
ECC-DIMP (Software Component) DIMP
⤷ IS-AD-SPC-PR (Application Component) Provisioning
⤷ AD_SPC_PH3_IP (Package) SPEC 2000 Initial Provisioning
⤷ IS-AD-SPC-PR (Application Component) Provisioning
⤷ AD_SPC_PH3_IP (Package) SPEC 2000 Initial Provisioning
Basic Data
Table Category | TRANSP | Transparent table |
Transparent table | SPCIPOSDS | Table Relationship Diagram |
Short Description | Optional Suppliers and Distributors |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | A | Application Table (Master- and Transaction Data) |
Data Browser/Table View Maintenance | X | Display/Maintenance Allowed |
Components
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|
---|---|---|---|---|---|---|---|---|---|
1 | CLIENT | SYMANDT | MANDT | CLNT | 3 | 0 | Client ID | SPCIPPDS | |
2 | SQNBR | ADSPC_SQNBR | ADSPC_SRNBR | NUMC | 5 | 0 | Sequence Number | SPCIPPDS | |
3 | PNR | ADSPC_PNR | CHAR15 | CHAR | 15 | 0 | Part Number | SPCIPPDS | |
4 | MFR | ADSPC_MFR | CHAR5 | CHAR | 5 | 0 | Manufacturer Code | SPCIPPDS | |
5 | SPL | ADSPC_SPL | CHAR5 | CHAR | 5 | 0 | Supplier Code | ||
6 | SRNBR | ADSPC_SRNBR | ADSPC_SRNBR | NUMC | 5 | 0 | Serial number | ||
7 | OSCDSTTP | ADSPC_OSCDSTTP | ADSPC_OSCDSTTP | CHAR | 1 | 0 | Identifier that tells if it is an OSC or a DST | ||
8 | OSCDST | ADSPC_OSCDST | ADSPC_MFR | CHAR | 5 | 0 | Optional Supplier Code / Distributor Code | ||
9 | OBJ | ADSPCIP_RANGE | ADSPCIP_RANGE | CHAR | 20 | 0 | Object for Status Management | ||
10 | DELFLG | ADSPC_DELETION_FLAG | CHAR1 | CHAR | 1 | 0 | Deletion Flag for IP |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | SPCIPOSDS | CLIENT | SPCIPPDS | CLIENT | 1 | N | |
2 | SPCIPOSDS | MFR | SPCIPPDS | MFR | 1 | N | |
3 | SPCIPOSDS | PNR | SPCIPPDS | PNR | 1 | N | |
4 | SPCIPOSDS | SQNBR | SPCIPPDS | SQNBR | 1 | N |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in | 46C2 |