ONETIMEACCOUNTBP

29 Fields

ONETIMEACCOUNTBP is an SAP database table in S/4HANA. It contains 29 fields.

Fields (29)

KeyField CDS FieldsUsed in Views
KEY AccountingDocument AccountingDocument 1
KEY CompanyCode CompanyCode 1
_AccountingDocument _AccountingDocument 1
_Address _Address 1
_CompanyCode _CompanyCode 1
_FiscalYear _FiscalYear 1
AddressID AddressID 1
BusinessPartnerName1 BusinessPartnerName1 1
BusinessPartnerName2 BusinessPartnerName2 1
BusinessPartnerName3 BusinessPartnerName3 1
BusinessPartnerName4 BusinessPartnerName4 1
BusinessType BusinessType 1
CityName CityName 1
Country Country 1
IndustryType IndustryType 1
IsNaturalPerson IsNaturalPerson 1
OneTimeAccountBPSalutationText OneTimeAccountBPSalutationText 1
POBox POBox 1
POBoxPostalCode POBoxPostalCode 1
PostalCode PostalCode 1
Region Region 1
ResponsibleType ResponsibleType 1
StreetAddressName StreetAddressName 1
TaxID1 TaxID1 1
TaxID2 TaxID2 1
TaxID3 TaxID3 1
TaxID4 TaxID4 1
TaxID5 TaxID5 1
TaxNumberType TaxNumberType 1

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE ONETIMEACCOUNTBP (
    ACCOUNTINGDOCUMENT,
    COMPANYCODE,
    _ACCOUNTINGDOCUMENT,
    _ADDRESS,
    _COMPANYCODE,
    _FISCALYEAR,
    ADDRESSID,
    BUSINESSPARTNERNAME1,
    BUSINESSPARTNERNAME2,
    BUSINESSPARTNERNAME3,
    BUSINESSPARTNERNAME4,
    BUSINESSTYPE,
    CITYNAME,
    COUNTRY,
    INDUSTRYTYPE,
    ISNATURALPERSON,
    ONETIMEACCOUNTBPSALUTATIONTEXT,
    POBOX,
    POBOXPOSTALCODE,
    POSTALCODE,
    REGION,
    RESPONSIBLETYPE,
    STREETADDRESSNAME,
    TAXID1,
    TAXID2,
    TAXID3,
    TAXID4,
    TAXID5,
    TAXNUMBERTYPE,
    PRIMARY KEY (ACCOUNTINGDOCUMENT, COMPANYCODE)
);

Learn More