|
|
DTW Business Partners / Business Partner Master Data / BP Payment Dates
API Business Partners / BP Payment Dates
CRD5 - BP Payment Dates Table
BP Payment Dates BPPaymentDates Object· Table: CRD5
Parent: Business Partners BusinessPartners Object· Table: OCRD
Business Partner OCRD SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | CardCode KEY UNIQUE | BP Code | nVarChar | 15 | OCRD Business Partner | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| PmntDate | Payment Date | nVarChar | 2 | |||||
| LogInstanc | Log Instance | Int | 11 | 0 |
SELECT statement
SELECT
CRD5.CardCode AS 'BP Code',
CRD5.PmntDate AS 'Payment Date',
CRD5.LogInstanc AS 'Log Instance'
FROM CRD5 AS CRD5
Related information
BP Payment Dates BPPaymentDates Object· Table: CRD5
BPPaymentDates is a child object of BusinessPartners object that represents the payment days in the month for the business partner.
Source table: CRD5.
Parent: Business Partners BusinessPartners Object· Table: OCRD Business Partner OCRD SQL Table
BusinessPartners
Object
BPPaymentDates
Method
Property
PaymentDate
DTW DB
Collection
Enumeration
Method
Object
Branch OUBR
Method
Property
CampaignLineNumber
8.8.2 DB
CampaignNumber
8.8.2 DB
Details
8.8.2 DB
PartnerID
8.8.2 DB
RelatedBP
8.8.2 DB
RelationshipCode
8.8.2 DB
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
