|
|
DTW Business Partners / Business Partner Master Data / Fiscal IDs for BP Master Data
API Business Partners / BP Fiscal Tax ID
CRD7 - Fiscal IDs for BP Master Data Table
BP Fiscal Tax ID BPFiscalTaxID Object· Table: CRD7
Parent: Business Partners BusinessPartners Object· Table: OCRD
Business Partner OCRD SQL Table
CNAE Code OCNA SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | CardCode KEY UNIQUE | BP Code | nVarChar | 25 | OCRD Business Partner | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| Address | Address | nVarChar | 50 | |||||
| TaxId0 | Tax ID 0 | nVarChar | 100 | |||||
| TaxId1 | Tax ID 1 | nVarChar | 100 | |||||
| TaxId2 | Tax ID 2 | nVarChar | 100 | |||||
| TaxId3 | Tax ID 3 | nVarChar | 100 | |||||
| TaxId4 | Tax ID 4 | nVarChar | 100 | |||||
| TaxId5 | Tax ID 5 | nVarChar | 100 | |||||
| TaxId6 | Tax ID 6 | nVarChar | 100 | |||||
| TaxId7 | Tax ID 7 | nVarChar | 100 | |||||
| TaxId8 | Tax ID 8 | nVarChar | 100 | |||||
| TaxId9 | Tax ID 9 | nVarChar | 100 | |||||
| CNAEId | Brazil CNAE Code | Int | 11 | OCNA CNAE Code | ||||
| TaxId10 | Tax ID 10 | nVarChar | 100 | |||||
| TaxId11 | Tax ID 11 | nVarChar | 100 | |||||
| AddrType | Address Type | VarChar | S) Ship To B) Bill to | 1 | S | |||
| ECCNo | E.C.C. No. | nVarChar | 40 | |||||
| CERegNo | C.E. Registration No. | nVarChar | 40 | |||||
| CERange | C.E. Range | nVarChar | 60 | |||||
| CEDivis | C.E. Division | nVarChar | 60 | |||||
| CEComRate | C.E. Commisionerate | nVarChar | 60 | |||||
| LogInstanc | Log Instance | Int | 11 | 0 | ||||
| SefazDate | Date of Update from SEFAZ | Date | 8 | |||||
| TaxId12 | Tax ID 12 | nVarChar | 50 | |||||
| TaxId13 | Deductee Ref. No. in India | nVarChar | 100 |
Table relationship map
SELECT statement
SELECT
CRD7.CardCode AS 'BP Code',
CRD7.Address AS 'Address',
CRD7.TaxId0 AS 'Tax ID 0',
CRD7.TaxId1 AS 'Tax ID 1',
CRD7.TaxId2 AS 'Tax ID 2',
CRD7.TaxId3 AS 'Tax ID 3',
CRD7.TaxId4 AS 'Tax ID 4',
CRD7.TaxId5 AS 'Tax ID 5',
CRD7.TaxId6 AS 'Tax ID 6',
CRD7.TaxId7 AS 'Tax ID 7',
CRD7.TaxId8 AS 'Tax ID 8',
CRD7.TaxId9 AS 'Tax ID 9',
CRD7.CNAEId AS 'Brazil CNAE Code',
CRD7.TaxId10 AS 'Tax ID 10',
CRD7.TaxId11 AS 'Tax ID 11',
CRD7.AddrType AS 'Address Type',
CRD7.ECCNo AS 'E.C.C. No.',
CRD7.CERegNo AS 'C.E. Registration No.',
CRD7.CERange AS 'C.E. Range',
CRD7.CEDivis AS 'C.E. Division',
CRD7.CEComRate AS 'C.E. Commisionerate',
CRD7.LogInstanc AS 'Log Instance',
CRD7.SefazDate AS 'Date of Update from SEFAZ',
CRD7.TaxId12 AS 'Tax ID 12',
CRD7.TaxId13 AS 'Deductee Ref. No. in India'
FROM CRD7 AS CRD7
Related information
BP Fiscal Tax ID BPFiscalTaxID Object· Table: CRD7
BPFiscalTaxID is a child object of the BusinessPartners and indicates the Brazilian Fiscal IDs info for each business partner.
You can retrieve or set this object by using the FiscalTaxID property of the BusinessPartners object.
This object...
Parent: Business Partners BusinessPartners Object· Table: OCRD Business Partner OCRD SQL Table
CNAE Code OCNA SQL Table
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
