| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | CLNT | (N'000') | No | * | MANDT | Allow NULL? |
| 2 | PROFILE | Contact search/display profile | nvarchar | 15 | 0 | CHAR | (N' ') | No | | CCMCSPROFILE | Allow NULL? |
| 3 | CREATE_FUNC | Name of Function Module | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | TFDIR | RS38L_FNAM | Allow NULL? |
| 4 | COMP | IS-M: Component | nvarchar | 3 | 0 | CHAR | (N' ') | No | | ISM_COMP | Allow NULL? |
| 5 | XGPNAME | IS-M/AM: Address Search Using BP Name Only | char | 1 | 0 | CHAR | (N' ') | No | | XGPNAME_ZE | Allow NULL? |
| 6 | VKORG | IS-M: Sales Organization CIC Memory for M/AM Component | nvarchar | 4 | 0 | CHAR | (N' ') | No | * | ISM_VKORG_MAM | Allow NULL? |
| 7 | VTWEG | IS-M: Distribution Channel CIC Memory for M/AM Component | nvarchar | 2 | 0 | CHAR | (N' ') | No | * | ISM_VTWEG_MAM | Allow NULL? |
| 8 | SPART | IS-M: Division of CIC Memory for M/AM Component | nvarchar | 2 | 0 | CHAR | (N' ') | No | * | ISM_SPART_MAM | Allow NULL? |
| 9 | XKPL_SUCHE | IS-M: Addr.Search Incl.Major Customer and PO Box Addresses | char | 1 | 0 | CHAR | (N' ') | No | | IS_KPLFIND | Allow NULL? |
| 10 | GROUP_SALESAREA | IS-M: Sales Area Group for Business Partner Selection | nvarchar | 4 | 0 | CHAR | (N' ') | No | TJH_GR_SALESAREA | GROUP_SALESAREA | Allow NULL? |
| 11 | X_FIRSTMEDIACUST | IS-M: BP Selection List - Display Media Customers Only First | char | 1 | 0 | CHAR | (N' ') | No | | X_FIRSTMEDIACUST | Allow NULL? |
| 12 | DOC_TYPE_DEF_MAM | IS-M: CIC: Interpretation of Variable BP Search Field | char | 1 | 0 | CHAR | (N' ') | No | | ISM_DOCUMENT_TYPE | Allow NULL? |
| 13 | DOC_TYPE_DEF_MSD | IS-M: CIC: Interpretation of Variable BP Search Field | char | 1 | 0 | CHAR | (N' ') | No | | ISM_DOCUMENT_TYPE | Allow NULL? |
| 14 | DOC_TYPE_DEF_SBS | IS-M: CIC: Interpretation of Variable BP Search Field | char | 1 | 0 | CHAR | (N' ') | Yes | | ISM_DOCUMENT_TYPE | Allow NULL? |
| 15 | DOC_TYPE_DEF_SCS | IS-M: CIC: Interpretation of Variable BP Search Field | char | 1 | 0 | CHAR | (N' ') | Yes | | ISM_DOCUMENT_TYPE | Allow NULL? |
| 16 | XNO_COMP_CHANGE | IS-M: CIC, 'No Component Change' Indicator | char | 1 | 0 | CHAR | (N' ') | No | | XCICCOMP_CHANGE_NOT_ALLOWED | Allow NULL? |
| 17 | AUTOCONTINUE | Automatically continue | char | 1 | 0 | CHAR | (N' ') | No | | CCMAUTOCONTINUE | Allow NULL? |
| 18 | DEF_CURSOR | IS-M: Start Cursor Position in M/AM CtlAcc, ClOrdEtry + CIC | char | 1 | 0 | NUMC | (N'0') | No | | DEF_CURSOR | Allow NULL? |
| 19 | SEARCH_AREA | IS-M: CIC, Search Area | char | 1 | 0 | CHAR | (N' ') | No | | ISM_CIC_SEARCH_AREA | Allow NULL? |
| 20 | SEARCH_AREA_CHNG | IS-M: CIC, Indicator 'Change of Search Area not Possible' | char | 1 | 0 | CHAR | (N' ') | Yes | | ISM_CIC_SEARCH_AREA_CHANGE | Allow NULL? |
| 21 | MIN_NUM_ITEMS | IS-M: CIC, Minimum Number of Items for Major Customers | nvarchar | 4 | 0 | NUMC | (N'0000') | No | | ISM_CIC_MIN_NUM_ITEMS_BIG_CUST | Allow NULL? |
| 22 | VKORG_MSD | IS-M: Sales Organization CIC Memory for M/SD Component | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | ISM_VKORG_MSD | Allow NULL? |
| 23 | VTWEG_MSD | IS-M: Distribution Channel CIC Memory for M/SD Component | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | ISM_VTWEG_MSD | Allow NULL? |
| 24 | SPART_MSD | IS-M: Division of CIC Memory for M/SD Component | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | ISM_SPART_MSD | Allow NULL? |
| 25 | LAND1 | Country Key | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | T005 | LAND1 | Allow NULL? |
| 26 | XBPCREATE_NEWSCR | IS-M: Indicator - Use New Entry Screen for CIC BP Creation | char | 1 | 0 | CHAR | (N' ') | Yes | | ISM_XBPREATE_NEWSCR | Allow NULL? |
| 27 | XSE_SEARCH | Search Using Search Engine Service | char | 1 | 0 | CHAR | (N' ') | Yes | | ISM_XSEARCH_ENGINE_SEARCH | Allow NULL? |
| 28 | XCOMP_ACTIVE_MAM | IS-M: CIC, BP Search, 'Component Active' Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | ISM_CIC_XCOMP_ACTIVE | Allow NULL? |
| 29 | XCOMP_ACTIVE_MSD | IS-M: CIC, BP Search, 'Component Active' Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | ISM_CIC_XCOMP_ACTIVE | Allow NULL? |
| 30 | XCOMP_ACTIVE_SBS | IS-M: CIC, BP Search, 'Component Active' Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | ISM_CIC_XCOMP_ACTIVE | Allow NULL? |
| 31 | XCOMP_ACTIVE_SCS | IS-M: CIC, BP Search, 'Component Active' Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | ISM_CIC_XCOMP_ACTIVE | Allow NULL? |
