The CNTRLPCADDRTP_D table in SAP ERP or S/4HANA stores I_CNTRLPURCONTRADDRESSTP I_CNTRLPURCONTRADDRESSTP data. There are total 54 fields in CNTRLPCADDRTP_D table. The I_CNTRLPURCONTRADDRESSTP I_CNTRLPURCONTRADDRESSTP table is available in all major SAP S/4HANA versions, is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of CNTRLPCADDRTP_D table. It is in SAP S/4HANA Outline Agreements – Central Purchase Contract (APPL_MM_PUR_OA_CCTR) ABAP package and is part of the Vendor Outline Agreements (MM-PUR-OA) module.
SAP CNTRLPCADDRTP_D Table Fields
Following is the list of fields that are available in SAP CNTRLPCADDRTP_D table. The primary key fields of the table are MANDT (Client), DRAFTUUID (UUID serving as key (parent key, root key)).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| MANDT | Client | MANDT | CLNT (3) | |
| DRAFTUUID | UUID serving as key (parent key, root key) | /BOBF/UUID | RAW (16) | |
| CENTRALPURCHASECONTRACT | Central Purchase Contract | VDM_CENTRALPURCHASECONTRACT | CHAR (10) | |
| CENTRALPURCHASECONTRACTITEM | Central Purchase Contract Item | VDM_CNTRLPURCHASECONTRACTITEM | NUMC (5) | |
| ADDRESSID | Address Number | AD_ADDRNUM | CHAR (10) | |
| PLANT | Plant | EWERK | CHAR (4) | |
| CAREOFNAME | c/o name | AD_NAME_CO | CHAR (40) | |
| ADDITIONALSTREETSUFFIXNAME | Street 5 | AD_LCTN | CHAR (40) | |
| CORRESPONDENCELANGUAGE | Language Key | SPRAS | LANG (1) | |
| PRFRDCOMMMEDIUMTYPE | Communication Method (Key) (Business Address Services) | AD_COMM | CHAR (3) | |
| POBOX | PO Box | AD_POBX | CHAR (10) | |
| POBOXISWITHOUTNUMBER | Flag: PO Box Without Number | AD_POBXNUM | CHAR (1) | |
| POBOXPOSTALCODE | PO Box Postal Code | AD_PSTCD2 | CHAR (10) | |
| POBOXLOBBYNAME | PO Box Lobby | AD_PO_BOX_LBY | CHAR (40) | |
| POBOXDEVIATINGCITYNAME | PO Box city | AD_POBXLOC | CHAR (40) | |
| POBOXDEVIATINGREGION | Region for PO Box (Country/Region, State, Province, …) | AD_POBXREG | CHAR (3) | |
| POBOXDEVIATINGCOUNTRY | PO box country | AD_POBXCTY | CHAR (3) | |
| DELIVERYSERVICETYPECODE | Type of Delivery Service | AD_DELIVERY_SERVICE_TYPE | CHAR (4) | |
| DELIVERYSERVICENUMBER | Number of Delivery Service | AD_DELIVERY_SERVICE_NUMBER | CHAR (10) | |
| ADDRESSTIMEZONE | Address time zone | AD_TZONE | CHAR (6) | |
| FULLNAME | Full name of a party (Bus. Partner, Org. Unit, Doc. address) | ADFULLNAME | CHAR (80) | |
| CITYNAME | City | AD_CITY1 | CHAR (40) | |
| DISTRICT | District | AD_CITY2 | CHAR (40) | |
| CITYCODE | City code for city/street file | AD_CITYNUM | CHAR (12) | |
| HOMECITYNAME | City (different from postal city) | AD_CITY3 | CHAR (40) | |
| POSTALCODE | City postal code | AD_PSTCD1 | CHAR (10) | |
| COMPANYPOSTALCODE | Company Postal Code (for Large Customers) | AD_PSTCD3 | CHAR (10) | |
| STREETNAME | Street | AD_STREET | CHAR (60) | |
| STREETPREFIXNAME | Street 2 | AD_STRSPP1 | CHAR (40) | |
| ADDITIONALSTREETPREFIXNAME | Street 3 | AD_STRSPP2 | CHAR (40) | |
| STREETSUFFIXNAME | Street 4 | AD_STRSPP3 | CHAR (40) | |
| HOUSENUMBER | House Number | AD_HSNM1 | CHAR (10) | |
| HOUSENUMBERSUPPLEMENTTEXT | House number supplement | AD_HSNM2 | CHAR (10) | |
| BUILDING | Building (Number or Code) | AD_BLDNG | CHAR (20) | |
| FLOOR | Floor in building | AD_FLOOR | CHAR (10) | |
| ROOMNUMBER | Room or Apartment Number | AD_ROOMNUM | CHAR (10) | |
| COUNTRY | Country/Region Key | LAND1 | CHAR (3) | |
| REGION | Region (State, Province, County) | REGIO | CHAR (3) | |
| COUNTY | County | AD_COUNTY | CHAR (40) | |
| FORMOFADDRESS | Form-of-Address Key | AD_TITLE | CHAR (4) | |
| CONSIGNEENAME3 | Name 3 | AD_NAME3 | CHAR (40) | |
| CONSIGNEENAME4 | Name 4 | AD_NAME4 | CHAR (40) | |
| TAXJURISDICTION | Tax Jurisdiction | AD_TXJCD | CHAR (15) | |
| TRANSPORTZONE | Transportation zone to or from which the goods are delivered | LZONE | CHAR (10) | |
| PHONENUMBER | Telephone no.: dialling code+number | AD_TLNMBR | CHAR (30) | |
| MOBILEPHONENUMBER | Telephone no.: dialling code+number | AD_TLNMBR | CHAR (30) | |
| FAXNUMBER | Fax number: dialling code+number | AD_FXNMBR | CHAR (30) | |
| EMAILADDRESS | E-Mail Address | AD_SMTPADR | CHAR (241) | |
| HASACTIVEENTITY | Draft – Indicator – Has active document | SDRAFT_HAS_ACTIVE | CHAR (1) | |
| DRAFTENTITYCREATIONDATETIME | Draft Created On | SDRAFT_CREATED_AT | DEC (21) | |
| DRAFTENTITYLASTCHANGEDATETIME | Draft Last Changed On | SDRAFT_LAST_CHANGED_AT | DEC (21) | |
| DRAFTADMINISTRATIVEDATAUUID | Technical ID for the Administrative Data of a Draft Document | SDRAFT_ADMIN_UUID | RAW (16) | |
| DRAFTENTITYCONSISTENCYSTATUS | Draft Consistency Status | SDRAFT_CONSISTENCY_STATUS | CHAR (1) | |
| DRAFTENTITYOPERATIONCODE | Draft – Operation Code | SDRAFT_OPERATION_CODE | CHAR (1) |
