I_PT_SAFTCUSTADDRHIST

CDS View
13 Fields 4 CDS Views

SAF-T PT Customer Address History

I_PT_SAFTCUSTADDRHIST is a CDS View in S/4HANA. SAF-T PT Customer Address History. It contains 13 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
I_PT_DelDocCustAddrHist view inner COMPOSITE SAF-T PT Delivery Doc CustAddr History
I_PT_DelDocCustAddrHist_2 view_entity inner COMPOSITE SAFT PT Delivery Doc CustAddr History
I_PT_SAFTAcctgDocCustAddrHist view inner COMPOSITE SAF-T PT AccountingDoc CustAddr History
I_PT_SAFTBillgDocCustAddrHist view inner COMPOSITE SAF-T PT BillingDoc CustAddr History

Fields (13)

KeyField CDS FieldsUsed in Views
KEY Customer Customer 3
_Customer _Customer 3
CityName CityName 4
CompanyName CompanyName 4
Country Country 4
CustomerSupplierAddress CustomerSupplierAddress,PT_CustomerSupplierAddressText 4
CustomerVATRegistration CustomerVATRegistration 4
EmailAddress EmailAddress 4
FaxNumber FaxNumber 3
PhoneNumber PhoneNumber 4
PostalCode PostalCode 4
PT_SAFTBPFullAddressText PT_SAFTBPFullAddressText 2
SearchURLAddress SearchURLAddress 4

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.

-- SAF-T PT Customer Address History
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_PT_SAFTCUSTADDRHIST (
    CUSTOMER,
    _CUSTOMER,
    CITYNAME,
    COMPANYNAME,
    COUNTRY,
    CUSTOMERSUPPLIERADDRESS,
    CUSTOMERVATREGISTRATION,
    EMAILADDRESS,
    FAXNUMBER,
    PHONENUMBER,
    POSTALCODE,
    PT_SAFTBPFULLADDRESSTEXT,
    SEARCHURLADDRESS,
    PRIMARY KEY (CUSTOMER)
);

Learn More