SAP ABAP Table ROXCR30160 (Master Data: Trading Partner)
Hierarchy
☛
BI_CONT (Software Component) Business Intelligence Content
⤷ BW-BCT (Application Component) Business Content and Extractors
⤷ RS_BCT_MA (Package) BW: Content Marketplace
⤷ BW-BCT (Application Component) Business Content and Extractors
⤷ RS_BCT_MA (Package) BW: Content Marketplace
Basic Data
Table Category | INTTAB | Structure |
Structure | ROXCR30160 | Table Relationship Diagram |
Short Description | Master Data: Trading Partner |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | A | Application Table (Master- and Transaction Data) |
Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
Components
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|
---|---|---|---|---|---|---|---|---|---|
1 | PARTNERGUID | BU_PARTNER_GUID_BAPI | SYSUUID_C | CHAR | 32 | 0 | GUID of a Business Partner in CHAR 32 Format for BAPIs | ||
2 | BPARTNER | BU_PARTNER | BU_PARTNER | CHAR | 10 | 0 | Business Partner Number | * | |
3 | PARTN_CAT | BU_TYPE | BU_TYPE | CHAR | 1 | 0 | Business partner category | ||
4 | PARTN_TYP | BU_BPKIND | BU_KIND | CHAR | 4 | 0 | Business Partner Type | TB004 | |
5 | PARTN_GRP | BU_GROUP | BU_GROUP | CHAR | 4 | 0 | Business Partner Grouping | TB001 | |
6 | EXTERN_NO | BU_BPEXT | CHAR20 | CHAR | 20 | 0 | Business Partner Number in External System | ||
7 | ADDR_NO | AD_ADDRNUM | AD_ADDRNUM | CHAR | 10 | 0 | Address number | ADRC | |
8 | ADDRESSGUID | BU_ADDRESS_GUID_BAPI | SYSUUID_C | CHAR | 32 | 0 | GUID of a BP Address in CHAR 32 Format for BAPIs | ||
9 | EXTERNALADDRESSN | BU_ADEXT | BU_ADEXT | CHAR | 20 | 0 | Address number in external system | ||
10 | PARTNERROLE | BU_RLTYP | BU_RLTYP | CHAR | 6 | 0 | BDT: Object part | TBZ0 | |
11 | BANKDETAILID | BU_BKVID | CHAR4 | CHAR | 4 | 0 | Bank details ID | ||
12 | EXTERNALBANKDETA | BU_BKEXT | CHAR20 | CHAR | 20 | 0 | Bank details ID in external system | ||
13 | PARTNGUID | BU_PARTNER_GUID_BAPI | SYSUUID_C | CHAR | 32 | 0 | GUID of a Business Partner in CHAR 32 Format for BAPIs | ||
14 | PARTNROLE | BU_ROLE | BU_RLTYP | CHAR | 6 | 0 | BP role | * | |
15 | STANDARDADDRESS | BU_XDFADR | XFELD | CHAR | 1 | 0 | Indicator: Address is standard address | ||
16 | C_O_NAME | AD_NAME_CO | TEXT40 | CHAR | 40 | 0 | c/o name | ||
17 | CITY | AD_CITY1 | TEXT40 | CHAR | 40 | 0 | City | ||
18 | DISTRICT | AD_CITY2 | TEXT40 | CHAR | 40 | 0 | District | ||
19 | REGIOGROUP | REGIOGROUP | REGIOGROUP | CHAR | 8 | 0 | Regional structure grouping | ADRREGGRP | |
20 | POSTL_COD1 | AD_PSTCD1 | CHAR10 | CHAR | 10 | 0 | City postal code | ||
21 | POSTL_COD2 | AD_PSTCD2 | CHAR10 | CHAR | 10 | 0 | PO Box postal code | ||
22 | POSTL_COD3 | AD_PSTCD3 | CHAR10 | CHAR | 10 | 0 | Company postal code (for large customers) | ||
23 | PCODE1_EXT | AD_PST1XT | CHAR10 | CHAR | 10 | 0 | (Not Supported)City Postal Code Extension, e.g. ZIP+4+2 Code | ||
24 | PCODE2_EXT | AD_PST2XT | CHAR10 | CHAR | 10 | 0 | (Not Supported) PO Box Postal Code Extension | ||
25 | PCODE3_EXT | AD_PST3XT | CHAR10 | CHAR | 10 | 0 | (Not Supported) Major Customer Postal Code Extension | ||
26 | PO_BOX | AD_POBX | CHAR10 | CHAR | 10 | 0 | PO Box | ||
27 | PO_W_O_NO | AD_POBXNUM | XFELD | CHAR | 1 | 0 | Flag: PO Box without number | ||
28 | PO_BOX_CIT | AD_POBXLOC | TEXT40 | CHAR | 40 | 0 | PO Box city | ||
29 | PO_BOX_REG | AD_POBXREG | REGIO | CHAR | 3 | 0 | Region for PO Box (Country, State, Province, ...) | T005S | |
30 | POBOX_CTRY | AD_POBXCTY | LAND1 | CHAR | 3 | 0 | PO box country | T005 | |
31 | PO_CTRYISO | INTCA | INTCA | CHAR | 2 | 0 | Country ISO code | ||
32 | STREET | AD_STREET | TEXT60 | CHAR | 60 | 0 | Street | ||
33 | STR_ABBR | AD_STRABBR | STRTYPEAB | CHAR | 2 | 0 | (Not Supported) Abbreviation of Street Name | ADRSTRTYPE | |
34 | HOUSE_NO | AD_HSNM1 | TEXT10 | CHAR | 10 | 0 | House Number | ||
35 | HOUSE_NO2 | AD_HSNM2 | TEXT10 | CHAR | 10 | 0 | House number supplement | ||
36 | HOUSE_NO3 | AD_HSNM3 | TEXT10 | CHAR | 10 | 0 | (Not supported) House Number Range | ||
37 | STR_SUPPL1 | AD_STRSPP1 | TEXT40 | CHAR | 40 | 0 | Street 2 | ||
38 | STR_SUPPL2 | AD_STRSPP2 | TEXT40 | CHAR | 40 | 0 | Street 3 | ||
39 | STR_SUPPL3 | AD_STRSPP3 | TEXT40 | CHAR | 40 | 0 | Street 4 | ||
40 | LOCATION | AD_LCTN | TEXT40 | CHAR | 40 | 0 | Street 5 | ||
41 | BUILDING | AD_BLDNG | TEXT20 | CHAR | 20 | 0 | Building (Number or Code) | ||
42 | FLOOR | AD_FLOOR | TEXT10 | CHAR | 10 | 0 | Floor in building | ||
43 | ROOM_NO | AD_ROOMNUM | TEXT10 | CHAR | 10 | 0 | Room or Appartment Number | ||
44 | COUNTRY | LAND1 | LAND1 | CHAR | 3 | 0 | Country Key | T005 | |
45 | COUNTRYISO | INTCA | INTCA | CHAR | 2 | 0 | Country ISO code | ||
46 | REGION | REGIO | REGIO | CHAR | 3 | 0 | Region (State, Province, County) | T005S | |
47 | TIME_ZONE | AD_TZONE | TZNZONE | CHAR | 6 | 0 | Address time zone | TTZZ | |
48 | TAXJURCODE | AD_TXJCD | AD_TXJCD | CHAR | 15 | 0 | Tax Jurisdiction | ||
49 | HOME_CITY | AD_CITY3 | TEXT40 | CHAR | 40 | 0 | City (different from postal city) | ||
50 | TRANSPZONE | LZONE | ZONE | CHAR | 10 | 0 | Transportation zone to or from which the goods are delivered | * | |
51 | LANGU | SPRAS | SPRAS | LANG | 1 | 0 | Language Key | * | |
52 | LANGUISO | LAISO | LAISO | CHAR | 2 | 0 | 2-Character SAP Language Code | ||
53 | NAME1 | BU_NAMEOR1 | BU_NAME | CHAR | 40 | 0 | Name 1 of organization | ||
54 | NAME2 | BU_NAMEOR2 | BU_NAME | CHAR | 40 | 0 | Name 2 of organization | ||
55 | NAME3 | BU_NAMEOR3 | BU_NAME | CHAR | 40 | 0 | Name 3 of organization | ||
56 | NAME4 | BU_NAMEOR4 | BU_NAME | CHAR | 40 | 0 | Name 4 of organization | ||
57 | LEGALFORM | BU_LEGENTY | BU_LEGENTY | CHAR | 2 | 0 | BP: Legal form of organization | TB019 | |
58 | INDUSTRYSECTOR | BU_INDSECT | BU_INDSECT | CHAR | 10 | 0 | Industry sector | TB023 | |
59 | FOUNDATIONDATE | BU_FOUND_DAT | DATUM | DATS | 8 | 0 | Date organization founded | ||
60 | LIQUIDATIONDATE | BU_LIQUID_DAT | DATS | 8 | 0 | Liquidation date of organization | |||
61 | LOC_NO_1 | BBBNR | NUM07 | NUMC | 7 | 0 | International location number (part 1) | ||
62 | LOC_NO_2 | BBSNR | NUM05 | NUMC | 5 | 0 | International location number (Part 2) | ||
63 | CHK_DIGIT | BUBKZ | NUM01 | NUMC | 1 | 0 | Check digit for the international location number | ||
64 | TPDISPNAME | CHAR255 | CHAR255 | CHAR | 255 | 0 | Char255 | ||
65 | MA_TP_FLAG | RSBCTMA_TP_FLAG | NUMC | 10 | 0 | Ind.: Marketplace Trading Partner Log Off | |||
66 | TIMESTAMP | TIMESTAMP | TZNTSTMPS | DEC | 15 | 0 | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | ROXCR30160 | ADDR_NO | ADRC | ADDRNUMBER | 1 | C | |
2 | ROXCR30160 | COUNTRY | T005 | LAND1 | 1 | CN | |
3 | ROXCR30160 | INDUSTRYSECTOR | TB023 | IND_SECTOR | 1 | CN | |
4 | ROXCR30160 | LEGALFORM | TB019 | LEGAL_ENTY | KEY | 1 | CN |
5 | ROXCR30160 | PARTNERROLE | TBZ0 | RLTYP | KEY | 1 | CN |
6 | ROXCR30160 | PARTN_GRP | TB001 | BU_GROUP | 1 | CN | |
7 | ROXCR30160 | PARTN_TYP | TB004 | BPKIND | 1 | CN | |
8 | ROXCR30160 | POBOX_CTRY | T005 | LAND1 | C | CN | |
9 | ROXCR30160 | PO_BOX_REG | T005S | BLAND | C | CN | |
10 | ROXCR30160 | REGIOGROUP | ADRREGGRP | REGIOGROUP | C | CN | |
11 | ROXCR30160 | REGION | T005S | BLAND | C | CN | |
12 | ROXCR30160 | STR_ABBR | ADRSTRTYPE | STRTYPEAB | C | CN | |
13 | ROXCR30160 | TIME_ZONE | TTZZ | TZONE | C | CN |
History
Last changed by/on | SAP | 20141031 |
SAP Release Created in | 310 |